phillip morgan, the owner of morgan importing, makes periodic bu

Project Description:

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.a. follow the procedure shown in figure 4-1 to assess these data.1. list all functional dependencies.2. list any multivalued dependencies.3. list all candidate keys.4. list all primary keys5. list all foreign keys.6. state any assumptions you make as you list these components.b. list questions you would ask phillip to verify your assumptions.c. if there are any multivalued dependencies, create the tables needed to eliminate these dependencies.d. the relationship between shipment and item data could possibly be inferred by matching values in the from cells to values in the city cells. describe two problems with that strategy.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 tables you think are appropriate. state all referential integrity constraints.g. assume that phillip wishes to create a read-only database from these data. design tables you think are appropriate. state all referential integrity constraints.h. do these data have the multivalue, multicolumn problem? if so, how will you deal with it?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?
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 12
1 Current viewersl
48 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.7
    93 Jobs 44 Reviews
    $25 in 24 Hours
  • 4.3
    12 Jobs 6 Reviews
    $20 in 1 Day
  • 4.9
    25 Jobs 10 Reviews
    $40 in 1 Day
  • 4.8
    290 Jobs 208 Reviews
    $50 in 3 Days
  • 4.6
    103 Jobs 52 Reviews
    $45 in 2 Days
  • 4.6
    647 Jobs 468 Reviews
    $25 in 2 Days
  • 4.5
    74 Jobs 34 Reviews
    $20 in 1 Day
  • 4.2
    68 Jobs 35 Reviews
    $20 in 1 Day
  • 4.8
    175 Jobs 91 Reviews
    $40 in 12 Hours
  • 4.9
    63 Jobs 31 Reviews
    $15 in 1 Day