Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Employee Database Table Relationship Diagram

The database that will be used in the book examples and exercises represents or models an employee. The entity relationship diagram in Figure 1.6 represents this database. The data schema diagram in Figure 1.8 also represents this database. Figure 1.11 is a table relationship diagram of this database, and it too represents this database. These diagrams give you three valuable tools to help you understand the database and write your SQL. The following is a description of the tables within the employee database:

Figure 1.11. Employee practice database table relationship diagram

Department

This table ...