PEMROGRAMAN BASIS DATA PERTEMUAN III

Soal :

Jawaaban : 

                                                                      Tabel Bagian  

             insert into bagian values('BO1','KEUANGAN','JAKARTA');

insert into bagian values('BO2','HRD','JAKARTA');

   insert into bagian values('BO3','TEKNISI','CIAMIS');

     insert into bagian values('BO4','UMUM','BANDUNG');

                                                                        Tabel Pegawai 

  insert into PEGAWAI values('P11','AMIR','1-FEB-80','25-JUN-12','BO1');

     insert into PEGAWAI values('P12','BENU','20-AUG-90','14-JUL-12','BO2');

        insert into PEGAWAI values('P13','CINTA','16-AUG-84','15-APR-11','BO3');

        insert into PEGAWAI values('P14','DENA','30-MAY-88','30-JUN-10','BO1');

insert into PEGAWAI values('P15','EKA','4-JUL-89','7-OCT-11','BO4');

   insert into PEGAWAI values('P16','EKA','16-SEP-88','4-NOV-11','BO3');

TABEL TANGGUNGAN

      insert into tanggungan values ('P11','ASTUTI','W','ISTRI');

   insert into tanggungan values ('P11','IMRA','P','ANAK');

   insert into tanggungan values ('P13','HANI','P','ANAK');

        insert into tanggungan values ('P13','PINKY','W','ANAK');

insert into tanggungan values ('P12','SRI','W','ISTRI');

 TABEL PROYEK

INSERT INTO PROYEK VALUES ('PR1','JALAN TOL ANTASARI','JAKARTA','BO3');

INSERT INTO PROYEK VALUES ('PR2','JEMBATAN SURAMADU','SURABAYA','BO3');

INSERT INTO PROYEK VALUES ('PR3','PAJAK','JAKARTA','BO1');

INSERT INTO PROYEK VALUES ('PR4','TES PSIKOTESA','JAKARTA','BO2');

TABEL KERJA

INSERT INTO KERJA VALUES ('P11','PR1','2');

INSERT INTO KERJA VALUES ('P12','PR1','2');

INSERT INTO KERJA VALUES ('P13','PR4','3');

INSERT INTO KERJA VALUES ('P13','PR3','4');

INSERT INTO KERJA VALUES ('P16','PR2','2');

INSERT INTO KERJA VALUES ('P11','PR1','5');

TABEL PEG_MINGGUAN , PEG_HARIAN, PEG_TETAP

INSERT INTO PEG_MINGGUAN VALUES ('P14');

INSERT INTO PEG_HARIAN VALUES ('P15');

INSERT INTO PEG_TETAP VALUES ('P11','2500');

INSERT INTO PEG_TETAP VALUES ('P12','3500');

INSERT INTO PEG_TETAP VALUES ('P13','2500');