Exercise 3 (ER Model) [25 points] The task consists in modeling a database structure that keeps information about properties managed by a hypothetical property management company named ABC. Suppose you are hired by ABC to design a database to manage the properties. Below we describe the entities and the relations that needed to be captured by your design * Each property has a name, street number, street name, zip code and one phone number. The property names are unique. Example: ('Tivoli', 2841. "SW 13th ST. 32608', 'FL', '3522265021') * Each property has a number of apartments, and each apartment is associated with ain apartment number. Each apartment has zero, one, or more residents. The information stored for a resident includes his/her name and sex. We assume that names are unique among the residents in an apartment * An employee of ABC is uniquely identified by his/her SSN. Moreover, we store his/her name. An employee may work at several properties of ABC. For instance, Smith is working at "Tivoli" on Tuesday and Friday and at Stoneridge" on Monday, Wednesday and Thursday. For every employee we record the percentage of time he or she works at each property. Thus, employee 'Smith, would be recorded as working at 40% at Tivoli and 60% at "Stoneridge". . . Each property has one property manager and one leasing manager. Each property/leasing manager may manage zero, one or multiple properties. For each leasing manager, we need to record his/her highest education degree, and for each property manager we need to record his/her number of years working in this area Design the E-R diagram for the small database described above. Make sure to indicate primary keys and cardinality constraints ( 1 : 1 , 1 :m, m: 1m:n)