Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedPhillip 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.

I. Do these data have the inconsistent data problem? If so, how will you deal with it?

J. Do these data have a null value data problem? If so, how will you deal with it?

K. Do these data have the general-purpose remarks problem? If so, how will you deal with it?

E. Describe a change to this spreadsheet that does express the shipment-item relationship F Assume that Phillip wishes to create an updatable database from these data. Design igure: 4-9: tables you think are appropriate. State all referential integrity constraints preadsheets from Morgan mporting 1 ShipmentNumbe Shippe Contact Fio DepartureAiva Contents InsuredValue Pliont QE dining set, large bureau, 49100300 Wordwide 800-123-4567 Jose Philippines 5/5/2011 6/17/1999 porcelain lamps $27.500 Miscellaneous linen, large masks 14 setting Woven goods, antique leather 488955 Intenational 800-123-8898 Mrilyn Singapore 6/2/2011 Willow design china $7,500 84899440 Wordwide 800-123-4567 lose 73/2011 7128/2011 chairs Large burcau, brass lamps, willow 399400 Inlenaliurial 800-123-8898 Marily Singapureee 52011 9/11/2011 design servinng disthes $18,000 City Salesperson Price Willow Serving Dishes /15/2009 Singapore Jade Antiques Swee Lai Large bureau Brass lamps QE Dining Set 54,500 $9,500 $1,200 14,300 10 7/17/2009 Singapore Eastern Sales Jeremey 7/20/2009 Singapore Jade Antiques Mr. James 4/7/2009 ManilaE. Treasures Cracielle 12 13 14 15 E. Describe a change to this spreadsheet that does express the shipment-item relationship F Assume that Phillip wishes to create an updatable database from these data. Design igure: 4-9: tables you think are appropriate. State all referential integrity constraints preadsheets from Morgan mporting 1 ShipmentNumbe Shippe Contact Fio DepartureAiva Contents InsuredValue Pliont QE dining set, large bureau, 49100300 Wordwide 800-123-4567 Jose Philippines 5/5/2011 6/17/1999 porcelain lamps $27.500 Miscellaneous linen, large masks 14 setting Woven goods, antique leather 488955 Intenational 800-123-8898 Mrilyn Singapore 6/2/2011 Willow design china $7,500 84899440 Wordwide 800-123-4567 lose 73/2011 7128/2011 chairs Large burcau, brass lamps, willow 399400 Inlenaliurial 800-123-8898 Marily Singapureee 52011 9/11/2011 design servinng disthes $18,000 City Salesperson Price Willow Serving Dishes /15/2009 Singapore Jade Antiques Swee Lai Large bureau Brass lamps QE Dining Set 54,500 $9,500 $1,200 14,300 10 7/17/2009 Singapore Eastern Sales Jeremey 7/20/2009 Singapore Jade Antiques Mr. James 4/7/2009 ManilaE. Treasures Cracielle 12 13 14 15

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

AWS Certified Database Study Guide Specialty DBS-C01 Exam

Authors: Matheus Arrais, Rene Martinez Bravet, Leonardo Ciccone, Angie Nobre Cocharero, Erika Kurauchi, Hugo Rozestraten

1st Edition

1119778956, 978-1119778950

More Books

Students also viewed these Databases questions

Question

9. Explain the relationship between identity and communication.

Answered: 1 week ago