API tools faq
paste
nht_cntt

QLGV

nht_cntt
Nov 30th, 2015
405
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 16.23 KB | None | 0 0
raw download clone embed print report
  1. CREATE DATABASE QLGV
  2. USE QLGV
  3. SET DATEFORMAT DMY
  4.  
  5. CREATE TABLE HOCVIEN
  6. (
  7.     MAHV CHAR(5) NOT NULL,
  8.     CONSTRAINT PK_MHV PRIMARY KEY (MAHV),
  9.     HO  VARCHAR (40),
  10.     TEN VARCHAR (10),
  11.     NGAYSINH SMALLDATETIME,
  12.     GIOITINH VARCHAR(3),
  13.     NOISINH VARCHAR(40),
  14.     MALOP CHAR(3)
  15. )
  16. CREATE TABLE KHOA
  17. (
  18.     MAKHOA VARCHAR(4) NOT NULL,
  19.     CONSTRAINT PK_MAKHOA PRIMARY KEY (MAKHOA),
  20.     TENKHOA VARCHAR(40),
  21.     NGTLAP SMALLDATETIME,
  22.     TRGKHOA CHAR(4)
  23. )
  24.  
  25. CREATE TABLE MONHOC
  26. (
  27.     MAMH VARCHAR(10) NOT NULL,
  28.     CONSTRAINT PK_MAMH PRIMARY KEY (MAMH),
  29.     TENMH VARCHAR(40),
  30.     TCLT TINYINT,
  31.     TCTH TINYINT,
  32.     MAKHOA VARCHAR(4)
  33. )
  34. CREATE TABLE DIEUKIEN
  35. (
  36.     MAMH VARCHAR(10) NOT NULL,
  37.     MAMH_TRUOC VARCHAR(10) NOT NULL
  38.     CONSTRAINT PK_DK PRIMARY KEY (MAMH, MAMH_TRUOC)
  39. )
  40.  
  41. CREATE TABLE GIAOVIEN
  42. (
  43.     MAGV CHAR(4) NOT NULL,
  44.     CONSTRAINT PK_MAGV PRIMARY KEY (MAGV),
  45.     HOTEN VARCHAR(40),
  46.     HOCVI VARCHAR(10),
  47.     HOCHAM VARCHAR(10),
  48.     GIOITINH VARCHAR(3),
  49.     NGSINH smalldatetime,
  50.     NGVL SMALLDATETIME,
  51.     HESO NUMERIC(4,2),
  52.     MUCLUONG MONEY,
  53.     MAKHOA VARCHAR(4)
  54. )
  55. CREATE TABLE LOP
  56. (
  57.     MALOP CHAR(3) NOT NULL,
  58.     CONSTRAINT PK_MALOP PRIMARY KEY (MALOP),
  59.     TENLOP VARCHAR(40),
  60.     TRGLOP CHAR(5),
  61.     SISO TINYINT,  
  62.     MAGVCN CHAR(4)
  63.    
  64. )
  65. CREATE TABLE GIANGDAY
  66. (
  67.     MALOP CHAR(3) NOT NULL,
  68.     MAMH VARCHAR(10) NOT NULL,
  69.     CONSTRAINT PK_GIANGDAY PRIMARY KEY (MALOP, MAMH),
  70.     MAGV CHAR(4),
  71.     HOCKY TINYINT,
  72.     NAM SMALLINT,
  73.     TUNGAY SMALLDATETIME,
  74.     DENNGAY SMALLDATETIME
  75. )
  76.  
  77. CREATE TABLE KETQUATHI
  78. (
  79.     MAHV CHAR(5) NOT NULL,
  80.     MAMH VARCHAR(10) NOT NULL,
  81.     LANTHI TINYINT NOT NULL,
  82.     CONSTRAINT PK_KQ PRIMARY KEY (MAHV, MAMH, LANTHI),
  83.     NGTHI SMALLDATETIME,   
  84.     DIEM NUMERIC(4,2),
  85.     KQUA VARCHAR(10)
  86. )
  87. ---TAO KHOA NGOAI
  88. ALTER TABLE GIANGDAY ADD
  89. CONSTRAINT FK_GD_LOP FOREIGN KEY (MALOP) REFERENCES LOP (MALOP),
  90. CONSTRAINT FK_GD_GIAOVIEN FOREIGN KEY (MAGV) REFERENCES GIAOVIEN (MAGV),
  91. CONSTRAINT FK_GD_MONHOC FOREIGN KEY (MAMH) REFERENCES MONHOC (MAMH)
  92.  
  93. ALTER TABLE KETQUATHI ADD
  94. CONSTRAINT FK_KQT_MH FOREIGN KEY (MAMH) REFERENCES MONHOC (MAMH),
  95. CONSTRAINT FK_KQT_HV FOREIGN KEY (MAHV) REFERENCES HOCVIEN (MAHV)
  96.  
  97. ALTER TABLE GIAOVIEN ADD
  98. CONSTRAINT FK_GV_MH FOREIGN KEY (MAKHOA) REFERENCES KHOA (MAKHOA)
  99.  
  100. ALTER TABLE HOCVIEN ADD
  101. CONSTRAINT FK_HV_LOP FOREIGN KEY (MALOP) REFERENCES LOP (MALOP)
  102.  
  103. ALTER TABLE MONHOC ADD
  104. CONSTRAINT FK_MH_KHOA FOREIGN KEY (MAKHOA) REFERENCES KHOA (MAKHOA)
  105. /*
  106. ALTER TABLE HOCVIEN
  107. ADD GHICHU VARCHAR(20)
  108. ALTER TABLE HOCVIEN
  109. ADD DTB FLOAT
  110. ALTER TABLE HOCVIEN
  111. ADD XEPLOAI VARCHAR(10)
  112. ALTER TABLE HOCVIEN ADD
  113. CONSTRAINT CHK_GT_HV CHECK (GIOITINH IN('nam','nu'))
  114. ALTER TABLE GIAOVIEN ADD
  115. CONSTRAINT CHK_GT_GV CHECK (GIOITINH IN('nam','nu'))
  116. ALTER TABLE KETQUATHI ADD
  117. CONSTRAINT CHK_DIEM CHECK (DIEM >=0 AND DIEM <=10)
  118. ALTER TABLE KETQUATHI
  119. ALTER COLUMN DIEM NUMERIC(4,2)
  120. ALTER TABLE KETQUATHI ADD
  121. CONSTRAINT CHK_LANTHI CHECK (LANTHI <= 3)
  122. ALTER TABLE GIANGDAY ADD
  123. CONSTRAINT CHK_HK CHECK (HOCKY >= 1 AND HOCKY <= 3)
  124. ALTER TABLE GIAOVIEN ADD
  125. CONSTRAINT CHK_HOCVI_GV CHECK (HOCVI IN('CN','KS','ThS','TS','PTS'))
  126. */
  127.  
  128. /* BT2 - Buoi2 */
  129.  
  130. INSERT INTO KHOA VALUES('KHMT','Khoa hoc may tinh','7/6/2005','GV01')
  131. INSERT INTO KHOA VALUES('HTTT','He thong thong tin','7/6/2005','GV02')
  132. INSERT INTO KHOA VALUES('CNPM','Cong nghe phan mem','7/6/2005','GV04')
  133. INSERT INTO KHOA VALUES('MTT','Mang va truyen thong','20/10/2005','GV03')
  134. INSERT INTO KHOA VALUES('KTMT','Ky thuat may tinh','20/12/2005','Null')
  135.  
  136. INSERT INTO LOP VALUES('K11','Lop 1 khoa 1','K1108',11,'GV07')
  137. INSERT INTO LOP VALUES('K12','Lop 2 khoa 1','K1205',12,'GV09')
  138. INSERT INTO LOP VALUES('K13','Lop 3 khoa 1','K1305',12,'GV14')
  139.  
  140. INSERT INTO MONHOC VALUES('THDC','Tin hoc dai cuong',4,1,'KHMT')
  141. INSERT INTO MONHOC VALUES('CTRR','Cau truc roi rac',5,0,'KHMT')
  142. INSERT INTO MONHOC VALUES('CSDL','Co so du lieu',3,1,'HTTT')
  143. INSERT INTO MONHOC VALUES('CTDLGT','Cau truc du lieu va giai thuat',3,1,'KHMT')
  144. INSERT INTO MONHOC VALUES('PTTKTT','Phan tich thiet ke thuat toan',3,0,'KHMT')
  145. INSERT INTO MONHOC VALUES('DHMT','Do hoa may tinh',3,1,'KHMT')
  146. INSERT INTO MONHOC VALUES('KTMT','Kien truc may tinh',3,0,'KTMT')
  147. INSERT INTO MONHOC VALUES('TKCSDL','Thiet ke co so du lieu',3,1,'HTTT')
  148. INSERT INTO MONHOC VALUES('PTTKHTTT','Phan tich thiet ke he thong thong tin',4,1,'HTTT')
  149. INSERT INTO MONHOC VALUES('HDH','He dieu hanh',4,0,'KTMT')
  150. INSERT INTO MONHOC VALUES('NMCNPM','Nhap mon cong nghe phan mem',3,0,'CNPM')
  151. INSERT INTO MONHOC VALUES('LTCFW','Lap trinh C for win',3,1,'CNPM')
  152. INSERT INTO MONHOC VALUES('LTHDT','Lap trinh huong doi tuong',3,1,'CNPM')
  153.  
  154. INSERT INTO DIEUKIEN VALUES('CSDL','CTRR')
  155. INSERT INTO DIEUKIEN VALUES('CSDL','CTDLGT')
  156. INSERT INTO DIEUKIEN VALUES('CTDLGT','THDC')
  157. INSERT INTO DIEUKIEN VALUES('PTTKTT','THDC')
  158. INSERT INTO DIEUKIEN VALUES('PTTKTT','CTDLGT')
  159. INSERT INTO DIEUKIEN VALUES('DHMT','THDC')
  160. INSERT INTO DIEUKIEN VALUES('LTHDT','THDC')
  161. INSERT INTO DIEUKIEN VALUES('PTTKHTTT','CSDL')
  162.  
  163. INSERT INTO GIANGDAY VALUES('K11', 'THDC', 'GV07', 1, 2006, '2/1/2006', '12/5/2006')
  164. INSERT INTO GIANGDAY VALUES('K12', 'THDC', 'GV06', 1, 2006, '2/1/2006', '12/5/2006')
  165. INSERT INTO GIANGDAY VALUES('K13', 'THDC', 'GV15', 1, 2006, '2/1/2006', '12/5/2006')
  166. INSERT INTO GIANGDAY VALUES('K11', 'CTRR', 'GV02', 1, 2006, '9/1/2006', '17/5/2006')
  167. INSERT INTO GIANGDAY VALUES('K12', 'CTRR', 'GV02', 1, 2006, '9/1/2006', '17/5/2006')
  168. INSERT INTO GIANGDAY VALUES('K13', 'CTRR', 'GV08', 1, 2006, '9/1/2006', '17/5/2006')
  169. INSERT INTO GIANGDAY VALUES('K11', 'CSDL', 'GV05', 2, 2006, '1/6/2006', '15/7/2006')
  170. INSERT INTO GIANGDAY VALUES('K12', 'CSDL', 'GV09', 2, 2006, '1/6/2006', '15/7/2006')
  171. INSERT INTO GIANGDAY VALUES('K13', 'CTDLGT', 'GV15', 2, 2006, '1/6/2006', '15/7/2006')
  172. INSERT INTO GIANGDAY VALUES('K13', 'CSDL', 'GV05', 3, 2006, '1/8/2006', '15/12/2006')
  173. INSERT INTO GIANGDAY VALUES('K13', 'DHMT', 'GV07', 3, 2006, '1/8/2006', '15/12/2006')
  174. INSERT INTO GIANGDAY VALUES('K11', 'CTDLGT', 'GV15', 3, 2006, '1/8/2006', '15/12/2006')
  175. INSERT INTO GIANGDAY VALUES('K12', 'CTDLGT', 'GV15', 3, 2006, '1/8/2006', '15/12/2006')
  176. INSERT INTO GIANGDAY VALUES('K11', 'HDH', 'GV04', 1, 2007, '2/1/2007', '8/2/2007')
  177. INSERT INTO GIANGDAY VALUES('K12', 'HDH', 'GV04', 1, 2007, '2/1/2007', '20/3/2007')
  178. INSERT INTO GIANGDAY VALUES('K11', 'DHMT', 'GV07', 1, 2007, '18/2/2007', '20/3/2007')
  179.  
  180.  
  181. INSERT INTO GIAOVIEN VALUES('GV01', 'Ho Thanh Son', 'PTS', 'GS', 'Nam', '2/5/1950', '11/1/2004', 5, 2250000, 'KHMT')
  182. INSERT INTO GIAOVIEN VALUES('GV02', 'Tran Tam Thanh', 'TS', 'PGS', 'Nam', '17/12/1965', '20/4/2004', 4.5, 2025000, 'HTTT')
  183. INSERT INTO GIAOVIEN VALUES('GV03', 'Do Nghiem Phung', 'TS', 'GS', 'Nu', '1/8/1950', '23/9/2004', 4, 1800000, 'CNPM')
  184. INSERT INTO GIAOVIEN VALUES('GV04', 'Tran Nam Son', 'TS', 'PGS', 'Nam', '22/2/1961', '12/1/2005', 4.5, 2025000, 'KTMT')
  185. INSERT INTO GIAOVIEN VALUES('GV05', 'Mai Thanh Danh', 'ThS', 'GV', 'Nam', '12/3/1958', '12/1/2005', 3, 1350000, 'HTTT')
  186. INSERT INTO GIAOVIEN VALUES('GV06', 'Tran Doan Hung', 'TS', 'GV', 'Nam', '11/3/1953', '12/1/2005', 4.5, 2025000, 'KHMT')
  187. INSERT INTO GIAOVIEN VALUES('GV07', 'Nguyen Minh Tien', 'ThS', 'GV', 'Nam', '23/11/1971', '1/3/2005', 4, 1800000, 'KHMT')
  188. INSERT INTO GIAOVIEN VALUES('GV08', 'Le Thi Tran', 'KS', 'Null', 'Nu', '26/3/1974', '1/3/2005', 1.69, 760500, 'KHMT')
  189. INSERT INTO GIAOVIEN VALUES('GV09', 'Nguyen To Lan', 'ThS', 'GV', 'Nu', '31/12/1966', '1/3/2005', 4, 1800000, 'HTTT')
  190. INSERT INTO GIAOVIEN VALUES('GV10', 'Le Tran Anh Loan', 'KS', 'Null', 'Nu', '17/7/1972', '1/3/2005', 1.86, 837000, 'CNPM')
  191. INSERT INTO GIAOVIEN VALUES('GV11', 'Ho Thanh Tung', 'CN', 'GV', 'Nam', '12/1/1980', '15/5/2005', 2.67, 1201500, 'MTT')
  192. INSERT INTO GIAOVIEN VALUES('GV12', 'Tran Van Anh', 'CN', 'Null', 'Nu', '29/3/1981', '15/5/2005', 1.69, 760500, 'CNPM')
  193. INSERT INTO GIAOVIEN VALUES('GV13', 'Nguyen Linh Dan', 'CN', 'Null', 'Nu', '23/5/1980', '15/5/2005', 1.69, 760500, 'KTMT')
  194. INSERT INTO GIAOVIEN VALUES('GV14', 'Truong Minh Chau', 'ThS', 'GV', 'Nu', '30/11/1976', '15/5/2005', 3, 1350000, 'MTT')
  195. INSERT INTO GIAOVIEN VALUES('GV15', 'Le Ha Thanh', 'ThS', 'GV', 'Nam', '4/5/1978', '15/5/2005', 3, 1350000, 'KHMT')
  196.  
  197. INSERT INTO KETQUATHI VALUES ('K1101', 'CSDL', 1, '20/7/2006', 10.00, 'Dat')
  198. INSERT INTO KETQUATHI VALUES ('K1101', 'CTDLGT', 1, '28/12/2006', 9.00, 'Dat')
  199. INSERT INTO KETQUATHI VALUES ('K1101', 'THDC', 1, '20/5/2006', 9.00, 'Dat')
  200. INSERT INTO KETQUATHI VALUES ('K1101', 'CTRR', 1, '13/5/2006', 9.50, 'Dat')
  201. INSERT INTO KETQUATHI VALUES ('K1102', 'CSDL', 1, '20/7/2006', 4.00, 'Khong Dat')
  202. INSERT INTO KETQUATHI VALUES ('K1102', 'CSDL', 2, '27/7/2006', 4.25, 'Khong Dat')
  203. INSERT INTO KETQUATHI VALUES ('K1102', 'CSDL', 3, '10/8/2006', 4.50, 'Khong Dat')
  204. INSERT INTO KETQUATHI VALUES ('K1102', 'CTDLGT', 1, '28/12/2006', 4.50, 'Khong Dat')
  205. INSERT INTO KETQUATHI VALUES ('K1102', 'CTDLGT', 2, '5/1/2007', 4.00, 'Khong Dat')
  206. INSERT INTO KETQUATHI VALUES ('K1102', 'CTDLGT', 3, '15/1/2007', 6.00, 'Dat')
  207. INSERT INTO KETQUATHI VALUES ('K1102', 'THDC', 1, '20/5/2006', 5.00, 'Dat')
  208. INSERT INTO KETQUATHI VALUES ('K1102', 'CTRR', 1, '13/5/2006', 7.00, 'Dat')
  209. INSERT INTO KETQUATHI VALUES ('K1103', 'CSDL', 1, '20/7/2006', 3.50, 'Khong Dat')
  210. INSERT INTO KETQUATHI VALUES ('K1103', 'CSDL', 2, '27/7/2006', 8.25, 'Dat')
  211. INSERT INTO KETQUATHI VALUES ('K1103', 'CTDLGT', 1, '28/12/2006', 7.00, 'Dat')
  212. INSERT INTO KETQUATHI VALUES ('K1103', 'THDC', 1, '20/5/2006', 8.00, 'Dat')
  213. INSERT INTO KETQUATHI VALUES ('K1103', 'CTRR', 1, '13/5/2006', 6.50, 'Dat')
  214. INSERT INTO KETQUATHI VALUES ('K1104', 'CSDL', 1, '20/7/2006', 3.75, 'Khong Dat')
  215. INSERT INTO KETQUATHI VALUES ('K1104', 'CTDLGT', 1, '28/12/2006', 4.00, 'Khong Dat')
  216. INSERT INTO KETQUATHI VALUES ('K1104', 'THDC', 1, '20/5/2006', 4.00, 'Khong Dat')
  217. INSERT INTO KETQUATHI VALUES ('K1104', 'CTRR', 1, '13/5/2006', 4.00, 'Khong Dat')
  218. INSERT INTO KETQUATHI VALUES ('K1104', 'CTRR', 2, '20/5/2006', 3.50, 'Khong Dat')
  219. INSERT INTO KETQUATHI VALUES ('K1104', 'CTRR', 3, '30/6/2006', 4.00, 'Khong Dat')
  220. INSERT INTO KETQUATHI VALUES ('K1201', 'CSDL', 1, '20/7/2006', 6.00, 'Dat')
  221. INSERT INTO KETQUATHI VALUES ('K1201', 'CTDLGT', 1, '28/12/2006', 5.00, 'Dat')
  222. INSERT INTO KETQUATHI VALUES ('K1201', 'THDC', 1, '20/5/2006', 8.50, 'Dat')
  223. INSERT INTO KETQUATHI VALUES ('K1201', 'CTRR', 1, '13/5/2006', 9.00, 'Dat')
  224. INSERT INTO KETQUATHI VALUES ('K1202', 'CSDL', 1, '20/7/2006', 8.00, 'Dat')
  225. INSERT INTO KETQUATHI VALUES ('K1202', 'CTDLGT', 1, '28/12/2006', 4.00, 'Khong Dat')
  226. INSERT INTO KETQUATHI VALUES ('K1202', 'CTDLGT', 2, '5/1/2007', 5.00, 'Dat')
  227. INSERT INTO KETQUATHI VALUES ('K1202', 'THDC', 1, '20/5/2006', 4.00, 'Khong Dat')
  228. INSERT INTO KETQUATHI VALUES ('K1202', 'THDC', 2, '27/5/2006', 4.00, 'Khong Dat')
  229. INSERT INTO KETQUATHI VALUES ('K1202', 'CTRR', 1, '13/5/2006', 3.00, 'Khong Dat')
  230.  
  231. INSERT INTO KETQUATHI VALUES ('K1202', 'CTRR', 2, '20/5/2006', 4.00, 'Khong Dat')
  232. INSERT INTO KETQUATHI VALUES ('K1202', 'CTRR', 3, '30/6/2006', 6.25, 'Dat')
  233. INSERT INTO KETQUATHI VALUES ('K1203', 'CSDL', 1, '20/7/2006', 9.25, 'Dat')
  234. INSERT INTO KETQUATHI VALUES ('K1203', 'CTDLGT', 1, '28/12/2006', 9.50, 'Dat')
  235. INSERT INTO KETQUATHI VALUES ('K1203', 'THDC', 1, '20/5/2006', 10.00, 'Dat')
  236. INSERT INTO KETQUATHI VALUES ('K1203', 'CTRR', 1, '13/5/2006', 10.00, 'Dat')
  237. INSERT INTO KETQUATHI VALUES ('K1204', 'CSDL', 1, '20/7/2006', 8.50, 'Dat')
  238. INSERT INTO KETQUATHI VALUES ('K1204', 'CTDLGT', 1, '28/12/2006', 6.75, 'Dat')
  239. INSERT INTO KETQUATHI VALUES ('K1204', 'THDC', 1, '20/5/2006', 4.00, 'Khong Dat')
  240. INSERT INTO KETQUATHI VALUES ('K1204', 'CTRR', 1, '13/5/2006', 6.00, 'Dat')
  241. INSERT INTO KETQUATHI VALUES ('K1301', 'CSDL', 1, '20/12/2006', 4.25, 'Khong Dat')
  242. INSERT INTO KETQUATHI VALUES ('K1301', 'CTDLGT', 1, '25/7/2006', 8.00, 'Dat')
  243. INSERT INTO KETQUATHI VALUES ('K1301', 'THDC', 1, '20/5/2006', 7.75, 'Dat')
  244. INSERT INTO KETQUATHI VALUES ('K1301', 'CTRR', 1, '13/5/2006', 8.00, 'Dat')
  245. INSERT INTO KETQUATHI VALUES ('K1302', 'CSDL', 1, '20/12/2006', 6.75, 'Dat')
  246. INSERT INTO KETQUATHI VALUES ('K1302', 'CTDLGT', 1, '25/7/2006', 5.00, 'Dat')
  247. INSERT INTO KETQUATHI VALUES ('K1302', 'THDC', 1, '20/5/2006', 8.00, 'Dat')
  248. INSERT INTO KETQUATHI VALUES ('K1302', 'CTRR', 1, '13/5/2006', 8.50, 'Dat')
  249. INSERT INTO KETQUATHI VALUES ('K1303', 'CSDL', 1, '20/12/2006', 4.00, 'Khong Dat')
  250. INSERT INTO KETQUATHI VALUES ('K1303', 'CTDLGT', 1, '25/7/2006', 4.50, 'Khong Dat')
  251. INSERT INTO KETQUATHI VALUES ('K1303', 'CTDLGT', 2, '7/8/2006', 4.00, 'Khong Dat')
  252. INSERT INTO KETQUATHI VALUES ('K1303', 'CTDLGT', 3, '15/8/2006', 4.25, 'Khong Dat')
  253. INSERT INTO KETQUATHI VALUES ('K1303', 'THDC', 1, '20/5/2006', 4.50, 'Khong Dat')
  254. INSERT INTO KETQUATHI VALUES ('K1303', 'CTRR', 1, '13/5/2006', 3.25, 'Khong Dat')
  255. INSERT INTO KETQUATHI VALUES ('K1303', 'CTRR', 2, '20/5/2006', 5.00, 'Dat')
  256. INSERT INTO KETQUATHI VALUES ('K1304', 'CSDL', 1, '20/12/2006', 7.75, 'Dat')
  257. INSERT INTO KETQUATHI VALUES ('K1304', 'CTDLGT', 1, '25/7/2006', 9.75, 'Dat')
  258. INSERT INTO KETQUATHI VALUES ('K1304', 'THDC', 1, '20/5/2006', 5.50, 'Dat')
  259. INSERT INTO KETQUATHI VALUES ('K1304', 'CTRR', 1, '13/5/2006', 5.00, 'Dat')
  260. INSERT INTO KETQUATHI VALUES ('K1305', 'CSDL', 1, '20/12/2006', 9.25, 'Dat')
  261. INSERT INTO KETQUATHI VALUES ('K1305', 'CTDLGT', 1, '25/7/2006', 10.00, 'Dat')
  262. INSERT INTO KETQUATHI VALUES ('K1305', 'THDC', 1, '20/5/2006', 8.00, 'Dat')
  263. INSERT INTO KETQUATHI VALUES ('K1305', 'CTRR', 1, '13/5/2006', 10.00, 'Dat')
  264.  
  265.  
  266.  
  267.  
  268. INSERT INTO HOCVIEN VALUES ('K1101','Nguyen Van','A','27/1/1986','Nam','TpHCM','K11')
  269. INSERT INTO HOCVIEN VALUES ('K1102','Tran Ngoc','Han','14/3/1986','Nu','Kien Giang','K11')
  270. INSERT INTO HOCVIEN VALUES ('K1103','Ha Duy','Lap', '18/4/1986','Nam','Nghe An','K11')
  271. INSERT INTO HOCVIEN VALUES ('K1104','Tran Ngoc','Linh','30/3/1986','Nu','Tay Ninh','K11')
  272. INSERT INTO HOCVIEN VALUES ('K1105','Tran Minh','Long','27/2/1986','Nam','TpHCM','K11')
  273. INSERT INTO HOCVIEN VALUES ('K1106','Le Nhat','Minh','24/1/1986','Nam','TpHCM','K11')
  274. INSERT INTO HOCVIEN VALUES ('K1107','Nguyen Nhu','Nhut','27/1/1986','Nam','Ha Noi','K11')
  275. INSERT INTO HOCVIEN VALUES ('K1108','Nguyen Manh','Tam','27/2/1986','Nam','Kien Giang','K11')
  276. INSERT INTO HOCVIEN VALUES ('K1109','Phan Thi Thanh','Tam','27/1/1986','Nu','Vinh Long','K11')
  277. INSERT INTO HOCVIEN VALUES ('K1110','Le Hoai','Thuong','5/2/1986','Nu','Can Tho','K11')
  278. INSERT INTO HOCVIEN VALUES ('K1111','Le Ha','Vinh','25/12/1986','Nam','Vinh Long','K11')
  279. INSERT INTO HOCVIEN VALUES ('K1201','Nguyen Van','B','11/2/1986','Nam','TpHCM','K12')
  280. INSERT INTO HOCVIEN VALUES ('K1202','Nguyen Thi Kim','Duyen','18/1/1986','Nu','TpHCM','K12')
  281. INSERT INTO HOCVIEN VALUES ('K1203','Tran Thi Kim','Duyen','17/9/1986','Nu','TpHCM','K12')
  282. INSERT INTO HOCVIEN VALUES ('K1204','Truong My','Hanh','19/5/1986','Nu','Dong Nai','K12')
  283. INSERT INTO HOCVIEN VALUES ('K1205','Nguyen Thanh','Nam','17/4/1986','Nam','TpHCM','K12')
  284. INSERT INTO HOCVIEN VALUES ('K1206','Nguyen Thi Truc','Thanh','4/3/1986','Nu','Kien Giang','K12')
  285. INSERT INTO HOCVIEN VALUES ('K1207','Tran Thi Bich','Thuy','8/2/1986','Nu','Nghe An','K12')
  286. INSERT INTO HOCVIEN VALUES ('K1208','Huynh Thi Kim','Trieu','8/4/1986','Nu','Tay Ninh','K12')
  287. INSERT INTO HOCVIEN VALUES ('K1209','Pham Thanh','Trieu','23/2/1986','Nam','TpHCM','K12')
  288. INSERT INTO HOCVIEN VALUES ('K1210','Ngo Thanh','Tuan','14/2/1986','Nam','TpHCM','K12')
  289. INSERT INTO HOCVIEN VALUES ('K1211','Do Thi','Xuan','9/3/1986','Nu','Ha Noi','K12')
  290. INSERT INTO HOCVIEN VALUES ('K1212','Le Thi Phi','Yen','12/3/1986','Nu','TpHCM','K12')
  291. INSERT INTO HOCVIEN VALUES ('K1301','Nguyen Thi Kim','Cuc','9/6/1986','Nu','Kien Giang','K13')
  292. INSERT INTO HOCVIEN VALUES ('K1302','Truong Thi My','Hien','18/3/1986','Nu','Nghe An','K13')
  293. INSERT INTO HOCVIEN VALUES ('K1303','Le Duc','Hien','21/3/1986','Nam','Tay Ninh','K13')
  294. INSERT INTO HOCVIEN VALUES ('K1304','Le Quang','Hien','18/4/1986','Nam','TpHCM','K13')
  295. INSERT INTO HOCVIEN VALUES ('K1305','Le Thi','Huong','27/3/1986','Nu','TpHCM','K13')
  296. INSERT INTO HOCVIEN VALUES ('K1306','Nguyen Thai','Huu','30/3/1986','Nam','Ha Noi','K13')
  297. INSERT INTO HOCVIEN VALUES ('K1307','Tran Minh','Man','28/5/1986','Nam','TpHCM','K13')
  298. INSERT INTO HOCVIEN VALUES ('K1308','Nguyen Hieu','Nghia','8/4/1986','Nam','Kien Giang','K13')
  299. INSERT INTO HOCVIEN VALUES ('K1309','Nguyen Trung','Nghia','18/1/1987','Nam','Nghe An','K13')
  300. INSERT INTO HOCVIEN VALUES ('K1310','Tran Thi Hong','Tham','22/4/1986','Nu','Tay Ninh','K13')
  301. INSERT INTO HOCVIEN VALUES ('K1311','Tran Minh','Thuc','4/4/1986','Nam','TpHCM','K13')
  302. INSERT INTO HOCVIEN VALUES ('K1312','Nguyen Thi Kim','Yen','7/9/1986','Nu','TpHCM','K13')
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!