create database QLGiaoVu go use QLGiaoVu go create table KHOA( MaKH varchar(4) not null primary key, TenKhoa varchar(40) not null, NgTLap smalldatetime, TrgKhoa varchar(4)) alter KHOA add constraint fk_KHOA foreign key (TRGKH) references GIAOVIEN(MAGV) go create table MONHOC ( MaMH varchar(10)not null primary key, TenMH nvarchar(40), TcLT tinyint, TcTH tinyint, MaKhoa varchar(4) references KHOA(MaKH)) go create table DIEUKIEN( MaMH varchar(10) not null references MONHOC ( MaMH ), MaMH_Truoc varchar(10) not null references MONHOC( MaMH ), primary key( MaMH, MaMH_Truoc )) go create table GIAOVIEN( MaGV char(4) not null primary key, HoTen varchar (40), HocVi varchar(10), Hocham varchar(10), GioiTinh varchar(3), NgSinh smalldatetime, HeSo numeric(4,2), MucLuong money, MaKhoa varchar(4)references KHOA(MaKH), Ngvl smalldatetime) go create table LOP( MALOP char(3)not null primary key, TenLop varchar(40), Trglop char(4), SiSo tinyint, Magvcv char(4) not null references GIAOVIEN(MaGV)) go create table HOCVIEN( MaHV char(4) not null primary key, Ho varchar(40), Ten varchar(10), NgSinh smalldatetime, GIOITINH varchar (3), NoiSinh varchar(40), Malop char(3) references LOP(MaLop)) go Alter table LOP add constraint fk_fg foreign key (TrgLop) references HOCVIEN (MaHV) go create table GIANGDAY( MaLop char(3) not null references LOP(MaLop), MaMH varchar(10) not null references MONHOC(MaMH), MaGV char(4) references GIAOVIEN (MaGV), HocKy tinyint, Nam smallint, TuNgay smalldatetime, DenNgay smalldatetime, primary key (MaLop,MaMH)) go create table KETQUATHI( MaHV char(4) references HOCVIEN(MaHV), MaMH varchar(10) references MONHOC(MaMH), LanThi tinyint, NgThi smalldatetime, Diem numeric(4,2), KQua varchar(10)) go select * from KHOA insert into KHOA (MAKH, TenKhoa,NgTLap) values(KHMT,Khoa hoc may tinh,6/7/2005) insert into KHOA (MaKH, TenKhoa,NgTLap) values(HTTT,He thong thong tin,6/7/2005) insert into KHOA (MaKH, TenKhoa,NgTLap) values(CNPM,Cong nghe phan mem,6/7/2005) insert into KHOA (MaKH, TenKhoa,NgTLap) values(MTT,Mang va truyen thong,10/20/2005) insert into KHOA (MaKH, TenKhoa,NgTLap) values(KTMT,Ky thuat may tinh,12/20/2005) select * from LOP insert into LOP(MALOP,TenLop,SiSo) values(K11,Lop 1 Khoa 1,11) insert into LOP(MALOP,TenLop,SiSo) values(K12,Lop 2 Khoa 1,12) insert into LOP(MALOP,TenLop,SiSo) values(K13,Lop 3 Khoa 1,12) SELECT * FROM MONHOC insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(THDC,Tin hoc dai cuong,4,1,KHMT) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(CTRR,Cau truc roi rac,5,0,KHMT) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(CSDL,Co so du lieu,3,1,HTTT) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(CTDLGT,Cau truc du lieu va giai thuat,3,1,KHMT) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(PTTKTT,Phan tich thiet ke thuat toan,3,0,KHMT) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(DHMT,Do hoa may tinh,3,1,KHMT) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(KTMT,Kien truc may tinh,3,0,KHMT) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(TKCSDL,Thiet ke co so du lieu,3,1,HTTT) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(PTTKHTTT,Phan tich thiet ke he thong thong tin,4,1,HTTT) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(HDH,He dieu hanh,4,0,KTMT) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(NMCNPM,nhap mon cong nghe phan mem,3,0,CNPM) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(LTCFW,Lap trinh C for win,3,1,CNPM) insert into MONHOC(MaMH,TenMH,TcLT,TcTH,MaKhoa) values(LTHDT,Lap trinh huong doi tuong,3,1,CNPM) select * from DIEUKIEN insert into DIEUKIEN(MaMH,MaMH_Truoc) values(CSDL,CTRR) insert into DIEUKIEN(MaMH,MaMH_Truoc) values(CSDL,CTDLGT) insert into DIEUKIEN(MaMH,MaMH_Truoc) values(CTDLGT,THDC) insert into DIEUKIEN(MaMH,MaMH_Truoc) values(PTTKTT,THDC) insert into DIEUKIEN(MaMH,MaMH_Truoc) values(PTTKTT,CTDLGT) insert into DIEUKIEN(MaMH,MaMH_Truoc) values(DMMT,THDC) insert into DIEUKIEN(MaMH,MaMH_Truoc) values(LTHDT,THDC) insert into DIEUKIEN(MaMH,MaMH_Truoc) values(PTTKHTTT,CSDL) select * from GIAOVIEN insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) values (GV01,HO THANH SON,PTS,GS,NAM,5/2/1950,1/11/2004/,5.00,2.250000,KHMT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV02,TRAN TAM THANH,TS,PGS,NAM,12/17/1965,4/20/2004,4.50,2.025000,HTTT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV03,DO NGHIEM PHUNG,TS,GS,NU,8/1/1950,9/23/2004,4.00,1.800000,CNPM) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV04,TRAN THANH NAM/TS,PGS,NAM,2/22/1961,1/12/2005,4.50,2.025000,KTMT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV05,MAI THANH DANH,THS,GV,NAM,3/12/1958,1/12/2005,3.00,1.350000,HTTT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV06,TRAN DOAN HUNG,TS,GV,NAM,3/11/1953,1/12/2005,4.50,2.025000,KHMT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV07,NGUYEN MINH TIEN,THS,GV,NAM,11/23/1971,3/1/2005,4.00,1.800000,KHMT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV08,LE THI TRAN,KS,NULL,NU,3/26/1974,3/1/2005,1.69,760500,KHMT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV09,NGUYEN TO LAN,THS,GV,NU,12/31/1966,3/1/2005,4.00,1.800000,HTTT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV10,LE TRAN THANH LOAN,KS,NULL,NU,7/17/1972,3/1/2005,1.86,837000,CNPM) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV11,HO THANH TUNG,CN,GV,NAM,1/12/1980,5/15/2005,2.67,1.201500,MTT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV12,TRAN VAN ANH,CN,NULL,NU,3/29/1981,5/15/2005,1.69,760000,CNPM) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV13,NGUYEN LINH DAN,CN,NULL,NU,5/23/1980,5/15/2005,1.69,760500,KTMT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV14,TRUONG MINH CHAU,THS,GV,NU,11/30/1976,5/15/2005,3.00,1.350000,MTT) insert into GIAOVIEN(MaGV,HoTen,HocVi,Hocham,GioiTinh,NgSinh,Ngvl,HeSo,MucLuong,MaKhoa) VALUES (GV15, LE HA THANH,THS,GV,NAM,5/4/1978,5/15/2005,3.00,1.350000,KHMT) SELECT * FROM KETQUATHI INSERT INTO KETQUATHI(MAHV, MAMH, LANTHI, NGTHI, DIEM ,KQUA) VALUES (K1101,CSDL,1,7/20/2006,10.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LANTHI, NGTHI, DIEM ,KQUA) VALUES (K1101,CTDLGT,1,12/28/2006,9.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1101,THDC,1,5/20/2006,9.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1101,CTRR,1,5/13/2006,9.50,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1102,CSDL,1,7/20/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1102,CSDL,2,7/27/2006,4.25,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LANTHI, NGTHI, DIEM ,KQUA) VALUES (K1102,CSDL,3,8/10/2006,4.50,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LANTHI, NGTHI, DIEM ,KQUA) VALUES (K1102,CTDLGT,1,12/28/2006,4.50,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1102,CTDLGT,2,1/5/2007,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1102,CTDLGT,3,1/15/2007,6.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1102,THDC,1,5/20/2006,5.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1102,CTRR,1,5/13/2006,7.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1103,CSDL,1,7/20/2006,3.50,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1103,CSDL,2,7/27/2006,8.25,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1103,CTDLGT,1,12/20/2006,7.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1103,THDC,1,12/28/2006,8.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1103,CTRR,1,5/13/2006,6.50,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1104,CSDL,1,7/20/2006,3.75,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1104,CTDLGT,1,12/28/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1104,THDC,1,5/20/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1104,CTRR,1,5/13/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1104,CTRR,2,5/20/2006,3.50,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1104,CTRR,3,6/30/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1201,CSDL,1,7/20/2006,6.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1201,CTDLGT,1,12/28/2006,5.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES(K1201,THDC,1,5/20/2006,8.50,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1201,CTRR,1,5/13/2006,9.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1202,CSDL,1,7/20/2006,8.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1202,CTDLGT,1,12/28/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1202,CTDLGT,2,1/5/2007,5.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1202,THDC,1,5/20/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1202,THDC,2,5/27/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES(K1202,CTRR,1,5/13/2006,3.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1202,CTRR,2,5/20/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1202,CTRR,3,6/30/2006,6.25,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES(K1203,CSDL,1,7/20/2006,9.25,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1203,CTDLGT,1,12/28/2006,9.50,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1203,THDC,1,5/20/2006,10.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES(K1203,CTRR,1,5/13/2006,10.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1204,CSDL,1,7/20/2006,8.50,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1204,CTDLGT,1,12/28/2006,6.75,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES(K1204,THDC,1,5/20/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1204,CTRR,1,5/13/2006,6.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1301,CSDL,1,12/20/2006,4.25,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1301,CTDLGT,1,7/25/2006,8.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES(K1301,THDC,1,5/20/2006,7.75,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1301,CTRR,1,5/13/2006,8.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES( K1302,CSDL,1,12/20/2006,6.75,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1302,CTDLGT,1,7/25/2006,5.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1302,THDC,1,5/20/2006,8.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1302,CTRR,1,5/13/2006,8.50,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1303,CSDL,1,12/20/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1303,CTDLGT,1,7/25/2006,4.50,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES(K1303,CTDLGT,2,8/7/2006,4.00,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1303,CTDLGT,3,8/15/2006,4.25,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1303,THDC,1,5/20/2006,4.50,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1303,CTRR,1,5/13/2006,3.25,KHONG DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1303,CTRR,2,5/20/2006,5.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1304,CSDL,1,12/20/2006,7.75,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1304,CTDLGT,1,7/25/2006,9.75,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1304,THDC,1,5/20/2006,5.50,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES ( K1304,CTRR,1,5/13/2006,5.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES(K1305,CSDL,1,12/20/2006,9.25,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1305,CTDLGT,1,7/25/2006,10.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1305,THDC,1,5/20/2006,8.00,DAT) INSERT INTO KETQUATHI(MAHV, MAMH, LanThi, NGTHI, DIEM ,KQUA) VALUES (K1305,CTRR,1,5/13/2006,10.00,DAT) SELECT * FROM HOCVIEN INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES( K1101,NGUYEN VAN,A,1/27/1986,NAM,TP HCM,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1102,TRAN NGOC,HAN,3/14/1986,NU,KIEN GIANG,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1103,HA DUY,LAP,4/18/1986,NAM,NGHE AN,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1104,TRAN NGOC,LINH,3/30/1986,NU,TAY NINH,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1105,TRAN MINH,LONG,2/27/1986,NAM,TP HCM,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1106,LE NHAT,MINH,1/24/1986,NAM,TP HCM,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1107,NGUYEN NHU,NHUT,1/27/1986,NAM,HA NOI,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1108,NGUYEN MANH,TAM,2/27/1986,NAM,KIENG GIANG,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1109,PHAN THI THANH,TAM,1/27/1986,NU,VINH LONG,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1110,LE HOAI,THUONG,2/5/1986,NU,CAN THO,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1111,LE HA,VINH,12/25/1986,NAM,VINH LONG,K11) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1201,NGUYEN VAN,B,2/11/1986,NAM,TP HCM,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1202,NGUYEN THI KIM,DUYEN,1/18/1986,NU,TP HCM,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1203,TRAN THI KIM, DUYEN,9/17/1986,NU,DONG NAI,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1204,TRUONG MY,HANH,5/19/1986,NU,DONG NAI,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1205,NGUYEN THANH,NAM,4/17/1986,NAM,TP HCM,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1206,NGUYEN THI TRUC,THANH,3/4/1986,NU,KIENG GIANG,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1207,TRAN THI BICH,THUY,2/8/1986,NU,NGHE AN,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1208,HUYNH THI KIM,TRIEU,4/8/1986,NU,TAY NINH,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1209,PHAN THANH,TRIEU,2/23/1986,NAM,TP HCM,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1210,NGO THANH,TUAN,2/14/1986,NAM,TP HCM,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1211,DO THI,XUAN,3/9/1986,NU,HA NOI,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1212,LE THI PHI,YEN,3/12/1986,NU,TP HCM,K12) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1301,NGUYEN THI KIM,CUC,6/9/1986,NU,KIENG GIANG,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1302,TRUONG THI MY,HIEN,3/18/1986,NU,NGHE AN,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1303,LE DUC,HIEN,3/18/1986,NAM,TAY NINH,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1304,LE QUANG,HIEN,4/18/1986,NAM,TP HCM,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1305,LE THI,HUONG,3/27/1986,NU,TP HCM,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1306,NGUYEN THAI,HUU,3/30/1986,NAM,HA NOI,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1307,TRAN MINH,MAN,5/28/1986,NAM,TP HCM,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1308,NGUYEN HIEU,NGHIA,4/8/1986,NAM,KIEN GIANG,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1309,NGUYEN TRUNG,NGHIA,1/18/1987,NAM,NGHE AN,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1310,TRAN THI HONG,THAM,4/22/1986,NU,TAY NINH,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1311,TRAN MINH,THUC,4/4/1986,NAM,TP HCM,K13) INSERT INTO HOCVIEN(MAHV,HO,TEN,NGSINH, GIOITINH, NOISINH,MALOP) VALUES (K1312,NGUYEN THI KIM,YEN,9/7/1986,NU,TP HCM,K13) 1/ SELECT MaHV, HO+ +TEN AS HOTEN,NGSINH,H.MALOP FROM HOCVIEN H,LOP WHERE H.MAHV = LOP.TRGLOP 2/ SELECT K.MaHV,HO+ + TEN as HOTEN, LanThi,DIEM FROM KETQUATHI K, HOCVIEN H where K.MaHV =H.MaHV and MaMH =CTRR and Malop =K12 ORDER BY Ten,Ho 3/ SELECT H.MaHV, HO++TEN AS HOTEN, TenMH FROM HOCVIEN H, MONHOC M, KETQUATHI K WHERE LanThi =1 AND Diem >=5 AND K.MaHV = H.MaHV AND M.MaMH = K.MaMH 4/ SELECT H.MAHV, HO++TEN AS HOTEN FROM KETQUATHI K,HOCVIEN H WHERE LanThi =1 AND Diem
Posted on: Mon, 17 Mar 2014 06:33:06 +0000
Trending Topics
Recently Viewed Topics
© 2015