Computers and Technology

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.

answer
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 21.06.2019 18:30, naomicervero
What type of weird relationship this is analogy show? dissolve: solidify: : noise: silence
Answers: 2
image
Computers and Technology, 22.06.2019 12:00, savjk74
Which of the following “invisible” marks represents an inserted tab?
Answers: 1
image
Computers and Technology, 22.06.2019 13:00, Cookie320
Write a program which asks you to enter a name in the form of first middle initial last. so you might enter for example samuel p. clemens. use getline to read in the string because it contains spaces. also, apparently the shift key on your keyboard doesn’t work, because you enter it all lower case. pass the string to a function which uses .find to locate the letters which need to be upper case and use toupper to convert those characters to uppercase. the revised string should then be returned to main in the form last, first mi where it will be displayed.
Answers: 1
image
Computers and Technology, 23.06.2019 05:00, bellad0124outlookcom
In cell b18, enter a formula to calculate the amount budgeted for meals. this amount is based on the daily meal allowance and the total travel days (# of nights+1).
Answers: 1
Do you know the correct answer?
A real estate firm lists properties for sale. The firm has a number of sales offices in several stat...

Questions in other subjects:

Konu
Health, 04.02.2021 03:50
Konu
Mathematics, 04.02.2021 03:50