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)?
You do not need to get too technical. Demonstrate that you are familiar with the basic structure and rules of database design.
In short, this activity should include an overview of the data tables and fields, a description of how your tables relate to one another, and an indication that there is an understanding of the normal forms 1-3.
