use QLSV
go
-- Nhap lieu bang Khoa
insert into Khoa values ( 'CNTT', N'Công nghệ thông tin', 1995)
go
insert into Khoa values ( 'VL', N'Vật Lý', 1970)
go
-- Nhap lieu bang KhoaHoc
insert into KhoaHoc values ( 'K2002', 2002 , 2006)
go
insert into KhoaHoc values ( 'K2003', 2003 , 2007)
go
insert into KhoaHoc values ( 'K2004', 2004 , 2008)
go
-- Nhap lieu bang ChuongTrinh
insert into ChuongTrinh values ( 'CQ', N'Chính Quy')
go
--Nhap lieu cho bang Lop
insert into Lop values ( 'TH2002/01', 'K2002','CNTT','CQ',1)
go
insert into Lop values ( 'TH2002/02', 'K2002','CNTT','CQ',2)
go
insert into Lop values ( 'VL2003/01', 'K2003','VL','CQ',1)
go
--Nhap lieu cho bang SinhVien
insert into SinhVien values ( '0212001', N'Nguyễn Vĩnh An', 1984, 'Kinh', 'TH2002/01')
go
insert into SinhVien values ( '0212002', N'Nguyễn Thanh Bình', 1985, 'Kinh', 'TH2002/01')
go
insert into SinhVien values ( '0212003', N'Nguyễn Thanh Cường', 1984, 'Kinh', 'TH2002/02')
go
insert into SinhVien values ( '0212004', N'Nguyễn Quốc Duy', 1983, 'Kinh', 'TH2002/02')
go
insert into SinhVien values ( '0311001', N'Phan Tuấn Anh', 1985, 'Kinh', 'VL2003/01')
go
insert into SinhVien values ( '0311002', N'Huỳnh Thanh Sang', 1984, 'Kinh', 'VL2003/01')
go
-- Nhap lieu bang MonHoc
insert into MonHoc values ( 'THT01', N'Toán Cao cấp A1','CNTT')
go
insert into MonHoc values ( 'VLT01', N'Toán Cao cấp A1','VL')
go
insert into MonHoc values ( 'THT02', N'Toán rời rạc','CNTT ')
go
insert into MonHoc values ( 'THCS01', N'Cấu trúc dữ liệu 1','CNTT ')
go
insert into MonHoc values ( 'THCS02', N'Hệ điều hành', 'CNTT ')
go
-- Nhap lieu bang KetQua
insert into KetQua values ( '0212001', 'THT01',1,4)
go
insert into KetQua values ( '0212001', 'THT01',2,7)
go
insert into KetQua values ( '0212002', 'THT01',1,8)
go
insert into KetQua values ( '0212003', 'THT01',1,6)
go
insert into KetQua values ( '0212004', 'THT01',1,9)
go
insert into KetQua values ( '0212001', 'THT02',1,8)
go
insert into KetQua values ( '0212002', 'THT02',1,5.5)
go
insert into KetQua values ( '0212003', 'THT02',1,4)
go
insert into KetQua values ( '0212003', 'THT02',2,6)
go
insert into KetQua values ( '0212001', 'THCS01',1,6.5)
go
insert into KetQua values ( '0212002', 'THCS01',1,4)
go
insert into KetQua values ( '0212002', 'THCS01',2,4)
go
insert into KetQua values ( '0212002', 'THCS01',3,6)
go
insert into KetQua values ( '0212003', 'THCS01',1,7)
go
-- Nhap lieu bang GiangKhoa
insert into GiangKhoa values ( 'CQ', 'CNTT','THT01',2003,1,60,30,5)
go
insert into GiangKhoa values ( 'CQ', 'CNTT','THT02',2003,2,45,30,4)
go
insert into GiangKhoa values ( 'CQ', 'CNTT','THCS01',2004,1,45,30,4)
go