need help with MIS question! please, thank you. the above is only description for question 1.

Consider how you would you design each newly created table if you were to properly normalize the data. Consider what the primary keys would be for each table and what attributes would each table store? For the purposes of these questions, you should list each table and its attributes. Note which attributes are Primary or Foreign keys too with a PK or FK suffix. Example: Table XYZ - Attribute A(PK) - Attribute B - Attribute C - etc... TIP: You may start but splitting out one entity from the dataset like employee. Make sure the Employee table has a primary key and is linked back to other data with some form of a foreign key. Once you do this, try splitting out other data. Question 1 1 pts In the space below please explain your normalized design by listing the tables and their fields. Please notate if a field is a PK or FK