Oracle Schema

From mi-linux
Revision as of 15:56, 24 February 2016 by Cm1958 (talk | contribs) (Protected "Oracle Schema" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)))
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 grade associated with a salary band
  • 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=8771"