Write a CREATE TABLE statement for the Customer table. Choose 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).
a. CREATE TABLE Customer
b. ( CustNo CHAR(11),
c. CustFirstName VARCHAR(50),
d. CustCity VARCHAR(50),
e. CustState CHAR(2),
f. CustZip CHAR(10),
g. CustBal DECIMAL(3,2))
