Reference no: EM132867826

Part A: Please draw an entity relationship diagram for the following narrative - Please note that there are only the 3 entities (tenants, consultation and landlord) in this initial Entity Relationship Diagram (ERD). Please state any assumptions you need to make for this model.

Ms. Green in an attorney who runs a legal clinic for rental tenants. In Ms. Greens' legal clinic, tenants arrive for consultations. Every tenant has a unique ID, name and address. Every tenant has one landlord, though sometimes Ms. Green will do consultations with renters who are afraid to say who their landlord is. Every landlord has a first and last name (as well as an address) and could have one or several tenants. Ms. Green is generally very careful to see only one tenant per consultation (scheduled for a specific time and date), though over time she may perform a few consultations for a given tenant.

Part B: Please modify your Entity Relationship Diagram (ERD) based on the following additions to the case narrative above :

Sometimes a serious issue with a particular landlord necessitates that several tenants are invited to participate in one consultation. Moreover, as a result of a recent increase in the number of tenants coming into her clinic Ms. Green has (a) extended the hours her clinic is open into the evenings and weekends & (b) has recently hired several part-time attorneys who also carry out consultations with tenants during these extended evening and weekend clinic hours.