CIS 336 iLab 1 Normal Forms and Entity Relationship Diagrams CIS 336 iLab 1 Normal Forms and Entity Relationshi

CIS 336 iLab 1 Normal Forms and Entity Relationship
Diagrams
Click Below Link To Purchase
www.foxtutor.com/product/cis-336-ilab-1-normal-forms-and-entity-
relationship-diagrams
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
1022 9780321833877 2015-03-09 MySQL, Fifth Edition 1029 Addison-Wesley 5 33.95