The goal is to practice database design using normalization Work theMorgan Importing Problem described as described below. No database development is required for this assignment, just the tabledesign. The assignment involves concepts cov ered in chapter 4 and its slides. Pay attention to the following guidelines for Assessing Table Structure from Figure4-1 of Chapter4 . Count rows and examine columns Examine data values and interview users to determine Multivalued dependencies Functional dependencies Candidate keys Primary keys Foroign koys 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 Philip wants to enter the information age, thus he has decided fo devebp a dafabase of his inventory He wants to keep track of the items he has purchased, their shipments, and eventually cusfomers and sales. To gef started, he has asked you to create a database for the data in Figure 4-9 Phone Contact From Arrival Contents InsuredValue CE dining set, large bureau, 49100300 Wordwide 800-123-4567 Jose Philippines 5/5/2009 6/17/1999 porcelain lamps S27,500 Miscellaneous linen, large masks, 14 setting Willow dasign china Woven goods, antique leather 800-123-8898 Marilyn Singapore 800-123-4567 Jose 800-123-8898 Manilyn Singaporeee 62/2009 73/2009 7/28/2009 chairs 8/5/2009 /11/2009 design serving dishes 488955 Intenational $7,500 4899440 Wordwide Peru Large bureau, brass lamps, willow 99400 Intenational $18,000 City Store Salesperson Price Willow Serving Dishes 7/15/2009 Singapore Jade Antiques Swee Lai Larpe bureau Brass lamps QE Dining Set $4,500 9.500 1,200 14,300 10 /17/2009 Singapore Eastem Sales Jeremey 7/20/2009 SingaporeJade Antiques Mr. James 4/7/2009 Manila Treasures Graciele 12 13 14 1s The goal is to practice database design using normalization Work theMorgan Importing Problem described as described below. No database development is required for this assignment, just the tabledesign. The assignment involves concepts cov ered in chapter 4 and its slides. Pay attention to the following guidelines for Assessing Table Structure from Figure4-1 of Chapter4 . Count rows and examine columns Examine data values and interview users to determine Multivalued dependencies Functional dependencies Candidate keys Primary keys Foroign koys 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 Philip wants to enter the information age, thus he has decided fo devebp a dafabase of his inventory He wants to keep track of the items he has purchased, their shipments, and eventually cusfomers and sales. To gef started, he has asked you to create a database for the data in Figure 4-9 Phone Contact From Arrival Contents InsuredValue CE dining set, large bureau, 49100300 Wordwide 800-123-4567 Jose Philippines 5/5/2009 6/17/1999 porcelain lamps S27,500 Miscellaneous linen, large masks, 14 setting Willow dasign china Woven goods, antique leather 800-123-8898 Marilyn Singapore 800-123-4567 Jose 800-123-8898 Manilyn Singaporeee 62/2009 73/2009 7/28/2009 chairs 8/5/2009 /11/2009 design serving dishes 488955 Intenational $7,500 4899440 Wordwide Peru Large bureau, brass lamps, willow 99400 Intenational $18,000 City Store Salesperson Price Willow Serving Dishes 7/15/2009 Singapore Jade Antiques Swee Lai Larpe bureau Brass lamps QE Dining Set $4,500 9.500 1,200 14,300 10 /17/2009 Singapore Eastem Sales Jeremey 7/20/2009 SingaporeJade Antiques Mr. James 4/7/2009 Manila Treasures Graciele 12 13 14 1s
