How will the tables be related to one another? What primary keys, foreign keys, or ID fields will you use?

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)?