ALTER TABLE GIAOVIEN
ADD CONSTRAINT FK_GV_GV FOREIGN KEY (GVQLCM) REFERENCES GIAOVIEN

ALTER TABLE GIAOVIEN 
ADD CONSTRAINT FK_GV_BM	FOREIGN KEY (MABM) REFERENCES BOMON

--KHOA
ALTER TABLE KHOA
ADD CONSTRAINT FK_K_GV FOREIGN KEY (TRUONGKHOA) REFERENCES GIAOVIEN

--BOMON
ALTER TABLE BOMON
ADD CONSTRAINT FK_BM_GV FOREIGN KEY (TRUONGBM) REFERENCES GIAOVIEN

ALTER TABLE BOMON
ADD	CONSTRAINT FK_BM_K 	FOREIGN KEY (MAKHOA) REFERENCES KHOA

--GV_DT
ALTER TABLE GV_DT
ADD CONSTRAINT FK_GVDT_GV FOREIGN KEY (MAGV) REFERENCES GIAOVIEN

--NGUOITHAN
ALTER TABLE NGUOITHAN
ADD CONSTRAINT FK_NT_GV FOREIGN KEY (MAGV) REFERENCES GIAOVIEN

--THAMGIADT
ALTER TABLE THAMGIADT
ADD CONSTRAINT FK_TGDT_GV FOREIGN KEY (MAGV) REFERENCES GIAOVIEN

ALTER TABLE THAMGIADT
ADD CONSTRAINT FK_TGDT_CV FOREIGN KEY (MADT, STT) REFERENCES CONGVIEC

 --CONGVIEC
ALTER TABLE CONGVIEC
ADD CONSTRAINT FK_CV_DT FOREIGN KEY (MADT) REFERENCES DETAI

--DETAI
ALTER TABLE DETAI
ADD CONSTRAINT FK_DT_CD FOREIGN KEY (MACD) REFERENCES CHUDE
ALTER TABLE DETAI
ADD CONSTRAINT FK_DT_GV FOREIGN KEY (GVCNDT) REFERENCES GIAOVIEN