CIS336 iLab Week 1

$10.50

CIS336 iLab Week 1
In this exercise, you will analyze a de-normalized data set presented in the form of a spreadsheet. You will…

SKU: CIS336 iLab Week 1 Categories: , Tags: , , ,

Description

CIS336 iLab Week 1

CIS336 iLab Week 1

A+

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.

InvNumISBN13InvDateBookTitlePubCodePubNameQtyunitPrice
102297812919403362015-03-09MYSQL Functions1001Lulu.com34.99
102297803218338772015-03-09MySQL, Fifth Edition1029Addison-Wesley533.95
102297818907748202015-03-09Murach’s MySQL, 2nd Edition1032Murach, Mike & Associates, Inc248.95