1. Prepare an E-R diagram for a real estate firm that lists property for sale. The following describes the organization:
• The firm has a number of sales offices in several states.
• Each sales office is assigned one or more employees. 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 one sales office to which he/she is assigned.
• The firm (sales office) lists property for sale.
• Each unit of property must be listed with one (and only one) of the sales offices. A sales office may have any number of properties listed, or may have no properties listed.
• Each unit of property has one or more owners. An owner may have one or more units of property.
Comments