In this exercise , you will analyze a de-normalized data set presented in the form of a spreadsheet . You will next construct a series of dependency diagrams , transforming the evolving data model from First Normal Form ( 1NF ), to Second Normal Form ( 2NF ), and finally to Third Normal Form ( 3NF ). When the model has reached 3NF , you will construct the Entity Relationship Diagram ( ERD ) depicting the logical design of the database . Your ERD will use Crow ‘ s Foot notation to denote the relationships between tables .
Sample Exercise , With Solution
Before completing your lab , please review this example problem . The diagram below is a partial depiction of a business spreadsheet for a retail store operation . The store sells books . Books have a 13-digit International Standard Book Number ( ISBN ), a title , a publisher , and a unit price . Invoices track sales of books . An Invoice contains one or many line items , with each line item reflecting the sale of one or more copies of a specific book . Every publisher has a company name , and a publisher code .
InvNum ISBN13 InvDateBookTitlePubCodePubNameQtyunitPrice
1022 9781291940336 2015-03-09 MYSQL Functions 1001 Lulu . com 3 4.99
1022 9780321833877 2015-03-09 MySQL , Fifth Edition 1029 Addison-Wesley 5 33.95
1022 9781890774820 2015-03-09 Murach ‘ s MySQL , 2nd Edition 1032 Murach , Mike & Associates , Inc 2 48.95
1249 9781449374020 2015-02-22 MySQL Cookbook : Solutions for Database Developers and Administrators 1118 O ‘ Reilly Media , Incorporated 9 50.59