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 heshe 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
