Question: Use these relations and the data in Figures 3 - 3 3 and 3 - 3 4 ( which do not contain all the data

Use these relations and the data in Figures 3-33 and 3-34(which do not contain all the data for all the columns shown in this schema) to answer the following questions. A. Follow the procedure shown in Figure 4-1to 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 the owners of the Queen Anne Curiosity Shop to verify your assumptions.C. If there are any multivalued dependencies, create the tables needed to eliminate these dependencies.D. Do these data have the multivalue, multicolumn problem? If so, how will you deal with it?E. Do these data have the inconsistent data problem? If so, how will you deal with it?F. Do these data have a null (missing) value data problem? If so, how will you deal with it?G. Do these data have the general-purpose remarks problem? If so, how will you deal with it?
 Use these relations and the data in Figures 3-33 and 3-34(which

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!