Implement the "Physical Database Design" constructs $($using "Logical Database Design" shown in Figure $17\mathrm{.}9,$ pg$.506)$ required to support the Data Queries" transactions $($d$),($f$)$ & $($g$)$ described in Section A$\mathrm{.}2\mathrm{.}2$ on page A$-5.$ This will require an SQL script that includes $.$

The creation of tables $($refer to section A$\mathrm{.}2\mathrm{.}1$ and Figure $17\mathrm{.}9$ to determine fields$).$ ONLY INCLUDE TABLES REQUIRED TO SUPPORT $($d$),($f$)$ & $($g$).$

The creation of DML statements to populate the tables $($minimum of $10$ records per table$)$

The creation of constraints $($excluding multiplicity$)$

The creation of appropriate indexes $($in a comment above the index creation, explain why index was used$)$

Notes

This is an extension of Project $4$ & Project $5,$ which created the Staff & Branch relations.

Refer to the "Data IntegrityLinks to an external site." chapter of the "Oracle Database Concepts" for description of the database integrity constraints supported by Oracle.

Refer to the "Data TypesLinks to an external site." section of the $"$SQL Language Reference" for descriptions of the Oracle data types, specifically for this activity focus on the "Oracle Built$-$In Data Types".

Refer to the SQL Reference manual for the proper syntax for the "CREATE TABLE", "DROP TABLE", "CREATE INDEX", and "DROP INDEX" statements.

CREATE TABLE, DROP TABLE, CREATE INDEX, DROP INDEX