phan4

create table IDThiSinhDaDuThi (
  IdKyThi varchar(100), 
  IdThiSinhDaDuThi varchar(100),  
  PRIMARY KEY (IdKyThi, IdThiSinhDaDuThi));
create table BangTraLoiCuaThiSinh (
  IdBangTraLoi varchar(100), 
  IdBaiThi varchar(100), 
  HoVaTenThiSinhTraLoi varchar(100),
  NgayGioThucHien DATETIME,
  ThoiLuongThucHien interval,
  TongDiemBaiThi real, 
  IdThisinh varchar(100),
  PRIMARY KEY (IdBangTraLoi));
create table LuaChon (
  SoThuTuLuaChon varchar(100), 
  IdCauHoi varchar(100), 
  LuaChonDung varchar(100), 
  Diem real , 
  VanBanLuaChon TEXT, 
  PRIMARY KEY (SoThuTuLuaChon, IdCauHoi));
create table CauTraLoi (
  SoThuTuDaLuaChon varchar(100), 
  IdCauHoi varchar(100), 
  IdBangTraLoi varchar(100),  
  PRIMARY KEY (IdCauHoi, IdBangTraLoi));