Database Development and Management with SQL - Cloud Database Development and Management - page 120

Table 4.1 Column Descriptions for CUSTOMER Table

Column Name Data Type PK or FK Reference Table

CustomerID INT PK

FirstName VARCHAR(50)

LastName VARCHAR(50)

Phone CHAR(12)

Street VARCHAR(50)

City VARCHAR(50)

State VARCHAR(50)

Zip CHAR(5)

Table 4.2 Column Descriptions for EMPLOYEE Table

Column Name Data Type PK or FK Reference Table

EmployeeID INT PK

FirstName VARCHAR(50)

LastName VARCHAR(50)

Table 4.3 gives the deinition for the table PAYMENT.
he following is the SQL statement for creating the table PAYMENT:

CREATE TABLE PAYMENT
(

PaymentID INT PRIMARY KEY,

PaymentType VARCHAR(50) NOT NULL

)

For the table PRODUCT, you have the table deinition in Table 4.4.

Table 4.3 Column Descriptions for PAYMENT Table

Column Name Data Type PK or FK Reference Table

PaymentId INT PK

PaymentType VARCHAR(50)

Table 4.4 Column Descriptions for PRODUCT Table

Column Name Data Type PK or FK Reference Table

ProductID INT PK

ProductName VARCHAR(50)