In this homework you will work with a Gym Management database for the Awesome

Gym franchise. The database contains information on gyms, members, instructors,

classes, types of classes, equipment and all their relationships. The database represents

data for the gym$$s operations in January $2023.$ The data is artificially and randomly

generated and may, or may not, reflect reality.

The following is the database schema and ER$-$diagram of the database:

Instructor $($ID$,$ name, phone$)$

Member $($ID$,$ name, phone, start$\_$date, quit$\_$date, IID$)$

Gym $($ID$,$ address, email$)$

Type $($ID$,$ name, capacity$)$

Equipment $($ID$,$ name, price$)$

Class $($ID$,$ IID, TID, GID, date, minutes$)$

Attends $($MID$,$ CID, rating$)$

Needs $($TID$,$ EID, quantity$)$

Figure $1$: ER Diagram for the Gym Management database.