Database Reference
In-Depth Information
8. Let us enter the following SQL statements to create tables. After the SQL statements
are entered, click
Run
.
— -Create tables
CREATE TABLE CUSTOMER
(
CustomerID INT PRIMARY KEY,
FirstName VARCHAR(30),
LastName VARCHAR(30) NOT NULL,
Phone CHAR(12),
Street VARCHAR(30),
City VARCHAR(30),
State VARCHAR(30),
Zip CHAR(5)
)
GO
CREATE TABLE EMPLOYEE
(
EmployeeID INT PRIMARY KEY,
FirstName VARCHAR(30),
LastName VARCHAR(30) NOT NULL
)
GO
CREATE TABLE PAYMENT
(
PaymentID INT PRIMARY KEY,
PaymentType VARCHAR(30) NOT NULL
)
GO
CREATE TABLE PRODUCT
(
ProductID INT PRIMARY KEY,
ProductName VARCHAR(30),
)
GO
CREATE TABLE ITEM
(
ItemID INT PRIMARY KEY,
ProductID INT,
CPU VARCHAR(30),
RAM VARCHAR(30),
HardDrive VARCHAR(30),
OpticalDrive VARCHAR(30),
Monitor VARCHAR(30),
CONSTRAINT Item_ProductId_fk
FOREIGN KEY (ProductID)
REFERENCES PRODUCT (ProductID)
