QLSV, Sql Server - rextester

QLSV

create table hs
(
    mssv int,
    ho varchar(10),
    dem varchar(10),
    ten varchar(10),
    ngaysinh date
    );

create table chuong_trinh_dao_tao
(
    ma_hp varchar(10),
    ten_hp varchar(20),
    ky_hoc varchar(10),
    tin_chi_hoc real,
    ghi_chu varchar(100),
    vien_khoa varchar(100)
    );

create table mon_hoc
(
    ma_mon varchar(10),
    ten_mon varchar(50),
    tin_chi_hoc_phan real,
    tin_chi_hoc_phi real
    );

create table kqht
(
    mssv int,
    ma_mon varchar(10),
    diem_so int,
    diem_chu varchar(2)
    );

create table tkh
(
    thoi_gian date,
    tuan_hoc int,
    phong_hoc varchar(10),
    ma_lop varchar(10),
    loai_lop varchar(10),
    nhom varchar(20),
    ma_hp varchar(10),
    ten_lop varchar(20),
    ghi_chu varchar(100),
    giang_vien varchar(20)
    );

create table lich_thi
(
    ma_lop_thi varchar(10),
    ma_lop_hoc varchar(10),
    ma_hp varchar(10),
    ten_hp varchar(50),
    dot varchar(2),
    tuan int,
    thu varchar(10),
    ngay date,
    kip int,
    phong varchar(10)
    )

create table bang_diem_ca_nhan
(
    hoc_ky varchar(10),
    ma_hp varchar(10),
    ten_hp varchar(50),
    tin_chi real,
    lop_hoc varchar(10),
    diem_qua_trinh real,
    diem_thi real,
    diem_so real,
    diem_chu varchar(2)
    )

create table bang_diem_hoc_phan
(
    ma_vien varchar(10),
    ten_sv varchar(50),
    ma_hp varchar(10),
    ten_hp varchar(50),
    diem_chu varchar(2),
    diem_so real
    )
insert into hs
values(20185353, 'Pham', 'Van', 'Hieu', '2000-9-7');

select * from hs;

drop table hs;


run \| edit \| history \| help	0