Question: 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

Based on the narratives below, draw a single conceptual ERD in Standard Crows Foot form for a real estate firm that lists vacation property for rent. 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 2nd 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 Recall how to resolve multivalued attributes) 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!