[Solved] Database Model-Final Preparation Group Assignment

Below you will find a first normal form relation for the Callaghan Brothers Circus:

Circus Case Study

Circus (show_date, show_time, attraction_name, show_numb, collection_date, amount_collected, attraction_description)

• What is the primary key of this relation?
• Describe the insertion anomalies present in this relation.
• Describe the deletion anomalies present in this relation.
• Decompose this relation into a set of third normal form relations. Remember to underline primarykeys.
• Create MySql diagram for the results tables
• How would you store this data using cosmos db. What json models would look like?