Scribd
Upload
4 views3 pages

Database Schema for Student Events

The document outlines a database schema for managing academic events, including entities such as semesters, majors, courses, and student evaluations. It specifies various attributes for each entity, including data types and relationships, as well as enumerations for statuses related to event participation and evaluations. Additionally, it includes details on administrative and student information management.

Uploaded by

tranthienqn1234
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views3 pages

Database Schema for Student Events

The document outlines a database schema for managing academic events, including entities such as semesters, majors, courses, and student evaluations. It specifies various attributes for each entity, including data types and relationships, as well as enumerations for statuses related to event participation and evaluations. Additionally, it includes details on administrative and student information management.

Uploaded by

tranthienqn1234
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

HocKy

0..1
MaHK VARCHAR(10) 1

TenHK VARCHAR(255)
Nganh
ThoiGianBatDau DATETIME
0..1
MaNganh VARCHAR(10) DiemRLSV
ThoiGianKetThuc DATETIME
*
TenNganh VARCHAR(255) MSSV VARCHAR(10) BienDongDRL
* *
MaKhoa VARCHAR(10) MaHK VARCHAR(10) MaGD INT

SoDiem INT LoaiGD BienDongDRL_LoaiGD_enum


*
MSSV VARCHAR(10)

NoiDung TEXT
Khoa
ThoiGian DATETIME
0..1
0..1 Lop
MaKhoa VARCHAR(10) 1
SoDiem INT
0..1
MaLop VARCHAR(10)
SuKien TenKhoa VARCHAR(255)
0..1
TenLop VARCHAR(255)
MaSK INT 1
*
MaNganh VARCHAR(10)
TenSK VARCHAR(255)
Admin
ThoiGianMoDK DATETIME
AdminID VARCHAR(10)
ThoiGianDongDK DATETIME
Ho VARCHAR(100)
ThoiGianBatDauSK DATETIME DotDanhGiaRL
Ten VARCHAR(100)
1
ThoiGianKetThucSK DATETIME MaDot INT
Email VARCHAR(255)
*
GioiHanThamGia INT MaHK VARCHAR(10)
Password VARCHAR(255)
SinhVien
*
MaKhoa VARCHAR(10) ThoiGianMo DATETIME 0..1 0..1
1 MSSV VARCHAR(10) 1
GhiChu TEXT ThoiGianDong DATETIME
Ho VARCHAR(255)

Ten VARCHAR(255)

Email VARCHAR(255)

Password VARCHAR(255)
*
MaLop VARCHAR(10)

ChoPhepSVKhoaThamGia
PhieuDanhGiaRL
*
MaSK INT
*
MaDot INT
*
MaKhoa VARCHAR(10)
*
MSSV VARCHAR(10)

ThoiGianNop DATETIME
DKSuKien
JSON_Data JSON
MaLuotDK INT
TrangThai PhieuDanhGiaRL_TrangThai_enum
*
MSSV VARCHAR(10)
*
MaSK INT

ThoiGianDK DATETIME

TrangThai DKSuKien_TrangThai_enum

MinhChungThamGiaSK

IDMinhChung INT
*
MSSV VARCHAR(10)
*
MaSK INT

ThoiGianNop DATETIME

FileMinhChung VARCHAR(255)

TrangThai MinhChungThamGiaSK_TrangThai_enum
HocKy
0..1
MaHK VARCHAR(10) 1

TenHK VARCHAR(255)
Nganh
ThoiGianBatDau DATETIME
0..1
MaNganh VARCHAR(10) DiemRLSV
ThoiGianKetThuc DATETIME
*
TenNganh VARCHAR(255) MSSV VARCHAR(10) BienDongDRL
* *
MaKhoa VARCHAR(10) MaHK VARCHAR(10) MaGD INT

SoDiem INT LoaiGD BienDongDRL_LoaiGD_enum


*
MSSV VARCHAR(10)

NoiDung TEXT
Khoa
ThoiGian DATETIME
0..1
0..1 Lop
MaKhoa VARCHAR(10) 1
SoDiem INT
0..1
MaLop VARCHAR(10)
SuKien TenKhoa VARCHAR(255)
0..1
TenLop VARCHAR(255)
MaSK INT 1
*
MaNganh VARCHAR(10)
TenSK VARCHAR(255)
Admin
ThoiGianMoDK DATETIME
AdminID VARCHAR(10)
ThoiGianDongDK DATETIME
Ho VARCHAR(100)
ThoiGianBatDauSK DATETIME DotDanhGiaRL
Ten VARCHAR(100)
1
ThoiGianKetThucSK DATETIME MaDot INT
Email VARCHAR(255)
*
GioiHanThamGia INT MaHK VARCHAR(10)
Password VARCHAR(255)
SinhVien
*
MaKhoa VARCHAR(10) ThoiGianMo DATETIME 0..1 0..1
1 MSSV VARCHAR(10) 1
GhiChu TEXT ThoiGianDong DATETIME
Ho VARCHAR(255)

Ten VARCHAR(255)

Email VARCHAR(255)

Password VARCHAR(255)
*
MaLop VARCHAR(10)

ChoPhepSVKhoaThamGia
PhieuDanhGiaRL
*
MaSK INT
*
MaDot INT
*
MaKhoa VARCHAR(10)
*
MSSV VARCHAR(10)

ThoiGianNop DATETIME
DKSuKien
JSON_Data JSON
MaLuotDK INT
TrangThai PhieuDanhGiaRL_TrangThai_enum
*
MSSV VARCHAR(10)
*
MaSK INT

ThoiGianDK DATETIME

TrangThai DKSuKien_TrangThai_enum

MinhChungThamGiaSK

IDMinhChung INT
*
MSSV VARCHAR(10)
*
MaSK INT

ThoiGianNop DATETIME

FileMinhChung VARCHAR(255)

TrangThai MinhChungThamGiaSK_TrangThai_enum
Enum DKSuKien_TrangThai_enum {
Đăng ký
Hủy đăng ký
}

Enum MinhChungThamGiaSK_TrangThai_enum {
Đã duyệt
Chờ duyệt
Từ chối
}

Enum BienDongDRL_LoaiGD_enum {
Cộng
Trừ
}

Enum PhieuDanhGiaRL_TrangThai_enum {
Đã duyệt
Đã điều chỉnh
Chờ duyệt
Từ chối
}

You might also like