Database Answers Pebble Beach

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Hierarchy of Parties and Phones

The Draft Business Rules have been defined and are listed below.
The Area being Modelled is :-
Buyers and Bidders for Products across four different Categories.

This is a Statement of the User Requirements.

A database to record many to many relationships and simple forms

Question: I want to create a recursive database for Organizations and Persons (in the same table) and link them to a Phone Number table. 

Each record in the Org/Person table may be linked to one or more other records in the Org/Person table by a role/relationship. 

Each record in the Org/Person table may have one or more phone numbers listed for them. 

Depending on the organization (for example "office") -- the person "tied to" the office would also have those phone/fax numbers listed with them in the reporting "phone book"... 

BUT all of this has to be done in as simple of a user interface as possible. -- 

I am looking for a book/online tutorial/mentor to assist me in this "first leg of my DB journey..." 




 
Barry Williams
28th. October 2006
Principal Consultant
Database Answers
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map