The problems use the Customer, Order Tbi, and Employee tables of the simplified Order Entry database. Chapters 4 and 10 extend the database to increase its usefulness. The Customer table contains clients who have placed orders. The OrderTbl contains basic facts about customer orders. The Employee table contains facts about employees who take orders. The primary keys of the tables are CustNo for Customer, EmpNo for Employee, and OrdNo for Order Tbl. CustNo C0954327 C1010398 C2388597 C3340959 C3499503 C8543321 EmpNo E1329594 E8544399 EB843211 E9345771 E9884325 E9954302 CustFirstName Sheri Jim Beth Betty Bob Ron Landi Joe Amy Colin CustLastName Thomas Mary Gordon Glussman Taylor Wise Mann EmpFirstName Thompson Customer CustCity Littleton Denver Seattle Seattle Monroe Renton Employee EmpLastName Santos Jenkins Tang White Johnson Hill CustState Custzip 80129-5543 80111-0033 98103-1121 98178-3311 98013-1095 98666-1289 CO co WA WA WA WA EmpPhone (303) 789-1234 (303) 221-9875 (303) 556-4321 (303) 221-4453 (303) 555-9987 (303) 556-9871 CustBal $230.00 $200.00 $500.00 $20000 $0.00 $85.00 EmpEmail LSantos@bigco.com JJenkins@bigco.com ATang@bigco.com CWhite@bigco.com TJohnson@bigco.com MHillabigco.com OrdNo 01116324 02334661 03331222 02233457 04714645 C5511365 07989497 01656777 07959898 OrdDate 01/23/2017 01/14/2017 01/13/2017 01/12/2017 01/11/2017 01/22/2017 01/16/2017 02/11/2017 02/19/2017 CustNo C0954327 00954327 C1010398 C2388597 C2388597 C3340959 C3499503 C8543321 C8543321 EmpNo E8544399 E1329594 E9884325 E1329594 E9884325 E9345771 E8544399 1. Write a CREATE TABLE statement for the Customer table. Choose data types appropriate for the DBMS used in your course. Note that the Cust Bal column contains numeric data. The currency symbols are not stored in the database. The CustFirstName and CustLastName columns are required (not null). 2. Write a CREATE TABLE statement for the Employee table. Choose data types appropriate for the DBMS used in your course. The EmpFirst Name, EmpLast Name, and EmpEMail columns are required (not null). 3. Write a CREATE TABLE statement for the Order Tbl table. Choose data types appropriate for the DBMS used in your course. The OrdDate column is required (not null). 4. Identify the foreign keys and draw a relationship diagram for the simplified Order Entry database. The CustNo column references the Customer table and the Emp No column references the Employee table. For each relationship, identify the parent table and the child table.