LISTING 1: Statement That Creates the Customers Table

CREATE TABLE customers (customerid int not NULL,
                       companyName varchar(40) not NULL,
                       contactName char(30) NULL,
                       address varchar (60) NULL,
                       income money NULL,
                       city char(15) NULL,
                       country char(30) NULL,
                       gender char(1) NULL,
                       phone char(24) NULL,
                       fax char(24) NULL)