Database

Topic Management

• In this project, we will understand how to use query languages to manipulate the database of the relational data model
• Password to enter the field, please contract me. Thank you !

1/ Database Schema

GIAOVIEN (MAGV, HOTEN, LUONG, PHAI, NGAYSINH, DIACHI, GVQLCM, MABM)
GV_DT (MAGV, DIENTHOAI)
BOMON (MABM, TENBM, PHONG, DIENTHOAI, TRUONGBM, MAKHOA, NGAYNHANCHUC)
KHOA (MAKHOA, TENKHOA, NAMTL, PHONG, DIENTHOAI, TRUONGKHOA, NGAYNHANCHUC)
DETAI (MADT, TENDT, KINHPHI, CAPQL, NGAYBD, NGAYKT, MACD, GVCNDT)
CHUDE (MACD, TENCD)
CONGVIEC (MADT, STT, TENCV, NGAYBD, NGAYKT)
THAMGIADT(MAGV, MADT, STT, PHUCAP, KETQUA)
NGUOI_THAN (MAGV, TEN, NGSINH, PHAI)

2/ Database Schema in the form of a figure