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
    );

create table do_an
(
    mssv int,
    ten_sv varchar(50),
    loai_do_an varchar(10),
    giang_vien_huong_dan varchar(50),
    diem real
    );

create table hoc_bong_tai_nang
(
    mssv int,
    ten_sv varchar(50),
    lop varchar (20),
    khoa varchar (50),
    vien varchar (50),
    gpa real,
    diem_ren_luyen real
    );
create table hoc_bong_ho_tro_hoc_tap
(
    mssv int,
    ten_sv varchar(50),
    lop varchar(10),
    khoa varchar(50),
    vien varchar(50),
    hoan_canh varchar(100),
    loai_hoc_bong varchar(50)
    );

create table canh_cao_hoc_tap
(
    mssv int,
    ten_sv varchar(50),
    gpa real,
    khoa varchar(50),
    vien varchar(50),
    muc_canh_cao varchar(2)
    );

create table table_thong_tin_sinh_vien
(
    ten varchar(50),
    nam_vao_truong int,
    bac_dao_tao varchar(10),
    chuong_trinh varchar(50),
    vien varchar(50),
    tinh_trang varchar(10),
    gioi_tinh varchar(5),
    lop varchar(10),
    khoa_hoc varchar(50),
    email varchar(100)
    );

create table thong_tin_ca_nhan
(
    ten varchar(50),
    mssv int,
    nam_sinh int,
    gioi_tinh varchar(5),
    dia_chi varchar(100),
    sdt varchar(20),
    email varchar(100),
    dan_toc varchar (10)
    );
    
create table bao_luu
(
    mssv int,
    ten_sv varchar(50),
    ky_bao_luu varchar(10),
    diem real
    );
    
create table nhom_nganh
(
    ma_nganh varchar(10),
    ten_nganh varchar (50)
    );

create table vien
(
    ma_vien varchar(10),
    ten_vien varchar(50),
    nam_thanh_lap varchar(10),
    vien_truong varchar(50)
    );

create table lop_sv
(
    ma_lop varchar(10),
    ten_lop varchar(50),
    khoa varchar(50),
    vien varchar(50),
    so_luong int
    );

create table lop_hoc_ky
(
    ma_lop varchar(10),
    ten_lop varchar(50),
    ten_mon varchar(50),
    giang_vien varchar(50),
    so_luong int
    );

insert into hs
values(20185353, 'Pham', 'Van', 'Hieu', '2000-9-7');

select * from hs;

drop table hs;


run \| edit \| history \| help	0