GIVEN:

CREATE TABLE customer_t( customerid NUMBER(11, 0) NOT NULL, customername VARCHAR2(25) NOT NULL, customeraddress VARCHAR2(30), customercity VARCHAR2(20), customerstate CHAR(2), customerpostalcode VARCHAR2(10), CONSTRAINT customer_pk PRIMARY KEY (customerid) );

CREATE TABLE employee_t( employeeid VARCHAR2(10) NOT NULL, employeename VARCHAR2(25), employeeaddress VARCHAR2(30), employeebirthdate DATE, employeecity VARCHAR2(20), employeestate CHAR(2), employeezipcode VARCHAR2(10), employeedatehired DATE, employeesupervisor VARCHAR2(10), CONSTRAINT employee_pk PRIMARY KEY (employeeid) );

CREATE TABLE order_t( orderid NUMBER(11, 0) NOT NULL, customerid NUMBER(11, 0), orderdate DATE DEFAULT SYSDATE, CONSTRAINT order_pk PRIMARY KEY (orderid), CONSTRAINT order_fk1 FOREIGN KEY (customerid) REFERENCES customer_t( customerid) );

CREATE TABLE product_t( productid NUMBER(11, 0) NOT NULL, productlineid NUMBER(11, 0), productdescription VARCHAR2(50), productfinish VARCHAR2(20), productstandardprice DECIMAL(6, 2), CONSTRAINT product_pk PRIMARY KEY (productid) );

CREATE TABLE orderline_t( orderid NUMBER(11, 0) NOT NULL, productid NUMBER(11, 0) NOT NULL, orderedquantity NUMBER(11, 0), CONSTRAINT orderline_pk PRIMARY KEY (orderid, productid), CONSTRAINT orderline_fk1 FOREIGN KEY (orderid) REFERENCES order_t(orderid), CONSTRAINT orderline_fk2 FOREIGN KEY (productid) REFERENCES product_t( productid) );

20. Create a view (named with OrderDetail) which includes the following items: order id, order date, customer id, customer name, product id. product description. product price, ordered quality and the project order price (product price ordered quantity). When you create the OrderDetail view, use the original column names from the tables except the last column named with OrderPrice". The figure below shows a part of data which we can see via the view. BORDERID BORDERDATE CUSTOMERID CUSTOMERNAME (PRODUCT, PR RDEREDQUANTITY iERPRICE! 1007 27-0cT-10 1001 21-0CT-10 11 Anerican Euro Lifcstylco 1 End Tablc 175 525 1 Contemporary Casuals 1 End Table 175 350