Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me form tables from this data Create a relation structure to support this data in a normalized format. 1) You can draw it
please help me form tables from this data
Create a relation structure to support this data in a normalized format. 1) You can draw it out in this document or in your database (if you do that, provide screenshots of your tables) Identify your primary keys. Do not use a surrogate key unless you have to. Draw out your foreign key relationships. 2) 3) Answer the following questions. 1) Is the original dataset normalized? What are the different themes/relations in this dataset? Show the determinants in this dataset. a. b. 2) 3) 4) 5) What did you do to normalize the data? Identify all possible candidate keys. Should you use a surrogate key? Why or why not? What are the primary keys for each of your tables? a. What fields absolutely cannot be null? 6) What are the foreign keys for each of your tables? a. Do you need referential integrity? b. Are there dependencies-if so what are theyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started