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)
1) What is the primary key of this relation?
2) Describe the insertion anomalies present in this relation.
3) Describe the deletion anomalies present in this relation.
4) Decompose this relation into a set of third normal form relations. Remember to underline primarykeys.
5) Create MySql diagram for the results tables
6) How would you store this data using cosmos db. What json models would look like?
