Progress Tugas Besar SQL 25 November 2014

Aplikasi Les Komputer

Pada Visual Basic

Form Guru

Form Jadwal

Form Siswa

Form Nilai Siswa

Form Gaji

Form Program

Pada Oracle

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 Table