Nhóm 2

TẠO CSDL QUẢN LÝ VẬT TƯ

DỰ ÁN XÂY DỰNG

Giáo viên hướng dẫn : Trần Nguyên Hoàng

Thông tin thành viên trong nhóm :

1.Nguyễn Mạnh Cường - MSV: 1400088

2.Lê Thái Hòa - MSV:1400133

3.Ngô Xuân Cường - MSV: 1466704

4.Nhữ Công Vụ - MSV:1400132

use master;
if exists (select * from sys.databases where name = 'BTNhom')
drop database BTNhom;
go
create database BTNhom;
go

use BTNhom;
go

CREATE TABLE NhaCungCap
(
MaNCC char(10) constraint pk_NhaCungCap_MaNCC primary key,
TenNCC nvarchar(50) not null,
DiaChi nvarchar(50) not null
)
go

insert into NhaCungCap values ( 'A1','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A2','Cong TyB','Ha Noi');
insert into NhaCungCap values ( 'A3','Cong TyD','Ha Noi');
insert into NhaCungCap values ( 'A4','Cong TyY','Ha Noi');
insert into NhaCungCap values ( 'A5','Cong TyABC','Ha Noi');
insert into NhaCungCap values ( 'A6','Cong TyAL','Ha Noi');
insert into NhaCungCap values ( 'A7','Cong TyP','Ha Noi');
insert into NhaCungCap values ( 'A8','Cong TyR','Ha Noi');
insert into NhaCungCap values ( 'A9','Cong TyAV','Ha Noi');
insert into NhaCungCap values ( 'A10','Cong TyW','Ha Noi');
insert into NhaCungCap values ( 'A11','Cong TyRR','Ha Noi');
insert into NhaCungCap values ( 'A12','Cong TyWWW','Ha Noi');
insert into NhaCungCap values ( 'A13','Cong TyANN','Ha Noi');
insert into NhaCungCap values ( 'A14','Cong TyAM','Ha Noi');
insert into NhaCungCap values ( 'A15','Cong TyUE','Ha Noi');
insert into NhaCungCap values ( 'A16','Cong TyWTO','Ha Noi');
insert into NhaCungCap values ( 'A17','Cong TyMTV','Ha Noi');
insert into NhaCungCap values ( 'A18','Cong TyEE','Ha Noi');
insert into NhaCungCap values ( 'A19','Cong TyQQ','Ha Noi');
insert into NhaCungCap values ( 'A20','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A21','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A22','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A23','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A24','Cong TyOO','Ha Noi');
insert into NhaCungCap values ( 'A25','Cong TyADC','Ha Noi');
insert into NhaCungCap values ( 'A26','Cong TySS','Ha Noi');
insert into NhaCungCap values ( 'A27','Cong TyAPR','Ha Noi');
insert into NhaCungCap values ( 'A28','Cong TyWWT','Ha Noi');
insert into NhaCungCap values ( 'A29','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A30','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A31','Cong TyVV','Ha Noi');
insert into NhaCungCap values ( 'A32','Cong TyWWF','Ha Noi');
insert into NhaCungCap values ( 'A33','Cong TyAHH','Ha Noi');
insert into NhaCungCap values ( 'A34','Cong TyNTT','Ha Noi');
insert into NhaCungCap values ( 'A35','Cong TyNTAV','Ha Noi');
insert into NhaCungCap values ( 'A36','Cong Ty CA','Ha Noi');
insert into NhaCungCap values ( 'A37','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A38','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A39','Cong TyTNH','Ha Noi');
insert into NhaCungCap values ( 'A40','Cong TyAT','Ha Noi');
insert into NhaCungCap values ( 'A41','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A42','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A43','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A44','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A45','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A46','Cong TyART','Ha Noi');
insert into NhaCungCap values ( 'A47','Cong TyQQ','Ha Noi');
insert into NhaCungCap values ( 'A48','Cong TyYUO','Ha Noi');
insert into NhaCungCap values ( 'A49','Cong TyABNM','Ha Noi');
insert into NhaCungCap values ( 'A50','Cong TyAZZ','Ha Noi');
insert into NhaCungCap values ( 'A51','Cong TyASS','Ha Noi');
insert into NhaCungCap values ( 'A52','Cong TyAJJ','Ha Noi');
insert into NhaCungCap values ( 'A53','Cong TyAII','Ha Noi');
insert into NhaCungCap values ( 'A54','Cong TyAQQ','Ha Noi');
insert into NhaCungCap values ( 'A55','Cong TyAFF','Ha Noi');
insert into NhaCungCap values ( 'A56','Cong TyAW','Ha Noi');
insert into NhaCungCap values ( 'A57','Cong TyAY','Ha Noi');
insert into NhaCungCap values ( 'A58','Cong TyAI','Ha Noi');
insert into NhaCungCap values ( 'A59','Cong TyAS','Ha Noi');
insert into NhaCungCap values ( 'A60','Cong TyAB','Ha Noi');
insert into NhaCungCap values ( 'A61','Cong TyAX','Ha Noi');
insert into NhaCungCap values ( 'A62','Cong TyAA','Ha Noi');
insert into NhaCungCap values ( 'A63','Cong TyAL','Ha Noi');
insert into NhaCungCap values ( 'A64','Cong TyAPP','Ha Noi');
insert into NhaCungCap values ( 'A65','Cong TyAFF','Ha Noi');
insert into NhaCungCap values ( 'A66','Cong TyBN','Ha Noi');
insert into NhaCungCap values ( 'A67','Cong TyBM','Ha Noi');
insert into NhaCungCap values ( 'A68','Cong TyHY','Ha Noi');
insert into NhaCungCap values ( 'A69','Cong TyDW','Ha Noi');
insert into NhaCungCap values ( 'A70','Cong TyOP','Ha Noi');
insert into NhaCungCap values ( 'A71','Cong TyTR','Ha Noi');
insert into NhaCungCap values ( 'A72','Cong TyQA','Ha Noi');
insert into NhaCungCap values ( 'A73','Cong TyGB','Ha Noi');
insert into NhaCungCap values ( 'A74','Cong TyDR','Ha Noi');
insert into NhaCungCap values ( 'A75','Cong TyTH','Ha Noi');
insert into NhaCungCap values ( 'A76','Cong TyTIO','Ha Noi');
insert into NhaCungCap values ( 'A77','Cong TyZX','Ha Noi');
insert into NhaCungCap values ( 'A78','Cong TyAS','Ha Noi');
insert into NhaCungCap values ( 'A79','Cong TyKL','Ha Noi');
insert into NhaCungCap values ( 'A80','Cong TyR','Ha Noi');
insert into NhaCungCap values ( 'A81','Cong TyQ','Ha Noi');
insert into NhaCungCap values ( 'A82','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A83','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A84','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A85','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A86','Cong TyGG','Ha Noi');
insert into NhaCungCap values ( 'A87','Cong TyV','Ha Noi');
insert into NhaCungCap values ( 'A88','Cong TyB','Ha Noi');
insert into NhaCungCap values ( 'A89','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A90','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A91','Cong TyT','Ha Noi');
insert into NhaCungCap values ( 'A92','Cong TyRR','Ha Noi');
insert into NhaCungCap values ( 'A93','Cong TyDD','Ha Noi');
insert into NhaCungCap values ( 'A94','Cong TyTT','Ha Noi');
insert into NhaCungCap values ( 'A95','Cong TyOO','Ha Noi');
insert into NhaCungCap values ( 'A96','Cong TyGG','Ha Noi');
insert into NhaCungCap values ( 'A97','Cong TyABC','Ha Noi');
insert into NhaCungCap values ( 'A98','Cong TyHJK','Ha Noi');
insert into NhaCungCap values ( 'A99','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A100','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A101','Cong TyBC','Ha Noi');
insert into NhaCungCap values ( 'A102','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A103','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A104','Cong TyXC','Ha Noi');
insert into NhaCungCap values ( 'A105','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A106','Cong TyZX','Ha Noi');
insert into NhaCungCap values ( 'A107','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A108','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A109','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A110','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A111','Cong TyAGG','Ha Noi');
insert into NhaCungCap values ( 'A112','Cong TyASS','Ha Noi');
insert into NhaCungCap values ( 'A113','Cong TyAMX','Ha Noi');
insert into NhaCungCap values ( 'A114','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A115','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A116','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A117','Cong TyFR','Ha Noi');
insert into NhaCungCap values ( 'A118','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A119','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A120','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A121','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A122','Cong TyTR','Ha Noi');
insert into NhaCungCap values ( 'A123','Cong Ty?A','Ha Noi');
insert into NhaCungCap values ( 'A124','Cong TyPO','Ha Noi');
insert into NhaCungCap values ( 'A125','Cong TyAQ','Ha Noi');
insert into NhaCungCap values ( 'A126','Cong TySSD','Ha Noi');
insert into NhaCungCap values ( 'A127','Cong TyAXC','Ha Noi');
insert into NhaCungCap values ( 'A128','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A129','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A130','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A131','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A132','Cong TyTRE','Ha Noi');
insert into NhaCungCap values ( 'A133','Cong TyTRING','Ha Noi');
insert into NhaCungCap values ( 'A134','Cong TyBV','Ha Noi');
insert into NhaCungCap values ( 'A135','Cong TyXA','Ha Noi');
insert into NhaCungCap values ( 'A136','Cong TySF','Ha Noi');
insert into NhaCungCap values ( 'A137','Cong TyAQ','Ha Noi');
insert into NhaCungCap values ( 'A138','Cong TyBG','Ha Noi');
insert into NhaCungCap values ( 'A139','Cong TyNY','Ha Noi');
insert into NhaCungCap values ( 'A140','Cong TyXE','Ha Noi');
insert into NhaCungCap values ( 'A141','Cong TyVT','Ha Noi');
insert into NhaCungCap values ( 'A142','Cong TyNY','Ha Noi');
insert into NhaCungCap values ( 'A143','Cong TyALL','Ha Noi');
insert into NhaCungCap values ( 'A144','Cong TyABG','Ha Noi');
insert into NhaCungCap values ( 'A145','Cong TyDV','Ha Noi');
insert into NhaCungCap values ( 'A146','Cong TyFB','Ha Noi');
insert into NhaCungCap values ( 'A147','Cong TyQA','Ha Noi');
insert into NhaCungCap values ( 'A148','Cong TyAF','Ha Noi');
insert into NhaCungCap values ( 'A149','Cong TyTN','Ha Noi');
insert into NhaCungCap values ( 'A150','Cong TySC','Ha Noi');
insert into NhaCungCap values ( 'A151','Cong TyGN','Ha Noi');
insert into NhaCungCap values ( 'A152','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A153','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A154','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A155','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A156','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A157','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A158','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A159','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A160','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A161','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A162','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A163','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A164','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A165','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A166','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A167','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A168','Cong TyDV','Ha Noi');
insert into NhaCungCap values ( 'A169','Cong TySC','Ha Noi');
insert into NhaCungCap values ( 'A170','Cong TyALO','Ha Noi');
insert into NhaCungCap values ( 'A171','Cong TyAG','Ha Noi');
insert into NhaCungCap values ( 'A172','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A173','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A174','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A175','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A176','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A177','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A178','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A179','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A180','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A181','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A182','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A183','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A184','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A185','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A186','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A187','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A188','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A189','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A190','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A191','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A192','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A193','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A194','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A195','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A196','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A197','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A198','Cong TyG','Ha Noi');
insert into NhaCungCap values ( 'A199','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A200','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A201','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A202','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A203','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A204','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A205','Cong TyAHH','Ha Noi');
insert into NhaCungCap values ( 'A206','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A207','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A208','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A209','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A210','Cong TyRTREW','Ha Noi');
insert into NhaCungCap values ( 'A211','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A212','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A213','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A214','Cong TyATY','Ha Noi');
insert into NhaCungCap values ( 'A215','Cong TyBG','Ha Noi');
insert into NhaCungCap values ( 'A216','Cong TySD','Ha Noi');
insert into NhaCungCap values ( 'A217','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A218','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A219','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A220','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A221','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A222','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A223','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A224','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A225','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A226','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A227','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A228','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A229','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A230','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A231','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A232','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A233','Cong Ty?ER','Ha Noi');
insert into NhaCungCap values ( 'A234','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A235','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A236','Cong TyBGH','Ha Noi');
insert into NhaCungCap values ( 'A237','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A238','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A239','Cong TyAA','Ha Noi');
insert into NhaCungCap values ( 'A240','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A241','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A242','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A243','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A244','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A245','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A246','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A247','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A248','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A249','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A250','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A251','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A252','Cong TyYOI','Ha Noi');
insert into NhaCungCap values ( 'A253','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A254','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A255','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A256','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A257','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A258','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A259','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A260','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A261','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A262','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A263','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A264','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A265','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A266','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A267','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A268','Cong TyGTHK','Ha Noi');
insert into NhaCungCap values ( 'A269','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A270','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A271','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A272','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A273','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A274','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A275','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A276','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A277','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A278','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A279','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A280','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A281','Cong Ty?ER','Ha Noi');
insert into NhaCungCap values ( 'A282','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A283','Cong TyHYU','Ha Noi');
insert into NhaCungCap values ( 'A284','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A285','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A286','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A287','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A288','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A289','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A290','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A291','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A292','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A293','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A294','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A295','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A296','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A297','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A298','Cong TyVGBN','Ha Noi');
insert into NhaCungCap values ( 'A299','Cong TyA','Ha Noi');
insert into NhaCungCap values ( 'A300','Cong TyA','Ha Noi');
insert into NhaCungCap values ('A301', 'Cong Ty TNHH', 'Ha Noi');
insert into NhaCungCap values ('A302', 'Cong Ty Than', 'Quang Ninh');
insert into NhaCungCap values ('A303', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A304', 'Cong Ty C', 'Ho Chi Minh');
insert into NhaCungCap values ('A305', 'Cong Ty B', 'Quang Ngai');
insert into NhaCungCap values ('A306', 'Cong Ty D', 'Da Nang ');
insert into NhaCungCap values ('A307', 'Cong Ty Z', 'Quang Ninh');
insert into NhaCungCap values ('A308', 'Cong Ty N', 'Quang Ninh');
insert into NhaCungCap values ('A309', 'Cong Ty K', 'Nghe An');
insert into NhaCungCap values ('A310', 'Cong Ty H', 'Quang Ninh');
insert into NhaCungCap values ('A311', 'Cong Ty M', 'Ha Noi');
insert into NhaCungCap values ('A312', 'Cong Ty N', 'Da Lat');
insert into NhaCungCap values ('A313', 'Cong Ty I', 'Quang Ninh');
insert into NhaCungCap values ('A314', 'Cong Ty O', 'Hai Duong');
insert into NhaCungCap values ('A315', 'Cong Ty E', 'Vinh Yen');
insert into NhaCungCap values ('A316', 'Cong Ty B', 'Vinh Phuc');
insert into NhaCungCap values ('A317', 'Cong Ty F', 'Quang Ninh');
insert into NhaCungCap values ('A318', 'Cong Ty P', 'Quang Ngai');
insert into NhaCungCap values ('A319', 'Cong Ty D', 'Ha Noi');
insert into NhaCungCap values ('A320', 'Cong Ty B', 'Nghe An');
insert into NhaCungCap values ('A321', 'Cong Ty S', 'Ha Noi');
insert into NhaCungCap values ('A322', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A323', 'Cong Ty B', 'Hai Phong');
insert into NhaCungCap values ('A324', 'Cong Ty B', 'Yen Bai');
insert into NhaCungCap values ('A325', 'Cong Ty B', 'Son La');
insert into NhaCungCap values ('A326', 'Cong Ty B', 'Lang Son');
insert into NhaCungCap values ('A327', 'Cong Ty K', ' Ha Noi');
insert into NhaCungCap values ('A328', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A329', 'Cong TyN', 'Quang Ninh');
insert into NhaCungCap values ('A330', 'Cong Ty K', 'Quang Ninh');
insert into NhaCungCap values ('A331', 'Cong Ty U', 'Quang Ninh');
insert into NhaCungCap values ('A3332', 'Cong Ty Y', 'Quang Ninh');
insert into NhaCungCap values ('A333', 'Cong Ty T', 'Quang Ninh');
insert into NhaCungCap values ('A334', 'Cong Ty E', 'Quang Ninh');
insert into NhaCungCap values ('A335', 'Cong Ty Q', 'Quang Ninh');
insert into NhaCungCap values ('A336', 'Cong Ty D', 'Quang Ninh');
insert into NhaCungCap values ('A337', 'Cong Ty H', 'Quang Ninh');
insert into NhaCungCap values ('A338', 'Cong Ty I', 'Quang Ninh');
insert into NhaCungCap values ('A339', 'Cong Ty VU', 'Quang Ninh');
insert into NhaCungCap values ('A340', 'Cong Ty NM', 'Quang Ninh');
insert into NhaCungCap values ('A341', 'Cong TyET', 'Quang Ninh');
insert into NhaCungCap values ('A342', 'Cong Ty UO', 'Quang Ninh');
insert into NhaCungCap values ('A343', 'Cong Ty BP', 'Quang Ninh');
insert into NhaCungCap values ('A344', 'Cong Ty GH', 'Quang Ninh');
insert into NhaCungCap values ('A345', 'Cong Ty HU', 'Quang Ninh');
insert into NhaCungCap values ('A346', 'Cong Ty GT', 'Quang Ninh');
insert into NhaCungCap values ('A347', 'Cong Ty ML', 'Quang Ninh');
insert into NhaCungCap values ('A348', 'Cong Ty NU', 'Quang Ninh');
insert into NhaCungCap values ('A349', 'Cong Ty TF', 'Quang Ninh');
insert into NhaCungCap values ('A350', 'Cong Ty TI', 'Quang Ninh');
insert into NhaCungCap values ('A351', 'Cong Ty EN', 'Quang Ninh');
insert into NhaCungCap values ('A352', 'Cong Ty MU', 'Quang Ninh');
insert into NhaCungCap values ('A353', 'Cong Ty Than', 'Quang Ninh');
insert into NhaCungCap values ('A354', 'Cong Ty VB', 'Quang Ninh');
insert into NhaCungCap values ('A355', 'Cong Ty BU', 'Quang Ninh');
insert into NhaCungCap values ('A356', 'Cong Ty BY', 'Quang Ninh');
insert into NhaCungCap values ('A357', 'Cong Ty BO', 'Quang Ninh');
insert into NhaCungCap values ('A358', 'Cong Ty BM', 'Quang Ninh');
insert into NhaCungCap values ('A359', 'Cong Ty BP', 'Quang Ninh');
insert into NhaCungCap values ('A360', 'Cong Ty BT', 'Quang Ninh');
insert into NhaCungCap values ('A361', 'Cong Ty BE', 'Quang Ninh');
insert into NhaCungCap values ('A362', 'Cong Ty BQ', 'Quang Ninh');
insert into NhaCungCap values ('A363', 'Cong Ty BC', 'Quang Ninh');
insert into NhaCungCap values ('A364', 'Cong Ty BS', 'Quang Ninh');
insert into NhaCungCap values ('A365', 'Cong Ty BMN', 'Quang Ninh');
insert into NhaCungCap values ('A366', 'Cong Ty BUI', 'Quang Ninh');
insert into NhaCungCap values ('A367', 'Cong Ty BNI', 'Quang Ninh');
insert into NhaCungCap values ('A368', 'Cong Ty BUY', 'Quang Ninh');
insert into NhaCungCap values ('A369', 'Cong Ty BTB', 'Quang Ninh');
insert into NhaCungCap values ('A370', 'Cong Ty BMNI', 'Quang Ninh');
insert into NhaCungCap values ('A371', 'Cong Ty BQ', 'Quang Ninh');
insert into NhaCungCap values ('A372', 'Cong Ty But', 'Quang Ninh');
insert into NhaCungCap values ('A373', 'Cong Ty Bni', 'Quang Ninh');
insert into NhaCungCap values ('A374', 'Cong Ty Bmk', 'Quang Ninh');
insert into NhaCungCap values ('A375', 'Cong Ty Bhui', 'Quang Ninh');
insert into NhaCungCap values ('A376', 'Cong Ty Btyd', 'Quang Ninh');
insert into NhaCungCap values ('A377', 'Cong Ty Bety', 'Quang Ninh');
insert into NhaCungCap values ('A378', 'Cong Ty Biuy', 'Quang Ninh');
insert into NhaCungCap values ('A379', 'Cong Ty Biu', 'Quang Ninh');
insert into NhaCungCap values ('A380', 'Cong Ty Buti', 'Quang Ninh');
insert into NhaCungCap values ('A381', 'Cong Ty Bmk', 'Quang Ninh');
insert into NhaCungCap values ('A382', 'Cong Ty Bvtg', 'Quang Ninh');
insert into NhaCungCap values ('A383', 'Cong Ty Bqaz', 'Quang Ninh');
insert into NhaCungCap values ('A384', 'Cong Ty Bc', 'Quang Ninh');
insert into NhaCungCap values ('A385', 'Cong Ty Brfv', 'Quang Ninh');
insert into NhaCungCap values ('A386', 'Cong Ty Btgb', 'Quang Ninh');
insert into NhaCungCap values ('A387', 'Cong Ty Byhn', 'Quang Ninh');
insert into NhaCungCap values ('A388', 'Cong Ty Bm', 'Quang Ninh');
insert into NhaCungCap values ('A389', 'Cong Ty Bikl', 'Quang Ninh');
insert into NhaCungCap values ('A390', 'Cong Ty Bpo', 'Quang Ninh');
insert into NhaCungCap values ('A391', 'Cong Ty Byut', 'Quang Ninh');
insert into NhaCungCap values ('A392', 'Cong Ty Bnhu', 'Quang Ninh');
insert into NhaCungCap values ('A393', 'Cong Ty ikj', 'Quang Ninh');
insert into NhaCungCap values ('A394', 'Cong Ty oiy', 'Quang Ninh');
insert into NhaCungCap values ('A395', 'Cong Ty thuy', 'Quang Ninh');
insert into NhaCungCap values ('A396', 'Cong Ty ths', 'Quang Ninh');
insert into NhaCungCap values ('A397', 'Cong Ty enhm', 'Quang Ninh');
insert into NhaCungCap values ('A398', 'Cong Ty iou', 'Quang Ninh');
insert into NhaCungCap values ('A399', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A400', 'Cong Ty hhh', 'Quang Ninh');
insert into NhaCungCap values ('A401', 'Cong Ty Bgbm', 'Quang Ninh');
insert into NhaCungCap values ('A402', 'Cong Ty Bmji', 'Quang Ninh');
insert into NhaCungCap values ('A403', 'Cong Ty Bgi', 'Quang Ninh');
insert into NhaCungCap values ('A404', 'Cong Ty Bgc', 'Quang Ninh');
insert into NhaCungCap values ('A405', 'Cong Ty Bgm', 'Quang Ninh');
insert into NhaCungCap values ('A406', 'Cong Ty Bkiu', 'Quang Ninh');
insert into NhaCungCap values ('A407', 'Cong Ty Bted', 'Quang Ninh');
insert into NhaCungCap values ('A408', 'Cong Ty Bd', 'Quang Ninh');
insert into NhaCungCap values ('A409', 'Cong Ty Bmgju', 'Quang Ninh');
insert into NhaCungCap values ('A410', 'Cong Ty Bnghu', 'Quang Ninh');
insert into NhaCungCap values ('A411', 'Cong Ty Buyt', 'Quang Ninh');
insert into NhaCungCap values ('A412', 'Cong Ty Bkh', 'Quang Ninh');
insert into NhaCungCap values ('A413', 'Cong Ty Bksau', 'Quang Ninh');
insert into NhaCungCap values ('A414', 'Cong Ty Bvnfjh', 'Quang Ninh');
insert into NhaCungCap values ('A415', 'Cong Ty Bak', 'Quang Ninh');
insert into NhaCungCap values ('A416', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A417', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A418', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A419', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A420', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A421', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A422', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A423', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A424', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A425', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A426', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A427', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A428', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A430', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A431', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A432', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A433', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A434', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A435', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A436', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A437', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A438', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A439', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A440', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A441', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A442', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A443', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A444', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A445', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A446', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A447', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A448', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A449', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A450', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A451', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A452', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A453', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A454', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A455', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A456', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A457', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A458', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A459', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A460', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A461', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A462', 'Cong Ty B', 'Quang Ninh');
insert into NhaCungCap values ('A463', 'Cong Ty kitu', 'Quang Ninh');
insert into NhaCungCap values ('A464', 'Cong Ty Biuy', 'Quang Ninh');
insert into NhaCungCap values ('A465', 'Cong Ty Bc', 'Quang Ninh');
insert into NhaCungCap values ('A466', 'Cong Ty Biuty', 'Quang Ninh');
insert into NhaCungCap values ('A467', 'Cong Ty Ber', 'Quang Ninh');
insert into NhaCungCap values ('A468', 'Cong Ty Btyu', 'Quang Ninh');
insert into NhaCungCap values ('A469', 'Cong Ty Bxds', 'Quang Ninh');
insert into NhaCungCap values ('A470', 'Cong Ty Bty', 'Quang Ninh');
insert into NhaCungCap values ('A471', 'Cong Ty Bhuy', 'Quang Ninh');
insert into NhaCungCap values ('A472', 'Cong Ty Bdh', 'Quang Ninh');
insert into NhaCungCap values ('A473', 'Cong Ty iuyt', 'Quang Ninh');
insert into NhaCungCap values ('A474', 'Cong Ty ihjkc', 'Quang Ninh');
insert into NhaCungCap values ('A475', 'Cong Ty uhjn', 'Quang Ninh');
insert into NhaCungCap values ('A476', 'Cong Ty teyr', 'Quang Ninh');
insert into NhaCungCap values ('A477', 'Cong Ty jghjf', 'Quang Ninh');
insert into NhaCungCap values ('A478', 'Cong Ty nghj', 'Quang Ninh');
insert into NhaCungCap values ('A479', 'Cong Ty utyi', 'Quang Ninh');
insert into NhaCungCap values ('A480', 'Cong Ty etr', 'Quang Ninh');
insert into NhaCungCap values ('A481', 'Cong Ty bght', 'Quang Ninh');
insert into NhaCungCap values ('A482', 'Cong Ty iuy', 'Quang Ninh');
insert into NhaCungCap values ('A483', 'Cong Ty tyu', 'Quang Ninh');
insert into NhaCungCap values ('A484', 'Cong Ty ndu', 'Quang Ninh');
insert into NhaCungCap values ('A485', 'Cong Ty ikj', 'Quang Ninh');
insert into NhaCungCap values ('A486', 'Cong Ty Bh', 'Quang Ninh');
insert into NhaCungCap values ('A487', 'Cong Ty Bkoi', 'Quang Ninh');
insert into NhaCungCap values ('A488', 'Cong Ty Baqw', 'Quang Ninh');
insert into NhaCungCap values ('A489', 'Cong Ty Buyt', 'Quang Ninh');
insert into NhaCungCap values ('A490', 'Cong Ty Bnju', 'Quang Ninh');
insert into NhaCungCap values ('A491', 'Cong Ty Bty', 'Quang Ninh');
insert into NhaCungCap values ('A492', 'Cong Ty kih', 'Quang Ninh');
insert into NhaCungCap values ('A493', 'Cong Ty koi', 'Quang Ninh');
insert into NhaCungCap values ('A494', 'Cong Ty poi', 'Quang Ninh');
insert into NhaCungCap values ('A495', 'Cong Ty tuy', 'Quang Ninh');
insert into NhaCungCap values ('A496', 'Cong Ty njh', 'Quang Ninh');
insert into NhaCungCap values ('A497', 'Cong Ty c', 'Quang Ninh');
insert into NhaCungCap values ('A498', 'Cong Ty vgy', 'Quang Ninh');
insert into NhaCungCap values ('A499', 'Cong Ty ytu', 'Quang Ninh');
insert into NhaCungCap values ('A500', 'Cong Ty mjui', 'Quang Ninh');
insert into NhaCungCap values ('A501', 'Cong Ty XYZ', 'Quang Ninh');

select * from NhaCungCap;
go

CREATE TABLE VatTu
(
MaVatTu int identity (1,1) primary key,
TenVatTu nvarchar(50) not null,
MaNCC char(10) not null,
Soluong int not null,
foreign key (MaNCC) references NhaCungCap(MaNCC)
)
go

insert into VatTu values ( 'Oc vit', 'A1',30);
insert into VatTu values ( 'Oc vit', 'A2',30);
insert into VatTu values ( 'Oc vit', 'A3',30);
insert into VatTu values ( 'Oc vit', 'A4',30);
insert into VatTu values ( 'Oc vit', 'A5',30);
insert into VatTu values ( 'Oc vit', 'A6',30);
insert into VatTu values ( 'Oc vit', 'A7',30);
insert into VatTu values ( 'Oc vit', 'A8',30);
insert into VatTu values ( 'Oc vit', 'A9',30);
insert into VatTu values ( 'Oc vit', 'A10',30);
insert into VatTu values ( 'Oc vit', 'A11',30);
insert into VatTu values ( 'Oc vit', 'A12',30);
insert into VatTu values ( 'Oc vit', 'A13',30);
insert into VatTu values ( 'Oc vit', 'A14',30);
insert into VatTu values ( 'Oc vit', 'A15',30);
insert into VatTu values ( 'Oc vit', 'A16',30);
insert into VatTu values ( 'Oc vit', 'A17',30);
insert into VatTu values ( 'Oc vit', 'A18',30);
insert into VatTu values ( 'Oc vit', 'A19',30);
insert into VatTu values ( 'Oc vit', 'A20',30);
insert into VatTu values ( 'Oc vit', 'A21',30);
insert into VatTu values ( 'Oc vit', 'A22',30);
insert into VatTu values ( 'Oc vit', 'A23',30);
insert into VatTu values ( 'Oc vit', 'A24',40);
insert into VatTu values ( 'Oc vit', 'A25',40);
insert into VatTu values ( 'Oc vit', 'A26',40);
insert into VatTu values ( 'Oc vit', 'A27',40);
insert into VatTu values ( 'Oc vit', 'A28',40);
insert into VatTu values ( 'Oc vit', 'A29',40);
insert into VatTu values ( 'Oc vit', 'A30',40);
insert into VatTu values ( 'Oc vit', 'A31',40);
insert into VatTu values ( 'Oc vit', 'A32',40);
insert into VatTu values ( 'Oc vit', 'A33',40);
insert into VatTu values ( 'Oc vit', 'A34',40);
insert into VatTu values ( 'Oc vit', 'A35',40);
insert into VatTu values ( 'Oc vit', 'A36',40);
insert into VatTu values ( 'Oc vit', 'A37',40);
insert into VatTu values ( 'Oc vit', 'A38',40);
insert into VatTu values ( 'Oc vit', 'A39',40);
insert into VatTu values ( 'Oc vit', 'A40',40);
insert into VatTu values ( 'Oc vit', 'A41',40);
insert into VatTu values ( 'Oc vit', 'A42',40);
insert into VatTu values ( 'Oc vit', 'A43',40);
insert into VatTu values ( 'Oc vit', 'A44',40);
insert into VatTu values ( 'Oc vit', 'A45',40);
insert into VatTu values ( 'Oc vit', 'A46',40);
insert into VatTu values ( 'Oc vit', 'A47',40);
insert into VatTu values ( 'Kim', 'A48',40);
insert into VatTu values ( 'Kim', 'A49',40);
insert into VatTu values ( 'Kim', 'A50',40);
insert into VatTu values ( 'Kim', 'A51',40);
insert into VatTu values ( 'Kim', 'A52',40);
insert into VatTu values ( 'Kim', 'A53',40);
insert into VatTu values ( 'Kim', 'A54',40);
insert into VatTu values ( 'Kim', 'A55',40);
insert into VatTu values ( 'Kim', 'A56',40);
insert into VatTu values ( 'Kim', 'A57',40);
insert into VatTu values ( 'Kim', 'A58',40);
insert into VatTu values ( 'Kim', 'A59',40);
insert into VatTu values ( 'Kim', 'A60',40);
insert into VatTu values ( 'Kim', 'A61',40);
insert into VatTu values ( 'Kim', 'A62',40);
insert into VatTu values ( 'Oc vit', 'A63',40);
insert into VatTu values ( 'Oc vit', 'A64',50);
insert into VatTu values ( 'Oc vit', 'A65',50);
insert into VatTu values ( 'Oc vit', 'A66',50);
insert into VatTu values ( 'Oc vit', 'A67',50);
insert into VatTu values ( 'Oc vit', 'A68',50);
insert into VatTu values ( 'Oc vit', 'A69',50);
insert into VatTu values ( 'Oc vit', 'A70',50);
insert into VatTu values ( 'Oc vit', 'A71',50);
insert into VatTu values ( 'Oc vit', 'A72',50);
insert into VatTu values ( 'Oc vit', 'A73',50);
insert into VatTu values ( 'Oc vit', 'A74',50);
insert into VatTu values ( 'Oc vit', 'A75',50);
insert into VatTu values ( 'Oc vit', 'A76',50);
insert into VatTu values ( 'Oc vit', 'A77',50);
insert into VatTu values ( 'Oc vit', 'A78',50);
insert into VatTu values ( 'Oc vit', 'A79',50);
insert into VatTu values ( 'Oc vit', 'A80',50);
insert into VatTu values ( 'Oc vit', 'A81',50);
insert into VatTu values ( 'Oc vit', 'A82',50);
insert into VatTu values ( 'Oc vit', 'A83',50);
insert into VatTu values ( 'Oc vit', 'A84',50);
insert into VatTu values ( 'Oc vit', 'A85',50);
insert into VatTu values ( 'Oc vit', 'A86',50);
insert into VatTu values ( 'Oc vit', 'A87',50);
insert into VatTu values ( 'Oc vit', 'A88',50);
insert into VatTu values ( 'Oc vit', 'A89',50);
insert into VatTu values ( 'Oc vit', 'A90',50);
insert into VatTu values ( 'Oc vit', 'A91',50);
insert into VatTu values ( 'Oc vit', 'A92',50);
insert into VatTu values ( 'Oc vit', 'A93',50);
insert into VatTu values ( 'Oc vit', 'A94',50);
insert into VatTu values ( 'Oc vit', 'A95',50);
insert into VatTu values ( 'Oc vit', 'A96',50);
insert into VatTu values ( 'Oc vit', 'A97',50);
insert into VatTu values ( 'Oc vit', 'A98',50);
insert into VatTu values ( 'Oc vit', 'A99',50);
insert into VatTu values ( 'Oc vit', 'A100',50);
insert into VatTu values ( 'Co Le', 'A101',60);
insert into VatTu values ( 'Co Le', 'A102',60);
insert into VatTu values ( 'Co Le', 'A103',60);
insert into VatTu values ( 'Co Le', 'A104',60);
insert into VatTu values ( 'Co Le', 'A105',60);
insert into VatTu values ( 'Co Le', 'A106',60);
insert into VatTu values ( 'Co Le', 'A107',60);
insert into VatTu values ( 'Co Le', 'A108',60);
insert into VatTu values ( 'Co Le', 'A109',60);
insert into VatTu values ( 'Co Le', 'A110',60);
insert into VatTu values ( 'Co Le', 'A111',60);
insert into VatTu values ( 'Co Le', 'A112',60);
insert into VatTu values ( 'Co Le', 'A113',60);
insert into VatTu values ( 'Co Le', 'A114',60);
insert into VatTu values ( 'Co Le', 'A115',60);
insert into VatTu values ( 'Co Le', 'A116',60);
insert into VatTu values ( 'Co Le', 'A117',60);
insert into VatTu values ( 'Co Le', 'A118',60);
insert into VatTu values ( 'Co Le', 'A119',60);
insert into VatTu values ( 'Co Le', 'A120',60);
insert into VatTu values ( 'Co Le', 'A121',60);
insert into VatTu values ( 'Co Le', 'A122',60);
insert into VatTu values ( 'Co Le', 'A123',60);
insert into VatTu values ( 'Co Le', 'A124',60);
insert into VatTu values ( 'Co Le', 'A125',60);
insert into VatTu values ( 'Co Le', 'A126',60);
insert into VatTu values ( 'Co Le', 'A127',60);
insert into VatTu values ( 'Co Le', 'A128',60);
insert into VatTu values ( 'Co Le', 'A129',60);
insert into VatTu values ( 'Co Le', 'A130',60);
insert into VatTu values ( 'Co Le', 'A131',60);
insert into VatTu values ( 'Co Le', 'A132',60);
insert into VatTu values ( 'Co Le', 'A133',60);
insert into VatTu values ( 'Co Le', 'A134',60);
insert into VatTu values ( 'Co Le', 'A135',60);
insert into VatTu values ( 'Co Le', 'A136',60);
insert into VatTu values ( 'Co Le', 'A137',60);
insert into VatTu values ( 'Co Le', 'A138',60);
insert into VatTu values ( 'Co Le', 'A139',60);
insert into VatTu values ( 'Co Le', 'A140',60);
insert into VatTu values ( 'Mo Let', 'A141',55);
insert into VatTu values ( 'Mo Let', 'A142',55);
insert into VatTu values ( 'Mo Let', 'A143',55);
insert into VatTu values ( 'Mo Let', 'A144',55);
insert into VatTu values ( 'Mo Let', 'A145',55);
insert into VatTu values ( 'Mo Let', 'A146',55);
insert into VatTu values ( 'Mo Let', 'A147',55);
insert into VatTu values ( 'Mo Let', 'A148',55);
insert into VatTu values ( 'Mo Let', 'A149',55);
insert into VatTu values ( 'Mo Let', 'A150',55);
insert into VatTu values ( 'Mo Let', 'A151',55);
insert into VatTu values ( 'Mo Let', 'A152',55);
insert into VatTu values ( 'Mo Let', 'A153',55);
insert into VatTu values ( 'Mo Let', 'A154',55);
insert into VatTu values ( 'Mo Let', 'A155',55);
insert into VatTu values ( 'Mo Let', 'A156',55);
insert into VatTu values ( 'Mo Let', 'A157',55);
insert into VatTu values ( 'Mo Let', 'A158',55);
insert into VatTu values ( 'Mo Let', 'A158',55);
insert into VatTu values ( 'Mo Let', 'A160',55);
insert into VatTu values ( 'Mo Let', 'A161',55);
insert into VatTu values ( 'Mo Let', 'A162',55);
insert into VatTu values ( 'Mo Let', 'A163',55);
insert into VatTu values ( 'Mo Let', 'A164',55);
insert into VatTu values ( 'Mo Let', 'A165',55);
insert into VatTu values ( 'Mo Let', 'A166',55);
insert into VatTu values ( 'Mo Let', 'A167',55);
insert into VatTu values ( 'Mo Let', 'A168',55);
insert into VatTu values ( 'Mo Let', 'A169',55);
insert into VatTu values ( 'Mo Let', 'A170',55);
insert into VatTu values ( 'Mo Let', 'A171',55);
insert into VatTu values ( 'Mo Let', 'A172',55);
insert into VatTu values ( 'Mo Let', 'A173',55);
insert into VatTu values ( 'Mo Let', 'A174',55);
insert into VatTu values ( 'Mo Let', 'A175',55);
insert into VatTu values ( 'Mo Let', 'A176',55);
insert into VatTu values ( 'Mo Let', 'A177',55);
insert into VatTu values ( 'Mo Let', 'A178',55);
insert into VatTu values ( 'Mo Let', 'A179',55);
insert into VatTu values ( 'Mo Let', 'A180',55);
insert into VatTu values ( 'Mo Let', 'A181',55);
insert into VatTu values ( 'Mo Let', 'A182',55);
insert into VatTu values ( 'Mo Let', 'A183',55);
insert into VatTu values ( 'Mo Let', 'A184',55);
insert into VatTu values ( 'Mo Let', 'A185',55);
insert into VatTu values ( 'Mo Let', 'A186',55);
insert into VatTu values ( 'Mo Let', 'A187',55);
insert into VatTu values ( 'Mo Let', 'A188',55);
insert into VatTu values ( 'Mo Let', 'A189',55);
insert into VatTu values ( 'Mo Let', 'A190',55);
insert into VatTu values ( 'Mo Let', 'A191',55);
insert into VatTu values ( 'Mo Let', 'A192',55);
insert into VatTu values ( 'Mo Let', 'A193',55);
insert into VatTu values ( 'Mo Let', 'A194',55);
insert into VatTu values ( 'Mo Let', 'A195',55);
insert into VatTu values ( 'Mo Let', 'A196',55);
insert into VatTu values ( 'Mo Let', 'A197',55);
insert into VatTu values ( 'Mo Let', 'A198',55);
insert into VatTu values ( 'Mo Let', 'A199',55);
insert into VatTu values ( 'Mo Let', 'A200',55);
insert into VatTu values ( 'Bua', 'A201',65);
insert into VatTu values ( 'Bua', 'A202',65);
insert into VatTu values ( 'Bua', 'A203',65);
insert into VatTu values ( 'Bua', 'A204',65);
insert into VatTu values ( 'Bua', 'A205',65);
insert into VatTu values ( 'Bua', 'A206',65);
insert into VatTu values ( 'Bua', 'A207',65);
insert into VatTu values ( 'Bua', 'A208',65);
insert into VatTu values ( 'Bua', 'A209',65);
insert into VatTu values ( 'Bua', 'A210',65);
insert into VatTu values ( 'Bua', 'A211',65);
insert into VatTu values ( 'Bua', 'A212',65);
insert into VatTu values ( 'Bua', 'A213',65);
insert into VatTu values ( 'Bua', 'A214',65);
insert into VatTu values ( 'Bua', 'A215',65);
insert into VatTu values ( 'Bua', 'A216',65);
insert into VatTu values ( 'Bua', 'A217',65);
insert into VatTu values ( 'Bua', 'A218',65);
insert into VatTu values ( 'Bua', 'A219',65);
insert into VatTu values ( 'Bua', 'A220',65);
insert into VatTu values ( 'Bua', 'A221',65);
insert into VatTu values ( 'Bua', 'A222',65);
insert into VatTu values ( 'Bua', 'A223',65);
insert into VatTu values ( 'Bua', 'A224',65);
insert into VatTu values ( 'Bua', 'A225',65);
insert into VatTu values ( 'Bua', 'A226',65);
insert into VatTu values ( 'Bua', 'A227',65);
insert into VatTu values ( 'Bua', 'A228',65);
insert into VatTu values ( 'Bua', 'A229',65);
insert into VatTu values ( 'Bua', 'A230',65);
insert into VatTu values ( 'Bua', 'A231',65);
insert into VatTu values ( 'Bua', 'A232',65);
insert into VatTu values ( 'Bua', 'A233',65);
insert into VatTu values ( 'Bua', 'A234',65);
insert into VatTu values ( 'Bua', 'A235',65);
insert into VatTu values ( 'Bua', 'A236',65);
insert into VatTu values ( 'Bua', 'A237',65);
insert into VatTu values ( 'Bua', 'A238',65);
insert into VatTu values ( 'Bua', 'A239',65);
insert into VatTu values ( 'Bua', 'A240',65);
insert into VatTu values ( 'Bua', 'A241',65);
insert into VatTu values ( 'Bua', 'A242',65);
insert into VatTu values ( 'Bua', 'A243',65);
insert into VatTu values ( 'Bua', 'A244',65);
insert into VatTu values ( 'Bua', 'A245',65);
insert into VatTu values ( 'Bua', 'A246',65);
insert into VatTu values ( 'Bua', 'A247',65);
insert into VatTu values ( 'Bua', 'A248',65);
insert into VatTu values ( 'Bua', 'A249',65);
insert into VatTu values ( 'Bua', 'A250',65);
insert into VatTu values ( 'Xeng', 'A260',70);
insert into VatTu values ( 'Xeng', 'A261',70);
insert into VatTu values ( 'Xeng', 'A262',70);
insert into VatTu values ( 'Xeng', 'A263',70);
insert into VatTu values ( 'Xeng', 'A264',70);
insert into VatTu values ( 'Xeng', 'A265',70);
insert into VatTu values ( 'Xeng', 'A266',70);
insert into VatTu values ( 'Xeng', 'A267',70);
insert into VatTu values ( 'Xeng', 'A268',70);
insert into VatTu values ( 'Xeng', 'A269',70);
insert into VatTu values ( 'Xeng', 'A270',70);
insert into VatTu values ( 'Xeng', 'A271',70);
insert into VatTu values ( 'Xeng', 'A272',70);
insert into VatTu values ( 'Xeng', 'A273',70);
insert into VatTu values ( 'Xeng', 'A274',70);
insert into VatTu values ( 'Xeng', 'A275',70);
insert into VatTu values ( 'Xeng', 'A276',70);
insert into VatTu values ( 'Xeng', 'A277',70);
insert into VatTu values ( 'Xeng', 'A278',70);
insert into VatTu values ( 'Xeng', 'A279',70);
insert into VatTu values ( 'Xeng', 'A280',70);
insert into VatTu values ( 'Xeng', 'A281',70);
insert into VatTu values ( 'Xeng', 'A282',70);
insert into VatTu values ( 'Xeng', 'A283',70);
insert into VatTu values ( 'Xeng', 'A284',70);
insert into VatTu values ( 'Xeng', 'A285',70);
insert into VatTu values ( 'Xeng', 'A286',70);
insert into VatTu values ( 'Xeng', 'A287',70);
insert into VatTu values ( 'Xeng', 'A288',70);
insert into VatTu values ( 'Xeng', 'A289',70);
insert into VatTu values ( 'Xeng', 'A290',70);
insert into VatTu values ( 'Xeng', 'A291',70);
insert into VatTu values ( 'Xeng', 'A292',70);
insert into VatTu values ( 'Xeng', 'A293',70);
insert into VatTu values ( 'Xeng', 'A294',70);
insert into VatTu values ( 'Xeng', 'A295',70);
insert into VatTu values ( 'Xeng', 'A296',70);
insert into VatTu values ( 'Xeng', 'A297',70);
insert into VatTu values ( 'Xeng', 'A298',70);
insert into VatTu values ( 'Xeng', 'A299',70);
insert into VatTu values ( 'Xeng', 'A300',70);
insert into VatTu values ( 'Ngoi','A301',10);
insert into VatTu values ( 'Ngoi','A302',10);
insert into VatTu values ( 'Ngoi','A303',10);
insert into VatTu values ( 'Ngoi','A304',10);
insert into VatTu values ( 'Ngoi','A305',10);
insert into VatTu values ( 'Ngoi','A306',10);
insert into VatTu values ( 'Ngoi','A307',10);
insert into VatTu values ( 'Ngoi','A308',10);
insert into VatTu values ( 'Ngoi','A309',10);
insert into VatTu values ( 'Ngoi','A310',10);
insert into VatTu values ( 'Ngoi','A311',10);
insert into VatTu values ( 'Ngoi','A312',10);
insert into VatTu values ( 'Ngoi','A313',10);
insert into VatTu values ( 'Ngoi','A314',10);
insert into VatTu values ( 'Ngoi','A315',10);
insert into VatTu values ( 'Ngoi','A316',10);
insert into VatTu values ( 'Ngoi','A317',10);
insert into VatTu values ( 'Ngoi','A318',10);
insert into VatTu values ( 'Ngoi','A319',10);
insert into VatTu values ( 'Ngoi','A320',10);
insert into VatTu values ( 'Ngoi','A321',10);
insert into VatTu values ( 'Ngoi','A322',10);
insert into VatTu values ( 'Ngoi','A323',10);
insert into VatTu values ( 'Ngoi','A324',10);
insert into VatTu values ( 'Ngoi','A325',10);
insert into VatTu values ( 'Ngoi','A326',10);
insert into VatTu values ( 'Ngoi','A327',10);
insert into VatTu values ( 'Ngoi','A328',10);
insert into VatTu values ( 'Ngoi','A329',10);
insert into VatTu values ( 'Ngoi','A330',10);
insert into VatTu values ( 'Ngoi','A331',10);
insert into VatTu values ( 'Ngoi','A332',10);
insert into VatTu values ( 'Ngoi','A333',10);
insert into VatTu values ( 'Ngoi','A334',10);
insert into VatTu values ( 'Ngoi','A335',10);
insert into VatTu values ( 'Ngoi','A336',10);
insert into VatTu values ( 'Sat','A337',10);
insert into VatTu values ( 'Sat','A338',10);
insert into VatTu values ( 'Sat','A339',10);
insert into VatTu values ( 'Sat','A340',10);
insert into VatTu values ( 'Sat','A341',10);
insert into VatTu values ( 'Sat','A342',10);
insert into VatTu values ( 'Sat','A343',10);
insert into VatTu values ( 'Sat','A344',10);
insert into VatTu values ( 'Sat','A345',10);
insert into VatTu values ( 'Sat','A346',10);
insert into VatTu values ( 'Sat','A347',10);
insert into VatTu values ( 'Sat','A348',10);
insert into VatTu values ( 'Sat','A349',10);
insert into VatTu values ( 'Sat','A350',10);
insert into VatTu values ( 'Sat','A351',10);
insert into VatTu values ( 'Sat','A352',10);
insert into VatTu values ( 'Sat','A353',10);
insert into VatTu values ( 'Dinh','A354',10);
insert into VatTu values ( 'Dinh','A355',10);
insert into VatTu values ( 'Dinh','A356',10);
insert into VatTu values ( 'Dinh','A357',10);
insert into VatTu values ( 'Dinh','A358',10);
insert into VatTu values ( 'Dinh','A359',10);
insert into VatTu values ( 'Dinh','A360',10);
insert into VatTu values ( 'Dinh','A361',10);
insert into VatTu values ( 'Dinh','A362',10);
insert into VatTu values ( 'Dinh','A363',10);
insert into VatTu values ( 'Dinh','A364',10);
insert into VatTu values ( 'Dinh','A365',10);
insert into VatTu values ( 'Day','A366',10);
insert into VatTu values ( 'Day','A367',10);
insert into VatTu values ( 'Day','A368',10);
insert into VatTu values ( 'Day','A369',10);
insert into VatTu values ( 'Day','A370',10);
insert into VatTu values ( 'Day','A371',10);
insert into VatTu values ( 'Day','A372',10);
insert into VatTu values ( 'Day','A373',10);
insert into VatTu values ( 'Day','A374',10);
insert into VatTu values ( 'Day','A375',10);
insert into VatTu values ( 'Day','A376',10);
insert into VatTu values ( 'Day','A377',10);
insert into VatTu values ( 'Thep','A378',10);
insert into VatTu values ( 'Thep','A379',10);
insert into VatTu values ( 'Thep','A380',10);
insert into VatTu values ( 'Thep','A381',10);
insert into VatTu values ( 'Thep','A382',10);
insert into VatTu values ( 'Thep','A383',10);
insert into VatTu values ( 'Thep','A384',10);
insert into VatTu values ( 'Thep','A385',10);
insert into VatTu values ( 'Thep','A386',10);
insert into VatTu values ( 'Thep','A387',10);
insert into VatTu values ( 'Thep','A388',10);
insert into VatTu values ( 'Thep','A389',10);
insert into VatTu values ( 'Thep','A390',10);
insert into VatTu values ( 'Thep','A391',10);
insert into VatTu values ( 'Thep','A392',10);
insert into VatTu values ( 'Thep','A393',10);
insert into VatTu values ( 'Thep','A394',10);
insert into VatTu values ( 'Thep','A395',10);
insert into VatTu values ( 'Thep','A396',10);
insert into VatTu values ( 'Thep','A396',10);
insert into VatTu values ( 'Xi Mang','A397',10);
insert into VatTu values ( 'Xi Mang','A398',10);
insert into VatTu values ( 'Xi Mang','A399',10);
insert into VatTu values ( 'Xi Mang','A400',10);
insert into VatTu values ( 'Xi Mang','A401',10);
insert into VatTu values ( 'Xi Mang','A402',10);
insert into VatTu values ( 'Xi Mang','A403',10);
insert into VatTu values ( 'Xi Mang','A404',10);
insert into VatTu values ( 'Xi Mang','A405',10);
insert into VatTu values ( 'Xi Mang','A406',10);
insert into VatTu values ( 'Xi Mang','A407',10);
insert into VatTu values ( 'Xi Mang','A408',10);
insert into VatTu values ( 'Xi Mang','A409',10);
insert into VatTu values ( 'Xi Mang','A410',10);
insert into VatTu values ( 'Xi Mang','A411',10);
insert into VatTu values ( 'Xi Mang','A412',10);
insert into VatTu values ( 'Cua','A413',10);
insert into VatTu values ( 'Cua','A414',10);
insert into VatTu values ( 'Cua','A415',10);
insert into VatTu values ( 'Cua','A416',10);
insert into VatTu values ( 'Cua','A417',10);
insert into VatTu values ( 'Cua','A418',10);
insert into VatTu values ( 'Cua','A419',10);
insert into VatTu values ( 'Cua','A420',10);
insert into VatTu values ( 'Cua','A421',10);
insert into VatTu values ( 'Cua','A422',10);
insert into VatTu values ( 'Cua','A423',10);
insert into VatTu values ( 'Cua','A424',10);
insert into VatTu values ( 'Cua','A425',10);
insert into VatTu values ( 'Cua','A426',10);
insert into VatTu values ( 'Gach','A427',10);
insert into VatTu values ( 'Gach','A428',10);
insert into VatTu values ( 'Gach','A429',10);
insert into VatTu values ( 'Gach','A430',10);
insert into VatTu values ( 'Gach','A431',10);
insert into VatTu values ( 'Gach','A432',10);
insert into VatTu values ( 'Gach','A433',10);
insert into VatTu values ( 'Gach','A434',10);
insert into VatTu values ( 'Gach','A435',10);
insert into VatTu values ( 'Gach','A436',10);
insert into VatTu values ( 'Gach','A437',10);
insert into VatTu values ( 'Gach','A438',10);
insert into VatTu values ( 'Gach','A439',10);
insert into VatTu values ( 'Gach','A440',10);
insert into VatTu values ( 'Gach','A441',10);
insert into VatTu values ( 'Gach','A442',10);
insert into VatTu values ( 'Gach','A443',10);
insert into VatTu values ( 'Ngoi','A444',10);
insert into VatTu values ( 'Ngoi','A445',10);
insert into VatTu values ( 'Ngoi','A446',10);
insert into VatTu values ( 'Ngoi','A447',10);
insert into VatTu values ( 'Ngoi','A448',10);
insert into VatTu values ( 'Ngoi','A449',10);
insert into VatTu values ( 'Ngoi','A450',10);
insert into VatTu values ( 'Ngoi','A451',10);
insert into VatTu values ( 'Ngoi','A452',10);
insert into VatTu values ( 'Ngoi','A453',10);
insert into VatTu values ( 'Ngoi','A454',10);
insert into VatTu values ( 'Ngoi','A455',10);
insert into VatTu values ( 'Ngoi','A456',10);
insert into VatTu values ( 'Ngoi','A457',10);
insert into VatTu values ( 'Ngoi','A458',10);
insert into VatTu values ( 'Ngoi','A459',10);
insert into VatTu values ( 'Ngoi','A460',10);
insert into VatTu values ( 'Ngoi','A461',10);
insert into VatTu values ( 'Ngoi','A462',10);
insert into VatTu values ( 'Ngoi','A463',10);
insert into VatTu values ( 'Ngoi','A464',10);
insert into VatTu values ( 'Ngoi','A465',10);
insert into VatTu values ( 'Ngoi','A466',10);
insert into VatTu values ( 'Ngoi','A467',10);
insert into VatTu values ( 'Ngoi','A468',10);
insert into VatTu values ( 'Ngoi','A469',10);
insert into VatTu values ( 'Ngoi','A470',10);
insert into VatTu values ( 'Ngoi','A471',10);
insert into VatTu values ( 'Ngoi','A472',10);
insert into VatTu values ( 'Ngoi','A473',10);
insert into VatTu values ( 'Ngoi','A474',10);
insert into VatTu values ( 'Ngoi','A475',10);
insert into VatTu values ( 'Ngoi','A476',10);
insert into VatTu values ( 'Ngoi','A477',10);
insert into VatTu values ( 'Ngoi','A478',10);
insert into VatTu values ( 'Ngoi','A479',10);
insert into VatTu values ( 'Ngoi','A480',10);
insert into VatTu values ( 'Ngoi','A481',10);
insert into VatTu values ( 'Ngoi','A482',10);
insert into VatTu values ( 'Ngoi','A483',10);
insert into VatTu values ( 'Ngoi','A484',10);
insert into VatTu values ( 'Ngoi','A485',10);
insert into VatTu values ( 'Ngoi','A486',10);
insert into VatTu values ( 'Ngoi','A487',10);
insert into VatTu values ( 'Ngoi','A488',10);
insert into VatTu values ( 'Ngoi','A489',10);
insert into VatTu values ( 'Ngoi','A490',10);
insert into VatTu values ( 'Ngoi','A491',10);
insert into VatTu values ( 'Ngoi','A492',10);
insert into VatTu values ( 'Ngoi','A493',10);
insert into VatTu values ( 'Ngoi','A494',10);
insert into VatTu values ( 'Ngoi','A495',10);
insert into VatTu values ( 'Ngoi','A496',10);
insert into VatTu values ( 'Ngoi','A497',10);
insert into VatTu values ( 'Ngoi','A498',10);
insert into VatTu values ( 'Ngoi','A499',10);
insert into VatTu values ( 'Cat Trang','A500',10);
insert into VatTu values ( 'Cat Trang','A489',10);
insert into VatTu values ( 'Cat Trang','A490',10);
insert into VatTu values ( 'Cat Trang','A491',10);
insert into VatTu values ( 'Cat Trang','A492',10);
insert into VatTu values ( 'Cat Trang','A493',10);
insert into VatTu values ( 'Cat Trang','A494',10);
insert into VatTu values ( 'Cat Den','A495',10);
insert into VatTu values ( 'Cat Den','A496',10);
insert into VatTu values ( 'Cat Den','A497',10);
insert into VatTu values ( 'Cat Den','A498',10);
insert into VatTu values ( 'Cat Den','A499',10);
insert into VatTu values ( 'Cat Den','A500',10);

select * from VatTu;
go
select * from VatTu;
CREATE TABLE DuAn
(
MaDuAn char(50) not null,
TenDuAn nvarchar(50) not null,
DiaChi nvarchar (50) not null,
MaNCC char(10) not null,
foreign key (MaNCC) references NhaCungCap(MaNCC)
)
go

insert into DuAn values ('D1', 'Xay cau', 'Ha Noi', 'A1');
insert into DuAn values ('D2', 'Xay cau', 'Ha Noi', 'A2');
insert into DuAn values ('D3', 'Xay cau', 'Ha Noi', 'A3');
insert into DuAn values ('D4', 'Xay cau', 'Ha Noi', 'A4');
insert into DuAn values ('D5', 'Xay cau', 'Ha Noi', 'A5');
insert into DuAn values ('D6', 'Xay cau', 'Ha Noi', 'A6');
insert into DuAn values ('D7', 'Xay cau', 'Ha Noi', 'A7');
insert into DuAn values ('D8', 'Xay cau', 'Ha Noi', 'A8');
insert into DuAn values ('D9', 'Xay cau', 'Ha Noi', 'A9');
insert into DuAn values ('D10', 'Xay cau', 'Ha Noi', 'A10');
insert into DuAn values ('D11', 'Xay cau', 'Ha Noi', 'A11');
insert into DuAn values ('D12', 'Xay cau', 'Ha Noi', 'A12');
insert into DuAn values ('D13', 'Xay cau', 'Ha Noi', 'A13');
insert into DuAn values ('D14', 'Xay cau', 'Ha Noi', 'A14');
insert into DuAn values ('D15', 'Xay cau', 'Ha Noi', 'A15');
insert into DuAn values ('D16', 'Xay cau', 'Ha Noi', 'A16');
insert into DuAn values ('D17', 'Xay cau', 'Ha Noi', 'A17');
insert into DuAn values ('D18', 'Xay cau', 'Ha Noi', 'A18');
insert into DuAn values ('D19', 'Xay cau', 'Ha Noi', 'A19');
insert into DuAn values ('D20', 'Xay cau', 'Ha Noi', 'A20');
insert into DuAn values ('D21', 'Xay cau', 'Ha Noi', 'A21');
insert into DuAn values ('D22', 'Xay cau', 'Ha Noi', 'A22');
insert into DuAn values ('D23', 'Xay cau', 'Ha Noi', 'A23');
insert into DuAn values ('D24', 'Xay cau', 'Ha Noi', 'A24');
insert into DuAn values ('D25', 'Xay cau', 'Ha Noi', 'A25');
insert into DuAn values ('D26', 'Xay cau', 'Ha Noi', 'A26');
insert into DuAn values ('D27', 'Xay cau', 'Ha Noi', 'A27');
insert into DuAn values ('D28', 'Xay cau', 'Ha Noi', 'A28');
insert into DuAn values ('D29', 'Xay cau', 'Ha Noi', 'A29');
insert into DuAn values ('D30', 'Xay cau', 'Ha Noi', 'A30');
insert into DuAn values ('D31', 'Xay cau', 'Ha Noi', 'A31');
insert into DuAn values ('D32', 'Xay cau', 'Ha Noi', 'A32');
insert into DuAn values ('D33', 'Xay cau', 'Ha Noi', 'A33');
insert into DuAn values ('D34', 'Xay cau', 'Ha Noi', 'A34');
insert into DuAn values ('D35', 'Xay cau', 'Ha Noi', 'A35');
insert into DuAn values ('D36', 'Xay cau', 'Ha Noi', 'A36');
insert into DuAn values ('D37', 'Xay cau', 'Ha Noi', 'A37');
insert into DuAn values ('D38', 'Xay cau', 'Ha Noi', 'A38');
insert into DuAn values ('D39', 'Xay cau', 'Ha Noi', 'A139');
insert into DuAn values ('D40', 'Xay cau', 'Ha Noi', 'A40');
insert into DuAn values ('D41', 'Xay cau', 'Ha Noi', 'A41');
insert into DuAn values ('D42', 'Xay cau', 'Ha Noi', 'A42');
insert into DuAn values ('D43', 'Xay cau', 'Ha Noi', 'A43');
insert into DuAn values ('D44', 'Xay cau', 'Ha Noi', 'A44');
insert into DuAn values ('D45', 'Xay cau', 'Ha Noi', 'A45');
insert into DuAn values ('D46', 'Xay cau', 'Ha Noi', 'A46');
insert into DuAn values ('D47', 'Xay cau', 'Ha Noi', 'A47');
insert into DuAn values ('D48', 'Xay cau', 'Ha Noi', 'A48');
insert into DuAn values ('D49', 'Xay cau', 'Ha Noi', 'A49');
insert into DuAn values ('D50', 'Xay cau', 'Ha Noi', 'A50');
insert into DuAn values ('D51', 'Xay cau', 'Ha Noi', 'A51');
insert into DuAn values ('D52', 'Xay cau', 'Ha Noi', 'A52');
insert into DuAn values ('D53', 'Xay cau', 'Ha Noi', 'A53');
insert into DuAn values ('D54', 'Xay cau', 'Ha Noi', 'A54');
insert into DuAn values ('D55', 'Xay cau', 'Ha Noi', 'A55');
insert into DuAn values ('D56', 'Xay cau', 'Ha Noi', 'A56');
insert into DuAn values ('D57', 'Xay cau', 'Ha Noi', 'A57');
insert into DuAn values ('D58', 'Xay cau', 'Ha Noi', 'A8');
insert into DuAn values ('D59', 'Xay cau', 'Ha Noi', 'A59');
insert into DuAn values ('D60', 'Xay cau', 'Ha Noi', 'A60');
insert into DuAn values ('D61', 'Xay cau', 'Ha Noi', 'A61');
insert into DuAn values ('D62', 'Xay cau', 'Ha Noi', 'A62');
insert into DuAn values ('D63', 'Xay cau', 'Ha Noi', 'A63');
insert into DuAn values ('D64', 'Xay cau', 'Ha Noi', 'A64');
insert into DuAn values ('D65', 'Xay cau', 'Ha Noi', 'A65');
insert into DuAn values ('D66', 'Xay cau', 'Ha Noi', 'A66');
insert into DuAn values ('D67', 'Xay cau', 'Ha Noi', 'A67');
insert into DuAn values ('D68', 'Xay cau', 'Ha Noi', 'A68');
insert into DuAn values ('D69', 'Xay cau', 'Ha Noi', 'A69');
insert into DuAn values ('D70', 'Xay cau', 'Ha Noi', 'A70');
insert into DuAn values ('D71', 'Xay cau', 'Ha Noi', 'A71');
insert into DuAn values ('D72', 'Xay cau', 'Ha Noi', 'A72');
insert into DuAn values ('D73', 'Xay cau', 'Ha Noi', 'A73');
insert into DuAn values ('D74', 'Xay cau', 'Ha Noi', 'A74');
insert into DuAn values ('D75', 'Xay cau', 'Ha Noi', 'A75');
insert into DuAn values ('D76', 'Xay cau', 'Ha Noi', 'A76');
insert into DuAn values ('D77', 'Xay cau', 'Ha Noi', 'A77');
insert into DuAn values ('D78', 'Xay cau', 'Ha Noi', 'A78');
insert into DuAn values ('D79', 'Xay cau', 'Ha Noi', 'A79');
insert into DuAn values ('D80', 'Xay cau', 'Ha Noi', 'A80');
insert into DuAn values ('D81', 'Xay cau', 'Ha Noi', 'A81');
insert into DuAn values ('D82', 'Xay cau', 'Ha Noi', 'A82');
insert into DuAn values ('D83', 'Xay cau', 'Ha Noi', 'A83');
insert into DuAn values ('D84', 'Xay cau', 'Ha Noi', 'A84');
insert into DuAn values ('D85', 'Xay cau', 'Ha Noi', 'A85');
insert into DuAn values ('D86', 'Xay cau', 'Ha Noi', 'A86');
insert into DuAn values ('D87', 'Xay cau', 'Ha Noi', 'A87');
insert into DuAn values ('D88', 'Xay cau', 'Ha Noi', 'A88');
insert into DuAn values ('D89', 'Xay cau', 'Ha Noi', 'A89');
insert into DuAn values ('D90', 'Xay cau', 'Ha Noi', 'A90');
insert into DuAn values ('D91', 'Xay cau', 'Ha Noi', 'A91');
insert into DuAn values ('D92', 'Xay cau', 'Ha Noi', 'A92');
insert into DuAn values ('D93', 'Xay cau', 'Ha Noi', 'A93');
insert into DuAn values ('D94', 'Xay cau', 'Ha Noi', 'A94');
insert into DuAn values ('D95', 'Xay cau', 'Ha Noi', 'A95');
insert into DuAn values ('D96', 'Xay cau', 'Ha Noi', 'A96');
insert into DuAn values ('D97', 'Xay cau', 'Ha Noi', 'A97');
insert into DuAn values ('D98', 'Xay cau', 'Ha Noi', 'A98');
insert into DuAn values ('D99', 'Xay cau', 'Ha Noi', 'A99');
insert into DuAn values ('D100', 'Xay cau', 'Ha Noi', 'A100');
insert into DuAn values ('D101', 'Xay cau', 'Ha Noi', 'A101');
insert into DuAn values ('D102', 'Xay cau', 'Ha Noi', 'A102');
insert into DuAn values ('D103', 'Xay cau', 'Ha Noi', 'A103');
insert into DuAn values ('D104', 'Xay cau', 'Ha Noi', 'A104');
insert into DuAn values ('D105', 'Xay cau', 'Ha Noi', 'A15');
insert into DuAn values ('D106', 'Xay cau', 'Ha Noi', 'A106');
insert into DuAn values ('D107', 'Xay cau', 'Ha Noi', 'A107');
insert into DuAn values ('D108', 'Xay cau', 'Ha Noi', 'A108');
insert into DuAn values ('D109', 'Xay cau', 'Ha Noi', 'A109');
insert into DuAn values ('D110', 'Xay cau', 'Ha Noi', 'A110');
insert into DuAn values ('D111', 'Xay cau', 'Ha Noi', 'A111');
insert into DuAn values ('D112', 'Xay cau', 'Ha Noi', 'A112');
insert into DuAn values ('D113', 'Xay cau', 'Ha Noi', 'A113');
insert into DuAn values ('D114', 'Xay cau', 'Ha Noi', 'A114');
insert into DuAn values ('D115', 'Xay cau', 'Ha Noi', 'A115');
insert into DuAn values ('D116', 'Xay cau', 'Ha Noi', 'A116');
insert into DuAn values ('D117', 'Xay cau', 'Ha Noi', 'A117');
insert into DuAn values ('D118', 'Xay cau', 'Ha Noi', 'A118');
insert into DuAn values ('D119', 'Xay cau', 'Ha Noi', 'A118');
insert into DuAn values ('D120', 'Xay cau', 'Ha Noi', 'A120');
insert into DuAn values ('D121', 'Xay cau', 'Ha Noi', 'A121');
insert into DuAn values ('D122', 'Xay cau', 'Ha Noi', 'A122');
insert into DuAn values ('D123', 'Xay cau', 'Ha Noi', 'A123');
insert into DuAn values ('D124', 'Xay cau', 'Ha Noi', 'A124');
insert into DuAn values ('D125', 'Xay cau', 'Ha Noi', 'A125');
insert into DuAn values ('D126', 'Xay cau', 'Ha Noi', 'A126');
insert into DuAn values ('D127', 'Xay cau', 'Ha Noi', 'A127');
insert into DuAn values ('D128', 'Xay cau', 'Ha Noi', 'A128');
insert into DuAn values ('D129', 'Xay cau', 'Ha Noi', 'A129');
insert into DuAn values ('D130', 'Xay cau', 'Ha Noi', 'A130');
insert into DuAn values ('D131', 'Xay cau', 'Ha Noi', 'A131');
insert into DuAn values ('D132', 'Xay cau', 'Ha Noi', 'A132');
insert into DuAn values ('D133', 'Xay cau', 'Ha Noi', 'A133');
insert into DuAn values ('D134', 'Xay cau', 'Ha Noi', 'A134');
insert into DuAn values ('D135', 'Xay cau', 'Ha Noi', 'A135');
insert into DuAn values ('D136', 'Xay cau', 'Ha Noi', 'A136');
insert into DuAn values ('D137', 'Xay cau', 'Ha Noi', 'A137');
insert into DuAn values ('D138', 'Xay cau', 'Ha Noi', 'A138');
insert into DuAn values ('D139', 'Xay cau', 'Ha Noi', 'A139');
insert into DuAn values ('D140', 'Xay cau', 'Ha Noi', 'A140');
insert into DuAn values ('D141', 'Xay cau', 'Ha Noi', 'A141');
insert into DuAn values ('D142', 'Xay cau', 'Ha Noi', 'A142');
insert into DuAn values ('D143', 'Xay cau', 'Ha Noi', 'A143');
insert into DuAn values ('D144', 'Xay cau', 'Ha Noi', 'A144');
insert into DuAn values ('D145', 'Xay cau', 'Ha Noi', 'A145');
insert into DuAn values ('D146', 'Xay cau', 'Ha Noi', 'A146');
insert into DuAn values ('D147', 'Xay cau', 'Ha Noi', 'A147');
insert into DuAn values ('D148', 'Xay cau', 'Ha Noi', 'A148');
insert into DuAn values ('D149', 'Xay cau', 'Ha Noi', 'A149');
insert into DuAn values ('D150', 'Xay cau', 'Ha Noi', 'A150');
insert into DuAn values ('D156', 'Xay cau', 'Ha Noi', 'A156');
insert into DuAn values ('D157', 'Xay cau', 'Ha Noi', 'A157');
insert into DuAn values ('D158', 'Xay cau', 'Ha Noi', 'A156');
insert into DuAn values ('D159', 'Xay cau', 'Ha Noi', 'A159');
insert into DuAn values ('D160', 'Xay cau', 'Ha Noi', 'A160');
insert into DuAn values ('D161', 'Xay cau', 'Ha Noi', 'A161');
insert into DuAn values ('D162', 'Xay cau', 'Ha Noi', 'A162');
insert into DuAn values ('D163', 'Xay cau', 'Ha Noi', 'A163');
insert into DuAn values ('D156', 'Xay nha', 'Ha Noi', 'A156');
insert into DuAn values ('D164', 'Xay nha', 'Ha Noi', 'A164');
insert into DuAn values ('D165', 'Xay nha', 'Ha Noi', 'A165');
insert into DuAn values ('D166', 'Xay nha', 'Ha Noi', 'A166');
insert into DuAn values ('D167', 'Xay nha', 'Ha Noi', 'A167');
insert into DuAn values ('D168', 'Xay nha', 'Ha Noi', 'A168');
insert into DuAn values ('D169', 'Xay nha', 'Ha Noi', 'A169');
insert into DuAn values ('D170', 'Xay nha', 'Ha Noi', 'A170');
insert into DuAn values ('D171', 'Xay nha', 'Ha Noi', 'A171');
insert into DuAn values ('D172', 'Xay nha', 'Ha Noi', 'A172');
insert into DuAn values ('D173', 'Xay nha', 'Ha Noi', 'A173');
insert into DuAn values ('D174', 'Xay nha', 'Ha Noi', 'A174');
insert into DuAn values ('D175', 'Xay nha', 'Ha Noi', 'A175');
insert into DuAn values ('D176', 'Xay nha', 'Ha Noi', 'A176');
insert into DuAn values ('D177', 'Xay nha', 'Ha Noi', 'A178');
insert into DuAn values ('D179', 'Xay nha', 'Ha Noi', 'A189');
insert into DuAn values ('D180', 'Xay nha', 'Ha Noi', 'A180');
insert into DuAn values ('D181', 'Xay nha', 'Ha Noi', 'A181');
insert into DuAn values ('D182', 'Xay cau', 'Ha Noi', 'A182');
insert into DuAn values ('D183', 'Xay cau', 'Ha Noi', 'A183');
insert into DuAn values ('D184', 'Xay cau', 'Ha Noi', 'A184');
insert into DuAn values ('D185', 'Xay cau', 'Ha Noi', 'A185');
insert into DuAn values ('D186', 'Xay cau', 'Ha Noi', 'A186');
insert into DuAn values ('D187', 'Xay cau', 'Ha Noi', 'A187');
insert into DuAn values ('D188', 'Xay cau', 'Ha Noi', 'A188');
insert into DuAn values ('D189', 'Xay nha', 'Ha Noi', 'A189');
insert into DuAn values ('D190', 'Xay nha', 'Ha Noi', 'A190');
insert into DuAn values ('D191', 'Xay nha', 'Ha Noi', 'A191');
insert into DuAn values ('D192', 'Xay nha', 'Ha Noi', 'A192');
insert into DuAn values ('D193', 'Xay nha', 'Ha Noi', 'A193');
insert into DuAn values ('D194', 'Xay nha', 'Ha Noi', 'A194');
insert into DuAn values ('D195', 'Xay nha', 'Ha Noi', 'A195');
insert into DuAn values ('D196', 'Xay nha', 'Ha Noi', 'A196');
insert into DuAn values ('D197', 'Xay cau', 'Ha Noi', 'A197');
insert into DuAn values ('D198', 'Xay cau', 'Ha Noi', 'A198');
insert into DuAn values ('D199', 'Xay cau', 'Ha Noi', 'A199');
insert into DuAn values ('D200', 'Xay cau', 'Ha Noi', 'A200');
insert into DuAn values ('D201', 'Xay cau', 'Ha Noi', 'A201');
insert into DuAn values ('D202', 'Xay duong', 'Ha Noi', 'A202');
insert into DuAn values ('D203', 'Xay duong', 'Ha Noi', 'A203');
insert into DuAn values ('D204', 'Xay duong', 'Ha Noi', 'A204');
insert into DuAn values ('D205', 'Xay duong', 'Ha Noi', 'A205');
insert into DuAn values ('D206', 'Xay duong', 'Ha Noi', 'A206');
insert into DuAn values ('D207', 'Xay duong', 'Ha Noi', 'A207');
insert into DuAn values ('D208', 'Xay duong', 'Ha Noi', 'A208');
insert into DuAn values ('D209', 'Xay duong', 'Ha Noi', 'A209');
insert into DuAn values ('D210', 'Xay duong', 'Ha Noi', 'A210');
insert into DuAn values ('D211', 'Xay duong', 'Ha Noi', 'A211');
insert into DuAn values ('D212', 'Xay duong', 'Ha Noi', 'A212');
insert into DuAn values ('D213', 'Xay duong', 'Ha Noi', 'A213');
insert into DuAn values ('D214', 'Xay duong', 'Ha Noi', 'A214');
insert into DuAn values ('D215', 'Xay duong', 'Ha Noi', 'A215');
insert into DuAn values ('D216', 'Xay duong', 'Ha Noi', 'A216');
insert into DuAn values ('D217', 'Xay duong', 'Ha Noi', 'A217');
insert into DuAn values ('D218', 'Xay duong', 'Ha Noi', 'A218');
insert into DuAn values ('D219', 'Xay duong', 'Ha Noi', 'A219');
insert into DuAn values ('D220', 'Xay duong', 'Ha Noi', 'A220');
insert into DuAn values ('D221', 'Xay duong', 'Ha Noi', 'A221');
insert into DuAn values ('D222', 'Xay duong', 'Ha Noi', 'A222');
insert into DuAn values ('D223', 'Xay cau', 'Ha Noi', 'A223');
insert into DuAn values ('D224', 'Xay cau', 'Ha Noi', 'A224');
insert into DuAn values ('D225', 'Xay cau', 'Ha Noi', 'A225');
insert into DuAn values ('D226', 'Xay cau', 'Ha Noi', 'A226');
insert into DuAn values ('D227', 'Xay cau', 'Ha Noi', 'A227');
insert into DuAn values ('D228', 'Xay cau', 'Ha Noi', 'A228');
insert into DuAn values ('D229', 'Xay cau', 'Ha Noi', 'A229');
insert into DuAn values ('D230', 'Xay cau', 'Ha Noi', 'A230');
insert into DuAn values ('D231', 'Xay cau', 'Ha Noi', 'A231');
insert into DuAn values ('D232', 'Xay cau', 'Ha Noi', 'A232');
insert into DuAn values ('D233', 'Xay cau', 'Ha Noi', 'A233');
insert into DuAn values ('D234', 'Xay cau', 'Ha Noi', 'A234');
insert into DuAn values ('D235', 'Xay duong', 'Ha Noi', 'A235');
insert into DuAn values ('D236', 'Xay duong', 'Ha Noi', 'A236');
insert into DuAn values ('D237', 'Xay duong', 'Ha Noi', 'A237');
insert into DuAn values ('D238', 'Xay duong', 'Ha Noi', 'A238');
insert into DuAn values ('D239', 'Xay duong', 'Ha Noi', 'A239');
insert into DuAn values ('D240', 'Xay duong', 'Ha Noi', 'A240');
insert into DuAn values ('D241', 'Xay duong', 'Ha Noi', 'A241');
insert into DuAn values ('D242', 'Xay duong', 'Ha Noi', 'A242');
insert into DuAn values ('D243', 'Xay duong', 'Ha Noi', 'A243');
insert into DuAn values ('D244', 'Xay duong', 'Ha Noi', 'A244');
insert into DuAn values ('D245', 'Xay cau', 'Ha Noi', 'A245');
insert into DuAn values ('D246', 'Xay cau', 'Ha Noi', 'A246');
insert into DuAn values ('D247', 'Xay cau', 'Ha Noi', 'A247');
insert into DuAn values ('D248', 'Xay cau', 'Ha Noi', 'A248');
insert into DuAn values ('D249', 'Xay cau', 'Ha Noi', 'A249');
insert into DuAn values ('D250', 'Xay cau', 'Ha Noi', 'A250');
insert into DuAn values ('D251', 'Xay cau', 'Ha Noi', 'A251');
insert into DuAn values ('D252', 'Xay cau', 'Ha Noi', 'A252');
insert into DuAn values ('D253', 'Xay cau', 'Ha Noi', 'A253');
insert into DuAn values ('D254', 'Xay ham', 'Ha Noi', 'A254');
insert into DuAn values ('D255', 'Xay ham', 'Ha Noi', 'A255');
insert into DuAn values ('D256', 'Xay ham', 'Ha Noi', 'A256');
insert into DuAn values ('D257', 'Xay ham', 'Ha Noi', 'A257');
insert into DuAn values ('D258', 'Xay ham', 'Ha Noi', 'A258');
insert into DuAn values ('D259', 'Xay ham', 'Ha Noi', 'A259');
insert into DuAn values ('D260', 'Xay ham', 'Ha Noi', 'A260');
insert into DuAn values ('D261', 'Xay ham', 'Ha Noi', 'A261');
insert into DuAn values ('D262', 'Xay ham', 'Ha Noi', 'A262');
insert into DuAn values ('D263', 'Xay ham', 'Ha Noi', 'A263');
insert into DuAn values ('D264', 'Xay ham', 'Ha Noi', 'A264');
insert into DuAn values ('D265', 'Xay cau', 'Ha Noi', 'A265');
insert into DuAn values ('D266', 'Xay cau', 'Ha Noi', 'A266');
insert into DuAn values ('D267', 'Xay cau', 'Ha Noi', 'A267');
insert into DuAn values ('D268', 'Xay cau', 'Ha Noi', 'A268');
insert into DuAn values ('D269', 'Xay cau', 'Ha Noi', 'A269');
insert into DuAn values ('D270', 'Xay cau', 'Ha Noi', 'A270');
insert into DuAn values ('D271', 'Xay cau', 'Ha Noi', 'A271');
insert into DuAn values ('D272', 'Xay ham', 'Ha Noi', 'A272');
insert into DuAn values ('D273', 'Xay ham', 'Ha Noi', 'A273');
insert into DuAn values ('D274', 'Xay ham', 'Ha Noi', 'A275');
insert into DuAn values ('D275', 'Xay ham', 'Ha Noi', 'A276');
insert into DuAn values ('D276', 'Xay ham', 'Ha Noi', 'A277');
insert into DuAn values ('D277', 'Xay ham', 'Ha Noi', 'A278');
insert into DuAn values ('D278', 'Xay ham', 'Ha Noi', 'A279');
insert into DuAn values ('D279', 'Xay ham', 'Ha Noi', 'A280');
insert into DuAn values ('D280', 'Xay ham', 'Ha Noi', 'A281');
insert into DuAn values ('D281', 'Xay ham', 'Ha Noi', 'A282');
insert into DuAn values ('D282', 'Xay ham', 'Ha Noi', 'A283');
insert into DuAn values ('D283', 'Xay ham', 'Ha Noi', 'A283');
insert into DuAn values ('D284', 'Xay ham', 'Ha Noi', 'A284');
insert into DuAn values ('D285', 'Xay ham', 'Ha Noi', 'A285');
insert into DuAn values ('D286', 'Xay ham', 'Ha Noi', 'A286');
insert into DuAn values ('D287', 'Xay ham', 'Ha Noi', 'A287');
insert into DuAn values ('D288', 'Xay ham', 'Ha Noi', 'A288');
insert into DuAn values ('D289', 'Xay ham', 'Ha Noi', 'A289');
insert into DuAn values ('D290', 'Xay ham', 'Ha Noi', 'A290');
insert into DuAn values ('D291', 'Xay ham', 'Ha Noi', 'A291');
insert into DuAn values ('D292', 'Xay ham', 'Ha Noi', 'A292');
insert into DuAn values ('D293', 'Xay ham', 'Ha Noi', 'A293');
insert into DuAn values ('D294', 'Xay ham', 'Ha Noi', 'A294');
insert into DuAn values ('D295', 'Xay ham', 'Ha Noi', 'A295');
insert into DuAn values ('D296', 'Xay ham', 'Ha Noi', 'A296');
insert into DuAn values ('D297', 'Xay ham', 'Ha Noi', 'A297');
insert into DuAn values ('D298', 'Xay ham', 'Ha Noi', 'A298');
insert into DuAn values ('D299', 'Xay cau', 'Ha Noi', 'A299');
insert into DuAn values ('D300', 'Xay cau', 'Ha Noi', 'A300');
insert into DuAn values ('D301', 'Xay cau', 'Ha Noi', 'A301');
insert into DuAn values ('D302', 'Xay nha', 'Hai Phong', 'A302');
insert into DuAn values ('D303', 'Xay cau cong', 'Quang Ninh', 'A303');
insert into DuAn values ('D304', 'Xay bep', 'Lai Xá', 'A304');
insert into DuAn values ('D305', 'Xay nha kho', 'Ha Noi', 'A305');
insert into DuAn values ('D306', 'Xay tuong', 'Ha Noi', 'A306');
insert into DuAn values ('D307', 'Xay cau noi', 'Yen Bai', 'A307');
insert into DuAn values ('D308', 'Xay cau', 'Ninh Binh', 'A308');
insert into DuAn values ('D309', 'Xay duong san bay', 'Ha Noi', 'A309');
insert into DuAn values ('D310', 'Xay cau hip', 'Van Yen', 'A310');
insert into DuAn values ('D311', 'Xay cau', 'Ha Noi', 'A311');
insert into DuAn values ('D312', 'Xay ngoi', 'Trai Hut', 'A312');
insert into DuAn values ('D313', 'Xay cau', 'Ha Noi', 'A313');
insert into DuAn values ('D314', 'Xay duong cao toc', 'Nghe An', 'A314');
insert into DuAn values ('D315', 'Xay cau tren cao', 'Ha Noi', 'A315');
insert into DuAn values ('D316', 'Xay cau', 'Lao Cai', 'A316');
insert into DuAn values ('D317', 'Xay cau', 'Ha Noi', 'A317');
insert into DuAn values ('D318', 'Xay duong bo', 'Co Phuc', 'A318');
insert into DuAn values ('D319', 'Xay cau', 'Ha Noi', 'A319');
insert into DuAn values ('D320', 'Xay cau', 'Ha Noi', 'A320');
insert into DuAn values ('D321', 'Xay cau', 'Sai Gon', 'A321');
insert into DuAn values ('D322', 'Xay cau', 'Lao Cai', 'A322');
insert into DuAn values ('D323', 'Xay cau', 'Ha Noi', 'A323');
insert into DuAn values ('D324', 'Xay nha', 'Hai Phong', 'A324');
insert into DuAn values ('D325', 'Xay cau cong', 'Quang Ninh', 'A325');
insert into DuAn values ('D326', 'Xay bep', 'Lai Xa', 'A326');
insert into DuAn values ('D327', 'Xay nha kho', 'Ha Noi', 'A327');
insert into DuAn values ('D328', 'Xay tuong', 'Ha Noi', 'A328');
insert into DuAn values ('D329', 'Xay cau', 'Hai Phong', 'A329');
insert into DuAn values ('D330', 'Xay cau', 'Ha Noi', 'A330');
insert into DuAn values ('D331', 'Xay ham di bo', 'Lao Cai', 'A331');
insert into DuAn values ('D332', 'Xay cau sat', 'Ha Noi', 'A332');
insert into DuAn values ('D333', 'Xay cau', 'Ha Noi', 'A333');
insert into DuAn values ('D334', 'Xay ham', 'Ha Noi', 'A334');
insert into DuAn values ('D335', 'Xay cau', 'Son La', 'A335');
insert into DuAn values ('D336', 'Xay cau khi', 'Ha Noi', 'A336');
insert into DuAn values ('D337', 'Xay cau', 'Minh Khai ', 'A337');
insert into DuAn values ('D338', 'Xay cau', 'Ha Noi', 'A338');
insert into DuAn values ('D339', 'Xay duong', 'Ha Noi', 'A339');
insert into DuAn values ('D340', 'Xay cau cong', 'Ha Noi', 'A340');
insert into DuAn values ('D341', 'Xay cau', 'Ha Noi', 'A341');
insert into DuAn values ('D342', 'Xay pha', 'Ha Noi', 'A342');
insert into DuAn values ('D343', 'Xay biet thu', 'Ha Noi', 'A343');
insert into DuAn values ('D344', 'Xay cau', 'Yen Bai', 'A344');
insert into DuAn values ('D345', 'Xay cau', 'Ha Noi', 'A345');
insert into DuAn values ('D346', 'Xay nha', 'Hai Phong', 'A346');
insert into DuAn values ('D347', 'Xay cau cong', 'Quang Ninh', 'A347');
insert into DuAn values ('D348', 'Xay bep', 'Lai Xá', 'A348');
insert into DuAn values ('D349', 'Xay nha kho', 'Ha Noi', 'A349');
insert into DuAn values ('D350', 'Xay tuong', 'Ha Noi', 'A350');
insert into DuAn values ('D351', 'Xay cau', 'Ha Noi', 'A351');
insert into DuAn values ('D352', 'Xay mo', 'Yen Bai', 'A352');
insert into DuAn values ('D353', 'Xay cau', 'Binh Dinh', 'A353');
insert into DuAn values ('D354', 'Xay cau bai chay', 'Quang Ninh', 'A354');
insert into DuAn values ('D355', 'Xay cau', 'Ha Noi', 'A355');
insert into DuAn values ('D356', 'Xay cau', 'Ha Noi', 'A356');
insert into DuAn values ('D357', 'Xay bep ', 'Ha Nam', 'A357');
insert into DuAn values ('D358', 'Xay cau', 'Ha Noi', 'A358');
insert into DuAn values ('D359', 'Xay nha o', 'Ha Noi', 'A359');
insert into DuAn values ('D360', 'Xay cau', 'Ha Noi', 'A360');
insert into DuAn values ('D361', 'Xay Biet Thu', 'Ha Tay', 'A361');
insert into DuAn values ('D362', 'Xay cau', 'Ha Noi', 'A362');
insert into DuAn values ('D363', 'Xay cau', 'Thai Binh', 'A363');
insert into DuAn values ('D364', 'Xay cau', 'Tuyen Quang', 'A364');
insert into DuAn values ('D365', 'Xay cau', 'Thai Nguyen', 'A365');
insert into DuAn values ('D366', 'Xay cau', 'Hung Yen', 'A366');
insert into DuAn values ('D367', 'Xay cau', 'Ha Noi', 'A367');
insert into DuAn values ('D368', 'Xay nha', 'Hai Phong', 'A368');
insert into DuAn values ('D369', 'Xay cau cong', 'Quang Ninh', 'A369');
insert into DuAn values ('D370', 'Xay bep', 'Lai Xá', 'A370');
insert into DuAn values ('D371', 'Xay nha kho', 'Ha Noi', 'A371');
insert into DuAn values ('D372', 'Xay tuong', 'Ha Noi', 'A372');
insert into DuAn values ('D373', 'Xay cau', 'Ha Noi', 'A373');
insert into DuAn values ('D374', 'Xay cau', 'Ha Noi', 'A374');
insert into DuAn values ('D375', 'Xay chua', 'Ha Noi', 'A375');
insert into DuAn values ('D376', 'Xay Vong Xuyen', 'Ha Noi', 'A376');
insert into DuAn values ('D377', 'Xay cau', 'Ha Noi', 'A377');
insert into DuAn values ('D378', 'Xay cau', 'Ha Noi', 'A378');
insert into DuAn values ('D379', 'Xay cau', 'Ha Noi', 'A379');
insert into DuAn values ('D380', 'Xay Rap', 'Ha Nam', 'A380');
insert into DuAn values ('D381', 'Xay cau', 'Bac Giang', 'A381');
insert into DuAn values ('D382', 'Xay cau', 'HaTay', 'A382');
insert into DuAn values ('D383', 'Xay nha', 'Ha Noi', 'A383');
insert into DuAn values ('D384', 'Xay cau', 'Ha Noi', 'A384');
insert into DuAn values ('D385', 'Xay Bep', 'Ha Quang', 'A385');
insert into DuAn values ('D386', 'Xay Xuong', 'Sai Gon', 'A386');
insert into DuAn values ('D387', 'Xay cau', 'Phong Du', 'A387');
insert into DuAn values ('D388', 'Xay cau', 'Yen Binh', 'A388');
insert into DuAn values ('D389', 'Xay ', 'Ha Nam', 'A389');
insert into DuAn values ('D390', 'Xay nha', 'Hai Phong', 'A390');
insert into DuAn values ('D391', 'Xay cau cong', 'Quang Ninh', 'A391');
insert into DuAn values ('D392', 'Xay bep', 'Lai Xá', 'A392');
insert into DuAn values ('D393', 'Xay nha kho', 'Ha Noi', 'A393');
insert into DuAn values ('D394', 'Xay tuong', 'Ha Noi', 'A394');
insert into DuAn values ('D395', 'Xay cau', 'Ha Noi', 'A395');
insert into DuAn values ('D396', 'Xay cau', 'Ha Noi', 'A396');
insert into DuAn values ('D397', 'Xay cau', 'Ha Noi', 'A397');
insert into DuAn values ('D398', 'Xay bep', 'Ha Noi', 'A398');
insert into DuAn values ('D399', 'Xay cau', 'Ha Noi', 'A399');
insert into DuAn values ('D400', 'Xay nha bep', 'Ha Noi', 'A400');
insert into DuAn values ('D401', 'Xay cau', 'Ha Noi', 'A401');
insert into DuAn values ('D402', 'Xay cau', 'Ha Noi', 'A402');
insert into DuAn values ('D403', 'Xay cau', 'Ha Noi', 'A403');
insert into DuAn values ('D404', 'Xay cau', 'Ha Noi', 'A404');
insert into DuAn values ('D405', 'Xay cau', 'Ha Noi', 'A405');
insert into DuAn values ('D406', 'Xay cau', 'Ha Noi', 'A406');
insert into DuAn values ('D407', 'Xay cau', 'Ha Noi', 'A407');
insert into DuAn values ('D408', 'Xay cau', 'Ha Noi', 'A408');
insert into DuAn values ('D409', 'Xay cau', 'Ha Noi', 'A409');
insert into DuAn values ('D410', 'Xay cau', 'Ha Noi', 'A410');
insert into DuAn values ('D411', 'Xay cau', 'Ha Noi', 'A411');
insert into DuAn values ('D412', 'Xay cau', 'Ha Noi', 'A412');
insert into DuAn values ('D413', 'Xay cau', 'Ha Noi', 'A413');
insert into DuAn values ('D414', 'Xay cau', 'Ha Noi', 'A414');
insert into DuAn values ('D415', 'Xay cau', 'Ha Noi', 'A415');
insert into DuAn values ('D416', 'Xay cau', 'Ha Noi', 'A416');
insert into DuAn values ('D417', 'Xay cau', 'Ha Noi', 'A417');
insert into DuAn values ('D418', 'Xay cau', 'Ha Noi', 'A418');
insert into DuAn values ('D419', 'Xay cau', 'Ha Noi', 'A419');
insert into DuAn values ('D420', 'Xay cau', 'Ha Noi', 'A420');
insert into DuAn values ('D421', 'Xay nha', 'Hai Phong', 'A421');
insert into DuAn values ('D422', 'Xay nha', 'Hai Phong', 'A422');
insert into DuAn values ('D423', 'Xay nha', 'Hai Phong', 'A423');
insert into DuAn values ('D424', 'Xay nha', 'Hai Phong', 'A424');
insert into DuAn values ('D425', 'Xay nha', 'Hai Phong', 'A425');
insert into DuAn values ('D426', 'Xay nha', 'Hai Phong', 'A426');
insert into DuAn values ('D427', 'Xay nha', 'Hai Phong', 'A427');
insert into DuAn values ('D428', 'Xay nha', 'Hai Phong', 'A428');
insert into DuAn values ('D429', 'Xay nha', 'Hai Phong', 'A429');
insert into DuAn values ('D430', 'Xay nha', 'Hai Phong', 'A430');
insert into DuAn values ('D431', 'Xay nha', 'Hai Phong', 'A431');
insert into DuAn values ('D432', 'Xay nha', 'Hai Phong', 'A432');
insert into DuAn values ('D433', 'Xay nha', 'Hai Phong', 'A433');
insert into DuAn values ('D434', 'Xay nha', 'Hai Phong', 'A434');
insert into DuAn values ('D435', 'Xay nha', 'Hai Phong', 'A435');
insert into DuAn values ('D436', 'Xay nha', 'Hai Phong', 'A436');
insert into DuAn values ('D437', 'Xay nha', 'Hai Phong', 'A437');
insert into DuAn values ('D438', 'Xay nha', 'Hai Phong', 'A438');
insert into DuAn values ('D439', 'Xay nha', 'Hai Phong', 'A439');
insert into DuAn values ('D440', 'Xay duong', 'Da Nang', 'A440');
insert into DuAn values ('D441', 'Xay duong', 'Da Nang', 'A441');
insert into DuAn values ('D442', 'Xay duong', 'Da Nang', 'A442');
insert into DuAn values ('D443', 'Xay duong', 'Da Nang', 'A443');
insert into DuAn values ('D444', 'Xay duong', 'Da Nang', 'A444');
insert into DuAn values ('D445', 'Xay duong', 'Da Nang', 'A445');
insert into DuAn values ('D446', 'Xay duong', 'Da Nang', 'A446');
insert into DuAn values ('D447', 'Xay duong', 'Da Nang', 'A447');
insert into DuAn values ('D448', 'Xay duong', 'Da Nang', 'A448');
insert into DuAn values ('D449', 'Xay duong', 'Da Nang', 'A449');
insert into DuAn values ('D450', 'Xay duong', 'Da Nang', 'A450');
insert into DuAn values ('D451', 'Xay duong', 'Da Nang', 'A451');
insert into DuAn values ('D452', 'Xay duong', 'Da Nang', 'A452');
insert into DuAn values ('D453', 'Xay duong', 'Da Nang', 'A453');
insert into DuAn values ('D454', 'Xay duong', 'Da Nang', 'A454');
insert into DuAn values ('D455', 'Xay duong', 'Da Nang', 'A455');
insert into DuAn values ('D456', 'Xay duong', 'Da Nang', 'A456');
insert into DuAn values ('D457', 'Xay duong', 'Da Nang', 'A457');
insert into DuAn values ('D458', 'Xay duong', 'Da Nang', 'A458');
insert into DuAn values ('D459', 'Xay duong', 'Da Nang', 'A459');
insert into DuAn values ('D460', 'Xay duong sat ', 'TPHCM', 'A460');
insert into DuAn values ('D461', 'Xay duong sat ', 'TPHCM', 'A461');
insert into DuAn values ('D462', 'Xay duong sat ', 'TPHCM', 'A462');
insert into DuAn values ('D463', 'Xay duong sat ', 'TPHCM', 'A463');
insert into DuAn values ('D464', 'Xay duong sat ', 'TPHCM', 'A464');
insert into DuAn values ('D465', 'Xay duong sat ', 'TPHCM', 'A465');
insert into DuAn values ('D466', 'Xay duong sat ', 'TPHCM', 'A466');
insert into DuAn values ('D467', 'Xay duong sat ', 'TPHCM', 'A467');
insert into DuAn values ('D468', 'Xay duong sat ', 'TPHCM', 'A468');
insert into DuAn values ('D469', 'Xay duong sat ', 'TPHCM', 'A469');
insert into DuAn values ('D470', 'Xay duong sat ', 'TPHCM', 'A470');
insert into DuAn values ('D471', 'Xay duong sat ', 'TPHCM', 'A471');
insert into DuAn values ('D472', 'Xay duong sat ', 'TPHCM', 'A472');
insert into DuAn values ('D473', 'Xay duong sat ', 'TPHCM', 'A473');
insert into DuAn values ('D474', 'Xay duong sat ', 'TPHCM', 'A474');
insert into DuAn values ('D475', 'Xay duong sat ', 'TPHCM', 'A475');
insert into DuAn values ('D476', 'Xay duong sat ', 'TPHCM', 'A476');
insert into DuAn values ('D477', 'Xay duong sat ', 'TPHCM', 'A477');
insert into DuAn values ('D478', 'Xay duong sat ', 'TPHCM', 'A478');
insert into DuAn values ('D479', 'Xay duong sat ', 'TPHCM', 'A479');
insert into DuAn values ('D480', 'Xay duong sat ', 'TPHCM', 'A480');
insert into DuAn values ('D481', 'Sua Cong ', 'Vinh Phuc', 'A481');
insert into DuAn values ('D482', 'Sua Cong ', 'Vinh Phuc', 'A482');
insert into DuAn values ('D483', 'Sua Cong ', 'Vinh Phuc', 'A483');
insert into DuAn values ('D484', 'Sua Cong ', 'Vinh Phuc', 'A484');
insert into DuAn values ('D485', 'Sua Cong ', 'Vinh Phuc', 'A485');
insert into DuAn values ('D486', 'Sua Cong ', 'Vinh Phuc', 'A486');
insert into DuAn values ('D487', 'Sua Cong ', 'Vinh Phuc', 'A487');
insert into DuAn values ('D488', 'Sua Cong ', 'Vinh Phuc', 'A488');
insert into DuAn values ('D489', 'Sua Cong ', 'Vinh Phuc', 'A489');
insert into DuAn values ('D490', 'Sua Cong ', 'Vinh Phuc', 'A490');
insert into DuAn values ('D491', 'Sua Cong ', 'Vinh Phuc', 'A491');
insert into DuAn values ('D492', 'Sua Cong ', 'Vinh Phuc', 'A492');
insert into DuAn values ('D493', 'Sua Cong ', 'Vinh Phuc', 'A493');
insert into DuAn values ('D494', 'Sua Cong ', 'Vinh Phuc', 'A494');
insert into DuAn values ('D495', 'Sua Cong ', 'Vinh Phuc', 'A495');
insert into DuAn values ('D496', 'Sua Cong ', 'Vinh Phuc', 'A496');
insert into DuAn values ('D497', 'Sua Cong ', 'Vinh Phuc', 'A497');
insert into DuAn values ('D498', 'Sua Cong ', 'Vinh Phuc', 'A498');
insert into DuAn values ('D499', 'Sua Cong ', 'Vinh Phuc', 'A499');
insert into DuAn values ('D500', 'Sua Cong ', 'Vinh Phuc', 'A500');
insert into DuAn values ('D4081', 'Sua Cong ', 'Vinh Phuc', 'A489');
insert into DuAn values ('D851', 'Sua Cong ', 'Vinh Phuc', 'A490');
insert into DuAn values ('D470', 'Sua Cong ', 'Vinh Phuc', 'A491');
insert into DuAn values ('D492', 'Sua Cong ', 'Vinh Phuc', 'A492');
insert into DuAn values ('D680', 'Sua Cong ', 'Vinh Phuc', 'A493');
insert into DuAn values ('D914', 'Sua Cong ', 'Vinh Phuc', 'A494');
insert into DuAn values ('D4445', 'Sua Cong ', 'Vinh Phuc', 'A495');
insert into DuAn values ('D3496', 'Sua Cong ', 'Vinh Phuc', 'A496');
insert into DuAn values ('D1497', 'Sua Cong ', 'Vinh Phuc', 'A497');
insert into DuAn values ('D498', 'Sua Cong ', 'Vinh Phuc', 'A498');
insert into DuAn values ('D1499', 'Sua Cong ', 'Vinh Phuc', 'A499');
insert into DuAn values ('D1500', 'Sua Cong ', 'Vinh Phuc', 'A500');

select * from DuAn;

select * from NhaCungCap;

select * from VatTu;

select*from NhaCungCap where Diachi= 'Ha Noi '

select*from NhaCungCap where Diachi= 'Quang Ninh '

select*from NhaCungCap where Diachi= 'Da Lat '

select*from VatTu where TenVatTu= 'Oc Vit '

select*from VatTu where TenVatTu= 'Bua '

select*from VatTu where TenVatTu= 'Xeng '

select*from VatTu where TenVatTu= 'Ngoi '

go

select * from DuAn;
go

/*THEM COT NGAY THANG CHO BANG DU AN*/
alter table DuAn
add Ngay Datetime;
update DuAn set Ngay = '12/03/2010';
select * from DuAn;
go
/*TRIGGER KIEM TRA THEM VAT TU*/
create trigger themvattu on VatTu
for insert
as
if (select soluong from inserted)<=0
begin
print 'So luong vat tu nhap vao phai lon hon 0';
rollback transaction
end;
insert into VatTu values ('Keo','A120',0);
go
/*TRIGGER XEM GIA TRI VUA DUOC INSERT*/
create trigger ktthemvattu on VatTu
for insert
as
begin
select * from inserted;
end;
go

insert into VatTu values ('Can Cau','A470',50);
go
/*TRIGGER KIEM TRA THEM SUA VAT TU*/
create trigger kiemtra_them_sua on VatTu
for UPDATE
as
begin
select * from inserted;
select * from deleted;
end;
go
update VatTu set Soluong = 170;

Nhóm 2

Chủ Nhật, 23 tháng 10, 2016

[BÀI TẬP LỚN] MÔN : HỆ QUẢN TRỊ CSDL

TẠO CSDL QUẢN LÝ VẬT TƯ

DỰ ÁN XÂY DỰNG

Lưu trữ Blog