Description:

The goal is to practice database design using normalization.

Work the Morgan Importing Problem described as described below. No database development is required for this

assignment, just the table design. The assignment involves concepts covered in chapter $4$ and its slides. Pay

attention to the following guidelines for Assessing Table Structure from Figure $4-1$ of Chapter $4.$

Count rows and examine columns

Examine data values and interview users to determine:

Multivalued dependencies

Functional dependencies

Candidate keys

Primary keys

Foreign keys

Assess validity of assumed referential integrity constraints

Assessing Table Structure

Morgan Importing Problem:

Phillip Morgan, the owner of Morgan Importing, makes periodic buying trips to various countries. During

the trips, he keeps notes about the items he purchases and basic data about their shipments. He hired a

college student as an intern, and she transformed his notes into the spreadsheets in Figure $4-9.$ This is

just sample data. Phillip has purchased hundreds of items over the years, and they have been shipped in

dozens of different shipments.

Phillip wants to enter the information age, thus he has decided to develop a database of his inventory.

He wants to keep track of the items he has purchased, their shipments, and eventually customers and

sales. To get started, he has asked you to create a database for the data in Figure $4-9.$

Figure $4-9-$ Spreadsheets from Morgan Importing