Question: Create a single logical model ( including attributes ) for the following real estate company. a . The company has a number of sales offices.

Create a single logical model (including attributes) for the following real estate company. a. The company has a number of sales offices. Each office has an office number and location. b. Each sales office is assigned one or more employees. An employee must be assigned to only one sales office. Each employee has an employee ID and name. c. For each sales office, there is always one employee assigned to manage that office. An employee may manage only the office to which he/she is assigned. d. The company lists the property for sale. Each property has a property ID and location. The property location includes street, city, state, and zip. e. Each unit of property must be listed with only one sales office. A sales office may have any number of properties listed (or no properties). f. Each unit of property has one or more owners. Each owner owns some percentage of the property. Each owner has a name and an ID. An owner can own more than one property

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 Programming Questions!