subject

A real estate firm lists properties for sale. The firm has a number of sales offices in several states. For each office, it is important to know the location and length of time the office has been open. Each sales office has several employees. The company wants to track employee names, addresses, and company ID numbers. An employee can only work for one sales office. For each sales office, there is always one employee assigned to manage the office. An employee can only manage the office to which he or she is assigned. Attributes of each property for sale include the property number, location (address, city, state, and zip code), and listing date. Each unit of property must be listed with one (and only one) of the sales offices and sales offices each generally have multiple listings. Each property has one or more owners. For each owner, we need to know the owner’s name, address, and email address. An owner can own multiple properties and some properties have join ownership (multiple owners).

Required:
a. Given this, it is important to know how much of each property is owned by each owner?
b. Draw an ERD that models these data requirements.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 10:00
Wich technology can a website use to allow you to listen to a concert live over the internet?
Answers: 3
question
Computers and Technology, 22.06.2019 19:30
When creating a presentation in libre office impress, where does the editing of slides take place?
Answers: 1
question
Computers and Technology, 23.06.2019 14:00
Need ! will choose brainliest! discuss the role of abstraction in the history of computer software.
Answers: 1
question
Computers and Technology, 24.06.2019 03:00
With editing, word automatically displays a paste options button near the pasted or moved text. a. cut-and-paste b. drag-and-drop c. inline d. copy-and-carry
Answers: 1
You know the right answer?
A real estate firm lists properties for sale. The firm has a number of sales offices in several stat...
Questions
question
Mathematics, 20.09.2020 17:01
question
Mathematics, 20.09.2020 17:01
question
Mathematics, 20.09.2020 17:01
Questions on the website: 13722363