Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started