Database diagram
Design a sample relational database diagram utilizing the survey and information provided. The relational database diagram should include all 7 elements.
• Find and organize the information required. (Survey Provided)
• Divide the information into tables. …
• Turn information items into columns. …
• Specify primary keys. …
• Set up the table relationships. …
• Refine your design. …
• Apply the normalization rules.
The database diagram should include the following:
• At least four record tables
• At least two columns in each record table
• At least three relationships between tables
Briefly describe the structure of the relational database. In a few sentences for each, explain:
• What kinds of data will be in each table? What fields will contain these data?
• How will the tables be related to one another? What primary keys, foreign keys, or ID fields will you use?
• How will you normalize your data (1NF, 2NF, 3NF)?