If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Conceptual...

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-31-05, 05:19
roustabout roustabout is offline
Registered User
 
Join Date: Jan 2005
Posts: 14
Question Conceptual...

Business Rules:
A company brokers both units for rent and units for sale. It brokers both apartments and houses. Apartments have exactly one management company associated with them that collects maintenance fees and then looks after
the upkeep of the apartment
. You should also keep track of what the maintenance fee is. The same management company might charge a different maintenance fee for a different apartment. Houses don’t have such a relationship because the house owners are supposed to look after them
on their own. There is a three-way relationship between agents, customers, and properties – a customer considers a property using an agent. A customer may be considering several different properties, and the same property might have several customers (and their agents) considering it, and the same agent can be handling several customers and houses at the same time. A customer could also be dealing with several agents during the course of their house choosing. A property has an asking price and a minimum price. A customer considering it may offer a price. Of course, your database will also need to keep track of the addresses and owners of the properties.
Owners, customers, and agents are all people. Of course, some people may be in more than one of those categories.

My question:

I already drew the conceptual diagram. Am i Correct?
Attached Images
File Type: jpg conceptual.jpg (25.1 KB, 78 views)

Last edited by roustabout; 01-31-05 at 19:33.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On