Re: separate table or no
Posted by: Peter Brawley
Date: January 23, 2021 01:15PM

Modelling a college might produce this parent-child table chain ...
state
  county
    college
      school
        department
          course
            class section
              class datetime
                instructor
In addition, various levels in this entity chain might rely on different computer services companies ...
  state <------------------+
     |                     |
    university <----- computerservices
        |                    |    |
      school <---------------+    |
          |                       |
        department <--------------+
           |
          etc
It's not incorrect to regard computerservices as a parent of the entities that reference it, ditto for, say, janitorservices, varies contracted services &c. All those relationships are potentially 1-many candidates for foreign key declarations.

For analysis of the requirement, though, it can be useful to differentiate kernel relationships in the chain from such lookup relationships. For example, all the entities in the state...instructor chain will be governed by civil service rules and conventions whereas some lookups likely will not.

Options: ReplyQuote


Subject
Written By
Posted
January 22, 2021 11:29AM
January 22, 2021 11:36AM
January 22, 2021 06:50PM
Re: separate table or no
January 23, 2021 01:15PM
January 25, 2021 10:50AM
January 26, 2021 11:39AM
January 28, 2021 11:59AM
January 29, 2021 11:13AM
February 02, 2021 12:33PM
February 03, 2021 11:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.