dữ liệu

avatar
unknown
plain_text
2 years ago
13 kB
6
Indexable
USE ShopFlower
Go

select * from SalesPerson
insert into SalesPerson(PersonID,[first_name],[last_name],Salary,Birthdate,Gender,Hiring_date,Mobile_number)
values ('961111111','Nguyen Hoang','Nam','5400000','1988-12-21','Male','2020-07-12','0931174477')
insert into SalesPerson(PersonID,[first_name],[last_name],Salary,Birthdate,Gender,Hiring_date,Mobile_number)
values ('961111112','Nguyen Trong','Hieu','5400000','1993-09-11','Male','2020-10-01','0931165444')
insert into SalesPerson(PersonID,[first_name],[last_name],Salary,Birthdate,Gender,Hiring_date,Mobile_number)
values ('961111113','Truong My','Linh','5000000','1996-02-11','Female','2020-02-01','0932681144')


select * from Colour

insert into Colour(ColorName,HexCode) values('Red','#FF0000')
insert into Colour(ColorName,HexCode) values('Maroon','#800000')
insert into Colour(ColorName,HexCode) values('DarkRed','#8B0000')
insert into Colour(ColorName,HexCode) values('Pink','#FFC0CB')
insert into Colour(ColorName,HexCode) values('MediumVioletRed','#C71585')
insert into Colour(ColorName,HexCode) values('PaleVioletRed','#DB7093')
insert into Colour(ColorName,HexCode) values('LightSalmon','#FFA07A')
insert into Colour(ColorName,HexCode) values('Orange','#FFA500')
insert into Colour(ColorName,HexCode) values('Yellow','#FFFF00')
insert into Colour(ColorName,HexCode) values('LemonChiffon','#FFFACD')
insert into Colour(ColorName,HexCode) values('Lavender','#E6E6FA')
insert into Colour(ColorName,HexCode) values('Orange','#FFA500')
insert into Colour(ColorName,HexCode) values('Purple','#800080')
insert into Colour(ColorName,HexCode) values('RebeccaPurple','#663399')
insert into Colour(ColorName,HexCode) values('LimeGreen','#32CD32')
insert into Colour(ColorName,HexCode) values('SeaGreen','#2E8B57')
insert into Colour(ColorName,HexCode) values('Olive','#808000')
insert into Colour(ColorName,HexCode) values('Teal','#008080')
insert into Colour(ColorName,HexCode) values('SkyBlue','#87CEEB')
insert into Colour(ColorName,HexCode) values('Navy','#000080')
insert into Colour(ColorName,HexCode) values('BlanchedAlmond','#FFEBCD')
insert into Colour(ColorName,HexCode) values('Sienna','#A0522D')
insert into Colour(ColorName,HexCode) values('White','#FFFFFF')
insert into Colour(ColorName,HexCode) values('Snow','#FFFAFA')
insert into Colour(ColorName,HexCode) values('Gold','#FFD700')

select * from Occasion

insert into Occasion(Title) values ('Birthday')
insert into Occasion(Title) values ('Anniversary')
insert into Occasion(Title) values ('Valentine')
insert into Occasion(Title) values ('Funeral')
insert into Occasion(Title) values ('Appreciation')
insert into Occasion(Title) values ('Other')

select * from Customer

insert into Customer([FirstName],[LastName],Addess,Phone,BirthDate,Gender) 
values('Nguyen Nhu','Ngoc','01 Hoa Binh, Ninh Kieu, Can Tho','0979247331','1989-09-30','Female')
insert into Customer([FirstName],[LastName],Addess,Phone,BirthDate,Gender) 
values('Nguyen Thanh','Truc','Khu Bai boi Song Hong, Ninh Kieu, Can Tho','0786779955','1087-11-03','Female') 
insert into Customer([FirstName],[LastName],Addess,Phone,BirthDate,Gender) 
values('Tran Van','Quy','duong Hai Ba Trung, Ninh Kieu, Can Tho','079269996','1999-12-03','Male') 
insert into Customer([FirstName],[LastName],Addess,Phone,BirthDate,Gender) 
values('Hoang Xuan','Vinh','389R duong Nguyen Van CU Noi Dai','0798185555','1989-01-13','Male') 
insert into Customer([FirstName],[LastName],Addess,Phone,BirthDate,Gender) 
values('Nguyen Bao','Tran','Tran Nam Phu, Ninh Kieu, Can Tho','0973869657','1998-11-03','Female') 
insert into Customer([FirstName],[LastName],Addess,Phone,BirthDate,Gender) 
values('Nguyen Huyen','Tran','phuong An Binh, Cai Rang, Can Tho','0903845764','1997-08-03','Female') 
insert into Customer([FirstName],[LastName],Addess,Phone,BirthDate,Gender) 
values('Tran Van','Khoa','Long Tuyen, Binh Thuy, Can Tho','094623857','1980-09-30','Male')
insert into Customer([FirstName],[LastName],Addess,Phone,BirthDate,Gender) 
values('Hoang Vu','Thai','Le Hong Phong, Binh Thuy, Can Tho','0963857623','1998-11-03','Male') 


select * from GreenHouse

insert into GreenHouse([Name],[Manager],[Owner],[Address], ManagerPhone)
values ('Sadec flower village','Raha Ahmadi','Narges Taghados','Dong Thap','03177885594')
insert into GreenHouse([Name],[Manager],[Owner],[Address], ManagerPhone)
values ('Dalat market','Ghazale Zehtab','Ghazale Zehtab','Esfahan,Dalat','0313378897')
insert into GreenHouse([Name],[Manager],[Owner],[Address], ManagerPhone)
values ('Vinh Long market','Farimah Ataie','Nasim Zareie','Esfahan,Vinh Long','03166776654')

select * from SalesPerson where [role]='purchaser'
select * from GreenHouse
select * from Buy

insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate) 
values(1,'9378993266',1900000,'1398-12-02')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate) 
values(2,'9473955537',2900000,'1398-12-02')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate) 
values(3,'9678992212',1100000,'1398-12-02')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate) 
values(1,'9378993266',900000,'1398-12-03')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate) 
values(2,'9473955537',500000,'1398-12-03')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate) 
values(3,'9678992212',1000000,'1398-12-03')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate)  
values(1,'9378993266',1900000,'1398-12-04')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate) 
values(2,'9473955537',2900000,'1398-12-04')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate)  
values(3,'9678992212',1100000,'1398-12-04')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate) 
values(1,'9378993266',900000,'1398-12-05')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate)  
values(2,'9473955537',500000,'1398-12-05')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate) 
values(3,'9678992212',1000000,'1398-12-05')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate)  
values(1,'9378993266',900000,'1398-12-06')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate)  
values(2,'9473955537',500000,'1398-12-06')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate)  
values(3,'9678992212',600000,'1398-12-06')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate)  
values(1,'9378993266',900000,'1398-12-07')
insert into Buy(GreenHouseID,SalesPersonID,TotalPeyment,BuyDate)  
values(2,'9473955537',500000,'1398-12-07')


select * from Packaging
select * from Occasion
delete from Packaging
insert into Packaging(PackagType,Design,[Card])
values ('Basket','designer','Yes')
insert into Packaging(PackagType,PaperColorID,StringColorID,Design,[Card])
values ('Basket',119,102,'designer','No')
insert into Packaging(PackagType,Design,[Card])
values ('Basket','designer','No')
insert into Packaging(PackagType,Design,[Card])
values ('Bouquet/Dastegol','design shop','Yes')
insert into Packaging(PackagType,Design,[Card])
values ('Bouquet/Dastegol','design shop','No')
insert into Packaging(PackagType,PaperColorID,StringColorID,Design,PackageDescription,[Card])
values ('Bouquet/Dastegol',107,106,'design shop','I Love You','Yes')
insert into Packaging(PackagType,PaperColorID,StringColorID,Design,[Card])
values ('Bouquet/Dastegol',109,114,'design shop','Yes')
insert into Packaging(PackagType,Design,[Card])
values ('Single Flower','design shop','No')
insert into Packaging(PackagType,Design,PackageDescription,[Card])
values ('Single Flower','design shop','Use Red','No')

select * from Flower
select * from Buy
select * from FlowerType
select * from Colour
insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Rose',8000,'102','3',220,2)
insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Rose',8000,'100','3',200,2)

insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Rose',8000,'103','3',200,2)

insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Rose',8000,'122','3',100,2)

insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Aralia',19000,'111','3',180,3)

insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Aralia',21000,'122','3',180,3)

insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Aspidistra elatior',80000,'111','3',100,3)

insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Gazmania',40000,'107','14',20,6)

insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Virziya',60000,'124','14',20,6)

insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Virzayi',60000,'106','14',20,6)

insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Orkide',30000,'108','14',10,6)

insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Orkide',30000,'122','14',10,6)
insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Anar',50000,'100','14',10,6)
insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Sonbol',22000,'108','14',10,6)
insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Havertia',25000,'111','7',20,4)
insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Cerasula',60000,'111','7',100,4)
insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('kirsto',90000,'111','7',20,4)
insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[TypeID])
values ('Mirtilo',80000,'110','7',10,4)


select * from Customer
select * from Flower
select * from Packaging
select * from [Order]
select * from Occasion
select * from FlowersInOrder
insert into [Order] (CustomerID,Shopdate,PackageID,Total,Discount,OccasionID,Wrappingprice)
Values (100,'2022-06-03',2,200000,0,6,40000)

insert into [Order] (CustomerID,Shopdate,PackageID,Total,Discount,OccasionID,Wrappingprice)
Values (101,'2022-06-03',2,350000,0,1,130000)

insert into [Order] (CustomerID,Shopdate,PackageID,Total,Discount,OccasionID,Wrappingprice)
Values (103,'2022-06-03',6,1500000,0,6,25000)

insert into [Order] (CustomerID,Shopdate,PackageID,Total,Discount,OccasionID,Wrappingprice)
Values (104,'2022-06-03',6,150000,0,2,35000)

insert into [Order] (CustomerID,Shopdate,PackageID,Total,Discount,OccasionID,Wrappingprice)
Values (105,'2022-06-03',6,430000,0,1,40000)

insert into [Order] (CustomerID,Shopdate,PackageID,Total,Discount,OccasionID,Wrappingprice)
Values (100,'2022-06-04',6,30000,0,6,15000)

insert into [Order] (CustomerID,Shopdate,PackageID,Total,Discount,OccasionID,Wrappingprice)
Values (103,'2022-06-05',NULL,50000,0,6,10000)

insert into [Order] (CustomerID,Shopdate,PackageID,Total,Discount,OccasionID,Wrappingprice)
Values (104,'2022-06-05',NULL,250000,30000,1,40000)

insert into [Order] (CustomerID,Shopdate,PackageID,Total,Discount,OccasionID,Wrappingprice)
Values (105,'2022-06-05',NULL,100000,0,1,780000)


select * from Customer
select * from Flower
select * from [Order]
select * from SalesPerson
insert into [OrderDetail](CustomerID,PersonID,Shopdate,FlowerName,Price,GreenHouseID,Number,Total)
Values(100,'961111111','2022-06-03','Gazmania',2600000,1,1,2600000)
insert into [OrderDetail](CustomerID,PersonID,Shopdate,FlowerName,Price,GreenHouseID,Number,Total)
Values(101,'961111111','2022-06-03','Orkide',3800000,2,3,11400000)
insert into [OrderDetail](CustomerID,PersonID,Shopdate,FlowerName,Price,GreenHouseID,Number,Total)
Values(103,'961111111','2022-06-03','Havertia',1525000,1,1,1525000)
insert into [OrderDetail](CustomerID,PersonID,Shopdate,FlowerName,Price,GreenHouseID,Number,Total)
Values(104,'961111111','2022-06-03','Sonbol',185000,3,2,370000)
insert into [OrderDetail](CustomerID,PersonID,Shopdate,FlowerName,Price,GreenHouseID,Number,Total)
Values(100,'961111112','2022-06-04','Gazmania',450000,1,2,900000)
insert into [OrderDetail](CustomerID,PersonID,Shopdate,FlowerName,Price,GreenHouseID,Number,Total)
Values(104,'961111113','2022-06-05','Mirtilo',2600000,1,1,2600000  )
insert into [OrderDetail](CustomerID,PersonID,Shopdate,FlowerName,Price,GreenHouseID,Number,Total)
Values(105,'961111113','2022-06-05','Gazmania',2600000,1,1,2600000  )
Editor is loading...