create database QLSV go use QLSV go create table Khoa ( MaKhoa varchar(10) primary key, tenKhoa nvarchar(100), namThanhLap int ) go create table KhoaHoc ( MaKhoaHoc varchar(10) primary key, namBatDau int, namKetThuc int ) go create table ChuongTrinh ( MaCT varchar(10) primary key, tenChuongTrinh nvarchar(100) ) go create table Lop ( MaLop varchar(10) primary key, MaKhoahoc varchar(10) not null, MaKhoa varchar(10) not null, MaCT varchar(10) not null, stt int foreign key (MaKhoaHoc) references KhoaHoc(MaKhoaHoc), foreign key (MaKhoa) references Khoa(MaKhoa), foreign key (MaCT) references ChuongTrinh(MaCT) ) go create table SinhVien ( MaSV varchar(10) primary key, HoTen nvarchar(100), NamSinh int, DanToc nvarchar(20), MaLop varchar(10) not null foreign key (Malop) references Lop(MaLop), ) go create table MonHoc ( MaMH varchar(10) primary key, tenMH nvarchar(100), MaKhoa varchar(10) not null foreign key (MaKhoa) references Khoa(MaKhoa) ) go create table KetQua ( MaSV varchar(10) not null, MaMH varchar(10) not null, LanThi int not null, Diem float primary key(MaSV, MaMH, LanThi), foreign key (MaSV) references SinhVien(MaSV), foreign key (MaMH) references MonHoc(MaMH), ) go create table GiangKhoa ( MaCT varchar(10) not null, MaKhoa varchar(10) not null, MaMH varchar(10) not null , NamHoc int not null , HocKy int , SoTietLyThuyet int, SoTietThucHanh int, SoTinChi int primary key (MaCT, MaKhoa, MaMH, NamHoc), foreign key (MaCT) references ChuongTrinh(MaCT), foreign key (MaKhoa) references Khoa(MaKhoa), foreign key (MaMH) references MonHoc(MaMH), ) go