This assignment is a practice of a physical database design. Perform the following tasks using the attached database schema.

1) Write a create table statement for each relation. In your create table statements, include at least two constraints for each table. For each foreign key, specify appropriate referential triggered action clause (e.g., on delete ..., on update ... ). Note that not all actions are implemented on Oracle.

2) Write insert statements to insert about 10 tuples into each table.

3) Write following queries in SQL and issue them to your database. Then capture the screen of the query results and include them in your report. Make sure that each of your queries returns at least one tuple (If necessary, you have to insert some additional tuples).

(a). Show the OrderNo, Date, and Amount of all orders issued by .

(b). Show the EmpNos and names of all employees who handle at least two orders.

(c). Show all suborder details (OrderNo, SuborderNo, required shipping date, actual shipping date, customer name, and BrNo) which were shipped later than required shipping date.

(d). Show the details of all branches of .

(e). Show the OrderNo, date, amount, and customer name of all orders that are handled by .

Boston Papers Database Schema Diagram (Class Project Part 2, suggested) CUSTOMER Note: BranchName is added as a key of BRANCH, which is assumed to be unique across all branches. NameAddress Phone ORDER OrderNo Date AnCustomerName BRANCH BranchName BrNo Address Phone CustomerName SUBORDER OrderNo SuborderNo ReqShipDate ActualShipDate BranchName EMPLOYEE EmpNo Name Address DOB Class Salary HANDLES EmpNoOrderNo PAPER TypeNo Size Weight UnitPrice ORDER ITEM OrderNo SuborderNo TypeNoQuantity Boston Papers Database Schema Diagram (Class Project Part 2, suggested) CUSTOMER Note: BranchName is added as a key of BRANCH, which is assumed to be unique across all branches. NameAddress Phone ORDER OrderNo Date AnCustomerName BRANCH BranchName BrNo Address Phone CustomerName SUBORDER OrderNo SuborderNo ReqShipDate ActualShipDate BranchName EMPLOYEE EmpNo Name Address DOB Class Salary HANDLES EmpNoOrderNo PAPER TypeNo Size Weight UnitPrice ORDER ITEM OrderNo SuborderNo TypeNoQuantity