Solution Code: 1DDH
This assignment is related to ”Data Base” and experts at My Assignment Services AU successfully delivered HD quality work within the given deadline.
These assignments are solved by our professional Database Experts at My Assignment Services AU and the solution are high quality of work as well as 100% plagiarism free. The assignment solution was delivered within 2-3 Days.
Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Normalization technique allows reducing data redundancy in the tables as well as eliminates the data anomalies like insert, update and delete anomalies. Normalization naturally works from stages, 1 NF to 4 NF.
In case of 1 NF (Normal Form), all attributes of a table must be dependent on the PK (Primary Key). Same data should not be stored in more than one table.
The functional dependency diagram of the given table is,-
The functional dependency diagram for three cases are,-
So, the 2 NF Tables from that above 1 NF Table are shown as below,-
Table 1: BOOK_Info
Table 2: Publisher_Info
Table 3: Borrower_dtls
The above 2NF Tables can be further decomposed into 3NF Tables if and only if two non-keys attributes are dependent on each other in a Table.
The Functional Dependency Diagram for Table 2: Publisher_Info is as follows,-
Here, Book_ID is the primary key, the non-key attributes like Date_Published, Publisher are dependent on the Primary key. Again, two non-key attributes like Publisher and Publ_Location are dependent on each other. So, the relation is further decomposed into 3NF as follows,-.
Table 2.1: Publisher_Info1
Table 2.2: Publisher_Info2
Ques 3)The Screenshot of ERD for the above relation is shown below,-
Fig: ERD drawn on MS-Visio 2007 software
From the ERD, the Entities and their Attributes, PK (Primary Key), FK(Foreign Key) with relationship details are discussed as below,-
Find Solution for Database assignment by dropping us a mail at firstname.lastname@example.org along with the question’s URL. Get in Contact with our experts at My Assignment Services AU and get the solution as per your specification & University requirement.
Doing your Assignment with our resources is simple, take Expert assistance to ensure HD Grades. Here you Go....