Difference between revisions of "Oracle Schema"
From mi-linux
Jump to navigationJump to search (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...") |
(No difference)
|
Revision as of 15:08, 19 February 2016
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.
