Consider the following set of database tables. The diagram shows a database made up of 6 tables with all primary keys underlined. Please take note of foreign keys (most of them carry the same names as the corresponding primary keys they reference): CUS_CODE in INVOICE, INV_NUMBER & P_CODE in LINE, and V_CODE in PRODUCT. The only exception to the naming convention is the EMP_MGR foreign key in EMPLOYEE which references the EMPLOYEE table in a recursive relationship.
Please refer to the PDF document attached for the whole question.
The question belongs to Oracle and it is about creating relational databases. Database tables with various employee and customer details have to be created with SQL query and stored procedures. The solution has the SQL files with tables created from queries, subqueries and stored procedures.
Total Word Count 330
Download Full Solution