progres tugas besar sql

create table guru(

kd_guru char (4),

nama_guru varchar (20),

alamat varchar(30),

jenis_kelamin char (1),

status_jabatan varchar (10),

no_tlp varchar (15),

constraint pk_guru primary key(kd_guru)

);

create table jadwal (

no number ,

nis char (5),

nama_siswa varchar (20),

kd_guru char (4),

nama_guru varchar (20),

kd_program char (5),

nama_program varchar (15),

hari char (10),

jam char (8),

constraint pk_jadwal primary key(no, kd_guru, nis),

constraint fk_jadwal foreign key (kd_guru)references guru (kd_guru),

constraint fk_jadwal1 foreign key (nis)references siswa (nis),

constraint fk_jadwal2 foreign key (kd_program)references program (kd_program)

);

create table siswa (

nis char (5),

nama_siswa varchar (20),

alamat varchar(30),

jenis_kel char(1),

nama_ortu varchar (20),

no_telpon varchar (15),

constraint pk_siswa primary key(nis)

);

  

create table gaji (

kd_guru char (4),

nama_guru varchar (20),

jml_hadir number,

total_gaji number,

constraint pk_gaji primary key(kd_guru),

constraint fk_gaji foreign key (kd_guru)references guru (kd_guru)

);

create table nilai_siswa (

nis char (5),

nama_siswa varchar (20),

kd_program char (5),

nilai number,

constraint pk_nilai_siswa primary key(nis, kd_program),

constraint fk_nilai_siswa foreign key (nis)references siswa (nis),

constraint fk_nilai_siswa1 foreign key (kd_program)references program (kd_program));

create table program (

kd_program char (5),

nama_program varchar (20),

kd_guru char (4),

nilai number,

constraint pk_program primary key(kd_program,kd_guru),

constraint fk_program foreign key (kd_guru)references guru (kd_guru));

Struktur Tabel