$1.$ Based on the narratives below, draw a single conceptual ERD in Standard Crow$$s Foot form for a real estate firm that lists vacation property for rent.

Carefully label your diagrams with simple identifiers, if available $($do not add surrogate identifiers$),$ minimum and maximum cardinality, and appropriate entity, attribute, and relationship names.

The firm has a number of offices in several provinces. Attributes of office include Office$\_$Number $($identifier$)$ and LocationCity. Each office is home to one or more employees. Attributes of employees include Employee$\_$ID $($identifier$),$ EmployeeLastName and EmployeeFirstName. An employee must be assigned to only one office. For each office, there is always one employee assigned to manage that office. An employee may manage, at most, only one office. $($Hint: This is a $2$nd relationship$)$

Each office lists a set of rental properties. Rental properties are described by Property$\_$ID $($identifier$),$ Address, City, Province, Postal$\_$Code, Bed$\_$No$,$ Rent, and Rate. Each property is either a beach property or a mountain property. Attributes of beach property include the distance $($number of blocks from the beach$).$ For each mountain property, you should record activities $($e$.$g$.,$ hiking, skiing, walking..$)($Hint: activities is an multi$-$valued attribute$)$

Each property has one or more owners. Attributes of owners are Owner$\_$ID $($identifier$),$ OwnerLastName and OwnerFirstName. An owner may own all or part of one or more properties. For each property and owner, you should record Percent$\_$Owned to represent the percentage owned of the property $($i$.$e$.,50\%,100\%,$ etc.$).($Hint: You need an associative entity$)$