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 and 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 to assess these data List all functional dependencies List any multivalued dependencies List all candidate keys List all primary keys List all foreign keys 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 itE Do these data have the inconsistent data problem? If so how will you deal with itF Do these data have a null missing value data problem? If so how will you deal with itG Do these data have the generalpurpose remarks problem? If so how will you deal with it
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
