Prepare E R Diagram Real Estate Firm Lists Property Sale Following Describes Organization Q43853887
Prepare an E-R diagram for a real estate firm that lists property for sale. The following describes this organization: . The firm has a number of sales offices in several states. Attributes of sales office include Office Number (identifier) and Location. Each sales office is assigned one or more employees. Attributes of employee include Employee_ID (identifier) and Employee Name, An employee must be assigned to only one sales office. For each sales office, there is always one employee assigned to manage that office. An employee may manage only the sales office to which he or she is assigned The firm lists property for sale. Attributes of property include Proper _ ID (identifier). Location, and total number of rooms (Room.Total). Components of Location include Address, City, State and Zip Code. • Each unit of property must be listed with one and only one of the sales office. A sales office may have any number of properties listed, or may have no property listed Each unit of property has one or more owners. Attributes of owners are Owner_ID (identifier). Owner Name, Owner Address. An owner may own one or more units of property. An attribute of the relationship between property and owner is Percent_ Owned ERD diagram must have entities, attributes, primary keys, foreign keys and relationships Cardinalities, notations and symbols must be clearly identified. Show transcribed image text Prepare an E-R diagram for a real estate firm that lists property for sale. The following describes this organization: . The firm has a number of sales offices in several states. Attributes of sales office include Office Number (identifier) and Location. Each sales office is assigned one or more employees. Attributes of employee include Employee_ID (identifier) and Employee Name, An employee must be assigned to only one sales office. For each sales office, there is always one employee assigned to manage that office. An employee may manage only the sales office to which he or she is assigned The firm lists property for sale. Attributes of property include Proper _ ID (identifier). Location, and total number of rooms (Room.Total). Components of Location include Address, City, State and Zip Code. • Each unit of property must be listed with one and only one of the sales office. A sales office may have any number of properties listed, or may have no property listed Each unit of property has one or more owners. Attributes of owners are Owner_ID (identifier). Owner Name, Owner Address. An owner may own one or more units of property. An attribute of the relationship between property and owner is Percent_ Owned ERD diagram must have entities, attributes, primary keys, foreign keys and relationships Cardinalities, notations and symbols must be clearly identified.
Expert Answer
Answer to Prepare an E-R diagram for a real estate firm that lists property for sale. The following describes this organization: ….
OR