Oracle Schema

From mi-linux
Revision as of 14:08, 19 February 2016 by Cm1958 (talk | contribs) (Created page with "Main Page >> Oracle and SQL >> Workbook >> Oracle Schema == ER Diagram == Below is an ER diagram that represents how the final set of tab...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Main Page >> Oracle and SQL >> Workbook >> Oracle Schema

ER Diagram

Below is an ER diagram that represents how the final set of tables fit together:

http://mi-linux.wlv.ac.uk/~oracle/wiki/OracleSchema.png

Note the following are missing:

  • CUSTOMER: this is not part of the DEPT/EMP schema and is included in the booklet to show the problems of using a poorly designed table
  • SALGRADE: is a reference table, used to look up the grades associated with the salary bands
  • BONUS: a subset of the EMP table, used to demonstrate the use of the CREATE TABLE AS ... command

Return to the Workbook.

Retrieved from "https://mi-linux.wlv.ac.uk/wiki/index.php?title=Oracle_Schema&oldid=8671"