Cơ sở dữ liệu

BAI 3

PERSON(ID, NAME, DOB, ADD)
PATIENT(P_ID, OCCUP)
DOCTOR(D_ID, YEAR-EXP)
DOCTOR_SPE(D_ID, SPECIAL)
MANAGER(M_ID, POSITION)


BAI 1

E1(A1, A2, A3, A7, A8)
E2(A4, A5, A7,A8)
E3(A9,A10,A11)
E4(A13,A14,A15,A16,A1)
A12(A12,A14)
R2(A7,A8,A9)
R3(A14,A9)
A17(A14,A9,A18,A19)


BAI 2

SHIP(SNAME,OWNER,PNAME,STATE_NAME, TYPE_SHIP)
SHIP_TYPE(TYPE,TOMAGE,HULL)
STATE(NAME,COUNTRY)
SEA/OCEAN/LAKE(NAME)
PORT(PNAME,STATE,NAME)
SHIP_MOVEMENT(DATE,TIME,SNAME,LONGITUDE,LATITUDE)
VISITS(START_DATE,SNAME,PNAME,STATE_NAME, END_DATE)

BAI 4

LMAYBAY(MA,KIEU,TL,SC)
MAYBAY(MA DK,MA LMAYBAY,MA NHACMB)
PHICONG(SO CMND,MS BANG,NGAYCAP)
NHANVIEN(SO CMND,LUONG,CA)
NGUOI(SO CMND,TEN,DIACHI,SO DT, MA NCHU)
DOANHNGHIEP(TEN,SO DT, DIA CHI,SO DT, MA NCHU)
NGUOICHU(MA NCHU)
NHACHUAMAYBAY(MA,SC , VI TRI)
LANBAOHANH(MA DK,NGAY GIO,SO GIO BAO HANH,CV)
LAI(MA,SO CMND)
CHUYEN(MA, SO CMND)
THUCHIEN(SO CMND,NGAYGIO)
SOHUU(MA DK,MA CHU,NGAY BAO HANH)
NCHU(MA,MA DN,SO CMND)