Completing the CREATE TABLE statements Address Column Data Type Rules addressID INT IDENTITY addressLine VARCHAR(100) NOT NULL
Fantastic news! We've Found the answer you've been seeking!
Question:
- 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 | |
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 |
- Running the Queries
- Load SQL Management Studio which you should have installed at this point.
- Connect to your default Server (usually selected by default) by clicking "Connect"
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: