dữ liệu
unknown
plain_text
a year ago
19 kB
5
Indexable
Never
USE FlowerShop Go select * from SalesPerson insert into SalesPerson(PersonnelID,[firstname],[lastname],workinghour,[role],salary,birthdate,gender,hiringdate,Phonenumber) values ('961111111','Nguyen Hoang','Nam','8-13','florist','5400000','1988-12-21','Male','2020-07-12','0931174477') insert into SalesPerson(PersonnelID,[firstname],[lastname],workinghour,[role],salary,birthdate,gender,hiringdate,Phonenumber) values ('961111112','Nguyen Trong','Hieu','8-13','florist','5400000','1993-09-11','Male','2020-10-01','0931165444') insert into SalesPerson(PersonnelID,[firstname],[lastname],workinghour,[role],salary,birthdate,gender,hiringdate,Phonenumber) values ('961111113','Truong My','Linh','8-13','cashier','5000000','1996-02-11','Female','2020-02-01','0932681144') insert into SalesPerson(PersonnelID,[firstname],[lastname],workinghour,[role],salary,birthdate,gender,hiringdate,Phonenumber) values ('961111114','Nguyen Nhat','Sang','8-20','ShopPerson','10960000','1992-07-13','Male','2020-01-20','0937069595') insert into SalesPerson(PersonnelID,[firstname],[lastname],workinghour,[role],salary,birthdate,gender,hiringdate,Phonenumber) values ('9611111115','Nguyen Tan','Tai','15-19','florist','5400000','1996-01-21','Male','2020-07-01','0934064949') insert into SalesPerson(PersonnelID,[firstname],[lastname],workinghour,[role],salary,birthdate,gender,hiringdate,Phonenumber) values ('961111116','Thu','Ngan','19-23','florist','5400000','1998-12-11','Male','2020-01-01','0931163444') 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 FlowerType delete from FlowerType insert into FlowerType(Title,More_Info) values('Cut Flowers','Shakhe boride/') insert into FlowerType(Title,More_Info) values('Flowers','golhaye zinati baghche/') insert into FlowerType(Title,More_Info) values('Potted plant','Goldani bedoone Gol/') insert into FlowerType(Title) values('Cactus/Succulent') insert into FlowerType(Title,More_Info) values('Terrarium','Bagh shishei/') insert into FlowerType(Title,More_Info) values('Potted plant Flower','Goldani ba Gol/') 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 delete 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]) values ('làng Hoa Sa Đét','Raha Ahmadi','Narges Taghados','Dong Thap') insert into GreenHouse([name],[Manager],[Owner],[Address]) values ('BehtarinGiyah','Ghazale Zehtab','Ghazale Zehtab','Esfahan,Masir1') insert into GreenHouse([name],[Manager],[Owner],[Address]) values ('GoleZendegi','Farimah Ataie','Nasim Zareie','Esfahan,Masir2') select * from GreenHousePhones insert into GreenHousePhones([GreenHouseID],Managerphone,phone1,phone2,phone3) values(1,09134466887,03145564882,03177885594,03144687639) insert into GreenHousePhones([GreenHouseID],Managerphone,phone1,phone2,phone3) values(2,09357786773,03179904771,0313378897,03166512789) insert into GreenHousePhones([GreenHouseID],Managerphone,phone1,phone2) values(3,09130987698,03166445599,03166776654) select * from SalesPerson where [role]='purchaser' select * from GreenHouse select * from Buy insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(1,'9378993266',1900000,'1398-12-02') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(2,'9473955537',2900000,'1398-12-02') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(3,'9678992212',1100000,'1398-12-02') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(1,'9378993266',900000,'1398-12-03') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(2,'9473955537',500000,'1398-12-03') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(3,'9678992212',1000000,'1398-12-03') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(1,'9378993266',1900000,'1398-12-04') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(2,'9473955537',2900000,'1398-12-04') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(3,'9678992212',1100000,'1398-12-04') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(1,'9378993266',900000,'1398-12-05') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(2,'9473955537',500000,'1398-12-05') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(3,'9678992212',1000000,'1398-12-05') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(1,'9378993266',900000,'1398-12-06') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(2,'9473955537',500000,'1398-12-06') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(3,'9678992212',600000,'1398-12-06') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(1,'9378993266',900000,'1398-12-07') insert into Buy(GreenhouseID,SalesPersonID,Totalpeyment,Buy_date) values(2,'9473955537',500000,'1398-12-07') select * from Packaging select * from Occasion delete from Packaging insert into Packaging(Packag_Type,Design,[Card]) values ('Basket','I trust on florist','Yes') insert into Packaging(Packag_Type,Paper_Color_ID,String_Color_ID,Design,[Card]) values ('Basket',119,102,'I design myself','No') insert into Packaging(Packag_Type,Design,[Card]) values ('Basket','I trust on florist','No') insert into Packaging(Packag_Type,Design,[Card]) values ('Bouquet/Dastegol','I trust on florist','Yes') insert into Packaging(Packag_Type,Design,[Card]) values ('Bouquet/Dastegol','I trust on florist','No') insert into Packaging(Packag_Type,Paper_Color_ID,String_Color_ID,Design,Package_Description,[Card]) values ('Bouquet/Dastegol',107,106,'I design myself','I Love You on card','Yes') insert into Packaging(Packag_Type,Paper_Color_ID,String_Color_ID,Design,Package_Description,[Card]) values ('Bouquet/Dastegol',109,114,'I design myself','Proud of you on card','Yes') insert into Packaging(Packag_Type,Design,[Card]) values ('Single Flower','I trust on florist','No') insert into Packaging(Packag_Type,Design,Package_Description,[Card]) values ('Single Flower','I trust on florist','Use Red','No') select * from Flower select * from Buy select * from FlowerType select * from Colour insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Rose',8000,'102','3',220,2) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Rose',8000,'100','3',200,2) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Rose',8000,'103','3',200,2) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Rose',8000,'122','3',100,2) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Aralia',190000,'111','3',180,3) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Aralia',210000,'122','3',180,3) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Aspidistra elatior',80000,'111','3',100,3) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Gazmania',40000,'107','14',20,6) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Virziya',60000,'124','14',20,6) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Virzayi',600000,'106','14',20,6) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Orkide',300000,'108','14',10,6) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Orkide',300000,'122','14',10,6) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Anar',50000,'100','14',10,6) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Sonbol',22000,'108','14',10,6) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Havertia',25000,'111','7',20,4) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('Cerasula',60000,'111','7',100,4) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) values ('kirsto',90000,'111','7',20,4) insert into Flower(Flowername,Price,FlowercolorID,LastingTime,Number,[Type_ID]) 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,Ordertype,Shopdate,PackageID,TotalCost,Discount,FinalCost,OccasionID,Wrappingprice) Values (100,'Online','1398-12-02',2,0,0,0,6,40000) insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(1,2,20) insert into [Order] (CustomerID,Ordertype,Shopdate,PackageID,TotalCost,Discount,FinalCost,OccasionID,Wrappingprice) Values (101,'Online','1398-12-03',2,350000,0,350000,1,130000) insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(1,3,40) insert into [Order] (CustomerID,Ordertype,Shopdate,PackageID,TotalCost,Discount,FinalCost,OccasionID,Wrappingprice) Values (102,'Not_Online','1398-12-03',6,50000,0,50000,1,20000) insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(4,4,4) insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(4,3,4) insert into [Order] (CustomerID,Ordertype,Shopdate,PackageID,TotalCost,Discount,FinalCost,OccasionID,Wrappingprice,More_info) Values (103,'Not_Online','1398-12-03',6,1500000,0,1500000,6,25000,'All Reses are used') insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(5,4,150) insert into [Order] (CustomerID,Ordertype,Shopdate,PackageID,TotalCost,Discount,FinalCost,OccasionID,Wrappingprice) Values (104,'Not_Online','1398-12-04',6,150000,0,150000,2,35000) insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(6,4,9) insert into [Order] (CustomerID,Ordertype,Shopdate,PackageID,TotalCost,Discount,FinalCost,OccasionID,Wrappingprice) Values (105,'Not_Online','1398-12-04',6,430000,0,430000,1,40000) insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(7,3,12) insert into [Order] (CustomerID,Ordertype,Shopdate,PackageID,TotalCost,Discount,FinalCost,OccasionID,Wrappingprice) Values (100,'Not_Online','1398-12-04',6,30000,0,30000,6,15000) insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(8,2,2) insert into [Order] (CustomerID,Ordertype,Shopdate,PackageID,TotalCost,Discount,FinalCost,OccasionID,Wrappingprice,More_info) Values (103,'Not_Online','1398-12-05',NULL,50000,0,50000,6,10000,NULL) insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(9,19,1) insert into [Order] (CustomerID,Ordertype,Shopdate,PackageID,TotalCost,Discount,FinalCost,OccasionID,Wrappingprice) Values (104,'Not_Online','1398-12-05',NULL,250000,30000,220000,1,40000) insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(10,15,4) insert into [Order] (CustomerID,Ordertype,Shopdate,PackageID,TotalCost,Discount,FinalCost,OccasionID,Wrappingprice) Values (105,'Not_Online','1398-12-05',NULL,100000,0,100000,1,780000) insert into FlowersInOrder(Order_ID,Flower_ID,Number) values(11,4,2) select * from BoughtFlower; select * from Buy select * from Flower insert into BoughtFlower values(1,2,300,150000) insert into BoughtFlower values(1,3,900,450000) insert into BoughtFlower values(1,4,300,150000) insert into BoughtFlower values(1,5,300,150000) insert into BoughtFlower values(4,2,600,300000) insert into BoughtFlower values(4,3,900,450000) insert into BoughtFlower values(4,4,300,150000) insert into BoughtFlower values(4,5,300,150000) insert into BoughtFlower values(7,2,600,300000) insert into BoughtFlower values(7,3,900,450000) insert into BoughtFlower values(7,4,300,150000) insert into BoughtFlower values(7,5,300,150000) insert into BoughtFlower values(10,2,600,300000) insert into BoughtFlower values(10,3,900,450000) insert into BoughtFlower values(10,4,300,150000) insert into BoughtFlower values(10,5,300,150000) insert into BoughtFlower values(13,2,600,300000) insert into BoughtFlower values(13,3,900,450000) insert into BoughtFlower values(13,4,300,150000) insert into BoughtFlower values(13,5,300,150000) insert into BoughtFlower values(16,2,600,300000) insert into BoughtFlower values(16,3,900,450000) insert into BoughtFlower values(16,4,300,150000) insert into BoughtFlower values(16,5,300,150000) insert into BoughtFlower values(19,2,600,300000) insert into BoughtFlower values(19,3,900,450000) insert into BoughtFlower values(19,4,300,150000) insert into BoughtFlower values(19,5,300,150000) insert into BoughtFlower values(21,2,600,300000) insert into BoughtFlower values(21,3,900,450000) insert into BoughtFlower values(21,4,300,150000) insert into BoughtFlower values(21,5,300,150000) insert into BoughtFlower values(24,2,600,300000) insert into BoughtFlower values(24,3,900,450000) insert into BoughtFlower values(24,4,300,150000) insert into BoughtFlower values(24,5,300,150000) insert into BoughtFlower values(27,2,600,300000) insert into BoughtFlower values(27,3,900,450000) insert into BoughtFlower values(27,4,300,150000) insert into BoughtFlower values(27,5,300,150000) insert into BoughtFlower values(30,2,600,300000) insert into BoughtFlower values(30,3,900,450000) insert into BoughtFlower values(30,4,300,150000) insert into BoughtFlower values(30,5,300,150000) insert into BoughtFlower values(2,6,100,1000000) insert into BoughtFlower values(2,7,200,1000000) insert into BoughtFlower values(2,8,300,1000000) insert into BoughtFlower values(2,9,300,1000000) insert into BoughtFlower values(5,6,100,1000000) insert into BoughtFlower values(5,7,200,1000000) insert into BoughtFlower values(5,8,300,1000000) insert into BoughtFlower values(5,9,300,1000000) insert into BoughtFlower values(8,6,100,1000000) insert into BoughtFlower values(8,7,200,1000000) insert into BoughtFlower values(11,8,300,1000000) insert into BoughtFlower values(11,9,300,1000000) insert into BoughtFlower values(3,10,100,1000000) insert into BoughtFlower values(3,11,200,1000000) insert into BoughtFlower values(6,12,300,900000) insert into BoughtFlower values(6,13,300,2000000) insert into BoughtFlower values(9,10,100,1000000) insert into BoughtFlower values(9,11,200,1000000) insert into BoughtFlower values(12,12,300,900000) insert into BoughtFlower values(12,13,300,2000000) insert into BoughtFlower values(9,14,500,1000000) insert into BoughtFlower values(9,15,200,1000000) insert into BoughtFlower values(12,16,340,780000) insert into BoughtFlower values(12,17,340,2000000) insert into BoughtFlower values(15,14,500,1000000) insert into BoughtFlower values(15,15,200,1000000) insert into BoughtFlower values(18,16,340,780000) insert into BoughtFlower values(18,17,340,2000000) insert into BoughtFlower values(22,14,500,1000000) insert into BoughtFlower values(22,15,200,1000000) insert into BoughtFlower values(25,18,340,780000) insert into BoughtFlower values(25,19,340,2000000)