Oracle Schema

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.