PART 1 (40 marks) Develop an Entity Relationship Diagram (ERD) for a given business rules and documents as follows. Giant University library wants to create a database system to manage their system based on the following report and business rules: Question A. Do normalization process and find 3NF of the following report: collection ID Collection Title Publisher ID Publisher Name Borrower ID Borrower Name Return Date Over due Penalty Total 1 Book-1 P-1 Publisher-1 A-111 Andrew Brown 1/1/14 2 1 2 B-112 Bill Wood 31/1/14 3 1 3 A-111 Andrew Brown 3/6/14 10 1 10 2 Journal-1 P-2 Publisher-2 A-100 Ashley Cole 2/1/14 2 3 6 A-112 Andy Gray 25/3/14 0 3 0 A-111 Andrew Brown 26/4/14 12 3 36 C-224 Charlie Chaplin 17/8/14 0 3 0 3 Mag-1 P-1 Publisher-1 D-100 Daniel Pinto 25/4/14 20 1 20 B-112 Bill Wood 21/9/14 0 1 0 Create an Entity Relationship Diagram based on the entities and relations found in 3NF. Question B. Add database design for the following business rules to the ERD. 1. The library provides a number of various collections include BOOKs, JOURNALs and MAGAZINEs. Every collection needs to have a collection code, title, year, publisher name, and ISSN or ISBN. In addition to the collection attributes, every book has at least one author. A journal usually has a volume and number attributes. A journal consists of journal papers, and a journal paper can be written by many authors. 2. Collections which have multiple copies must have a unique collection code for each copy.