Using the Erwin Software construct a logical data model using the IE notation to fit the following circumstances. Place all $4$ solutions in a single Erwin file for convenience

Draw data models for the following situations. In each case show also all cardinalities and verbs. Make reasonable assumptions about prime keys where necessary

a$)$ The Metro library has many books. A library member can reserve many books and each book can have many reservations. Some books are not vey popular and so have no reservations while some members don't join reserve any books. For each book retain the unique ISBN, the title and authors name. For each member retain their unique card no$,$ email and their name and card expiry date. When a member reserves a book the date of the reservation is retained.

b$)$ The Ryerson medical clinic has many doctors and many registered patients. Each patient may have many appointments with different or the same doctor over time. For each patient retain the unique patient id$,$ their name, gender and date of birth. For each doctor retain their unique staff id$,$ name, their specialty description and base consultation fee. For each appointment a patient has had or scheduled retain the appointment date. Past as well as future appointments are kept.

c$)$ The TSO orchestra employs many musicians. Each musician can play many different types of instruments in the orchestra. Retain the unique id$,$ email $,$the name and salary for each musician and the level of their expertise in each type of instrument they can play. For each instrument type used in the orchestra retain the name of the type $($e$.$g$.$ Violin$)$ and its category $($e$.$g$.$ Strings$).$ Not all instrument types have an assigned musician at all times.

d$)$ The Cineplex entertainment chain has many movie complexes. Each complex operates many theatres. Each theater within a complex has a unique theatre number for that complex. Also retained for each theatre is its style of presentation and seating capacity. For each complex retain the unique complex id$,$ the complex name, and a contact name and phone number. Movies are screened in theatres. Each movie has a unique id$,$ title, release date and genre. A movie may be screened many times in the same theatre on different dates and times and in many different theatres on the same $($or different$)$ dates and times. For each screening retain the date and time screened.