1. Completing the CREATE TABLE statements

Address
Column	Data Type	Rules
addressID	INT	IDENTITY
addressLine	VARCHAR(100)	NOT NULL
suburb	VARCHAR(50)	NOT NULL
postcode	VARCHAR(10)	NOT NULL
region	VARCHAR(50)	NOT NULL
country	VARCHAR(50)	NOT NULL

Customers
Column	Data Type	Rules
customerID	INT	IDENTITY
firstName	VARCHAR(100)	NOT NULL
lastName	VARCHAR(100)	NOT NULL
email	VARCHAR(100)	NOT NULL
mainPhoneNumber	VARCHAR(15)	NOT NULL
secondaryPhoneNumber	VARCHAR(15)
addressID	INT	FK

ItemCategories
Column	Data Type	Rules
categoryID	INT	IDENTITY
parentCategoryID	INT	FK
categoryName	VARCHAR(100)	NOT NULL

Items
Column	Data Type	Rules
itemID	INT	IDENTITY
itemName	VARCHAR(150)	NOT NULL
itemDescription	VARCHAR(MAX)	NOT NULL
itemCost	DECIMAL(10,2)	NOT NULL
itemImage	VARCHAR(MAX)	NOT NULL
categoryID	INT	FK

CustomerOrders
Column	Data Type	Rules
orderNumber	INT	IDENTITY
customerID	INT	FK
orderDate	DATE	NOT NULL, DEFAULT GetDate()
totalValue	DECIMAL(10,2)	NOT NULL
datePaid	DATE

ItemsInOrder
Column	Data Type	Rules
orderNumber	INT	FK
ItemID	INT	FK
numberOf	INT	NOT NULL, DEFAULT 1

Reviews
Columns	Data Type	Rules
customerID	INT	FK
itemID	INT	FK
reviewDate	DATE	NOT NULL, DEFAULT GetDate()
rating	INT	NOT NULL, CHECK(1-5)
reviewDescription	VARCHAR(MAX)	NOT NULL

1. Running the Queries
2. Load SQL Management Studio which you should have installed at this point.
3. Connect to your default Server (usually selected by default) by clicking "Connect"

Connect to Server Microsoft SQL Server 2012 Server type: Server name: Authentication: User name: Password: Connect Database Engine P112-02\SQLEXPRESS Windows Authentication UNINET kellydr Remember password Cancel Help x Options >>