CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 43

===================================================
CIS 336 iLab 1 Normal Forms and Entity Relationship
Diagrams
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