FOR MORE CLASSES VISIT www . cis336study . com
CIS336 Lab 1 : Normal Forms and Entity Relationship Diagrams Introduction
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