USE [master]
GO

CREATE DATABASE [shopping]

GO

USE [shopping]
GO

Create Table Category
(
Category_Id int IDENTITY (10000,1) Primary Key,
Category_Name varchar(50) not null
)

GO

USE [shopping]
GO

create table Brands
(
Brand_Id int IDENTITY(20000,1) PRIMARY KEY,
Brand_Name varchar(50),
Category_Id int FOREIGN KEY REFERENCES Category(Category_Id)not null
)

---Insert Into Category---
GO

USE [shopping]
GO

insert into Category values ('Clothing')
insert into Category values ('Electronics')
insert into Category values ('Phones & Tablets')


---Insert Into Brands---
GO

USE [shopping]
GO

insert into Brands values ('Levis',10000)
insert into Brands values ('Diners',10001)
insert into Brands values ('Bonanza',10003)

GO

USE [shopping]
GO

create table Items
(
Item_Id int IDENTITY(30000,1) PRIMARY KEY,
Item_Name varchar(50) not null,
Brand_Id int FOREIGN KEY REFERENCES Brands(Brand_Id)not null,
Item_Price varchar(10) not null,
Item_Description varchar(500) not Null,
Shipping_Information varchar(250) not null
)

GO

USE [shopping]
GO

create table Comments
(
Comment_Id int IDENTITY(40000,1) PRIMARY KEY,
Comments varchar(50) not null,
Item_Id int FOREIGN KEY REFERENCES Items(Item_Id)not null,
)


GO

USE [shopping]
GO

create table Ratings
(
Rating_Id int IDENTITY(50000,1) PRIMARY KEY,
Rating int not null,
Item_Id int FOREIGN KEY REFERENCES Items(Item_Id)not null,
)