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...") |
|||
| Line 11: | Line 11: | ||
* SALGRADE: is a reference table, used to look up the grades associated with the salary bands | * 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 | * BONUS: a subset of the EMP table, used to demonstrate the use of the CREATE TABLE AS ... command | ||
| + | |||
---- | ---- | ||
Return to the [[Oracle_Workbook|Workbook]]. | Return to the [[Oracle_Workbook|Workbook]]. | ||
Revision as of 15:09, 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.
