Re: why hierarchy?

Basic Requirements: A business has many staff members (with full names and a start date), some of whom are direct supervisors over other staff members. The business has many clients (with full names), and each client is registered on a specific date by a specific staff member.

Ok, please specify specific data for the above.

The data values are not part of the initial specifications.

With dbd, user doesn't design a schema. When you have finished
designing the schema, please post it. We can then start adding some
initial data that might look like the below or not. Write a few
queries. Then someone can suggest unanticipated data, ie store the
asset(s) that each person/company owns some possibly shared. Adapting
each solution to the new data will allow us to evaluate or extrapolate
each data representation methodology's resiliency/generality.

Company IBM has 6 employees. There boss/employee hierarchy as follows:
John Smith (hired 7/4/45)
Mary Lee (hired 5/3/65)
Suzie Merk (hired 8/8/88)
Bob Lewis (hired 3/8/08)
Rick Branson (hired 8/9/48, 1/3/67 and 5/13/88)

Jack (hired 3/5/89) has two bosses: John and Suzie.

IBM has 5 clients (2 companies, 3 individuals) registered on date(s)
indicated by employee(s)
Dell reg by Mary on 1/1/01
Microsoft Inc reg by Suzie and Rick on 3/5/02 and 5/8/54
Warren Buffet reg by Bob on 5/8/02
George W. Bush III reg by Mary, Suze, Bob, Rick on 5/8/06
J Carter ref by John on 3/4/92

.

Relevant Pages

  • Re: multiple cascade paths
    ... You should not have them if your schema is designed properly. ... make you understand that I tried to show that a proper design can have ... am a SQL Server MVP, for crying out loud - you can safely assume that I ...
    (comp.databases.ms-sqlserver)
  • Re: OT - Defensive Driving
    ... A 26.79 mm seatpost will work as well as a 26.80 mm ... safety factors used in design completely protect against ... specify items for manufacture you use finite numbers, ... materials manufacturers to determine whether off the shelf material ...
    (rec.bicycles.tech)
  • Re: Auto resizing web page according to screen resolution
    ... You are getting the right answers here ('fluid design' or 'liquid design'), but I think some responders misinterpreted what you were requesting. ... I believe you did not intend to alter the dimensions of the user's window, but rather were asking how to automatically have the page adjust to the dimensions of the window the user has provided. ... Instead of specifying a px or pt size for a font, specify a fraction of ems. ... If you specify the margin in ems, say 2 ems, then when the text is increased in size by 50%, the margin space will also be increased by 50%. ...
    (comp.infosystems.www.authoring.html)
  • Re: Applications "buying" resources
    ... It all boils down to how you specify a correctly working system. ... want to design a system that will do a particular job most of the time, ... But they are not real time, ... I just find my reasoning for using an operating system in my ...
    (comp.arch.embedded)
  • Re: WinQCad vs. EagleCAD
    ... just because I once copied a voltage regulator out of a design which aparently was made by some third party with a cracked version." ... quote "This evil schema part creaped into quite some of my designs with which the only option I have now is to recapture their schemas from scratch!" ... rightful owner UNLESS you could have suspected you bought stolen goods ... AFAIK in pretty much any other Western country you'd be required to hand over the stolen goods. ...
    (sci.electronics.design)