Create a new database called CUSTOMER DATABASE.

1) You will create a table called CUSTOMERS with the following table layout:

(keep in mind that our version of SQL requires that we either use the number field type or the currency field type).

Customer

Column	Type	Length	Decimal Places	Nulls allowed?	Description
CUST_ID	Char	3		No	Customer Number (key)
CUST_NAME	Char	10			Customer Name
REGION	Char	2			Region
PHONE	Char	13			Phone number
BALANCE	Decimal	4	2		Balance

a) Create a brand new database called Customer Database.

b) Enter the SQL editor and write the SQL code that will create the table CUSTOMERS based on the above domain definition and designate CUST_ID as the primary key.

c) Save the command that you write to create your table as CREATE TABLE CUSTOMERS.

2) Insert the following data into the table CUSTOMERS using appropriate SQL commands. You should save one of the commands that you write as INSERT INTO CUSTOMERS.

CUST_ID CUST_NAME REGION PHONE BALANCE __________________________________________________________

DDD COLIN S 555-5555 $875.56

AAA GEORGE SW 345-6666 $0.00

BCD MARK NW 123-4567 $1255.63

XYZ MARY W 343-5677 $97.55

CCC PAUL E 993-5654 $39585.34

DEF WILLIAM N 234-5674 $0.00