Write a CREATE TABLE statement for the Customer table. Choose SQL standard

data types appropriate for the DBMS used in your course. Note that the CustBal

column contains numeric data. The currency symbols are not stored in the

database. The CustFirstName and CustLastName columns are required $($not null$).$

Write a CREATE TABLE statement for the Employee table. Choose SQL standard

data types appropriate for the DBMS used in your course. The EmpFirstName,

EmpLastName, and EmpEMail columns are required $($not null$).$

Write a CREATE TABLE statement for the OrderTbl table. Choose SQL standard

data types appropriate for the DBMS used in your course. The OrdDate column

is required $($not null$).$

Identify the foreign keys and draw an Oracle database diagram for the simplified

Order Entry database. The CustNo column references the Customer table and the

EmpNo column references the Employee table. For each relationship, identify the

parent table and the child table.