The goal is to practice database design using normalization. Work the Morgan Imp

Question

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.

Explanation / Answer

I . Yes these data makes the inconsistent data problem. for that we have to normalize the table structure like below.

J. To avoid Null value problem follow the below designs

K. If you want to go with remarks then we have to create separate column for that.

TABLE STRUCTURE:

SHIPMENT_DETAILS:

shipment_number UNIQUE KEY

shipper_name

phone

contact

SHIPMENT_CONTENT_DETAILS:

shipment_number FOREIGN KEY

from

departure

arrival

contents

insured_value

ITEM_DETAILS:

item_Number UNIQUE KEY

name

Date

city

STORE_ITEM_DETAILS:

store_number UNIQUE KEY

item_number FOREIGN KEY

name

salesperson_name

price

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.