Design a set of 3NF tables (each is a separate problem) that capture all key data (PK and FK) necessary to track this data. Along the way, you may have to make assumptions due to the lack of familiarity with the domain - you would normally ASK the subject matter experts for clarification. List ALL assumptions you had to make to complete this.
In all situations, identify the tables needed clearly, all primary keys and a few non-key attributes to show the relationships as shown here:
TABLE1 (table1_PK, fields1, field 2â¦)
TABLE2 (table2_PK, field1, field2⦠table1_FK)
For bridge tables, be sure to identify the FKs properly