DATA DEFINITION LANGUAGE DAN DATA MANIPULATION LANGUAGE PADA ORACLE

Create Table Tfakultas

( Kode_f Char(3) NOT NULL PRIMARY Key,

  Nama_f Varchar2(100),

  Nama_PS char(20),

  Status char(45),

  NoSK char(35)

);



Create Table Tmhs

( Nobp Char(16) NOT NULL PRIMARY Key,

  Nama Varchar2(100),

  Kelas char(15),

  Kode_f char(3) References Tfakultas(Kode_f)

);



Create Table Tmtk

( Kode_MK Char(10) NOT NULL PRIMARY Key,

  Nama_MK Varchar2(100),

  Sks number(2),

  Prasyarat1 char(10),

  Prasyarat2 char(10),

  Prasyarat3 char(10)

);



Create Table tNilai

( Kode_MK Char(10) References tmtk(kode_mk),

  Nobp Char(16) References tmhs(nobp), 

  Nilai_KUIS number(5,2), 

  Nilai_PR number(5,2), 

  Nilai_UTS number(5,2), 

  Nilai_UAS number(5,2),

  constraint pk_nilai PRIMARY KEY (kode_mk, Nobp)

);



Insert into tfakultas values ('261','Ilmu Komputer','Sistem Informasi','Terakreditasi','001/BAN-PT/S1/SK/2009');

Insert into tfakultas values ('262','Ilmu Komputer','Sistem Komputer','Terakreditasi','056/BAN-PT/S1/SK/2006');

Insert into tfakultas values ('260','Ilmu Komputer','Mnj. Informatika','Terakreditasi','089/BAN-PT/D3/SK/2006');

Insert into tfakultas values ('263','Ilmu Komputer','Teknik Informatika','Terdaftar','-');

Insert into tfakultas values ('511','Ekonomi','S1-Akuntansi', 'Terakreditasi','056/BAN-PT/S1/SK/2006');

Insert into tfakultas values ('531','Ekonomi','S1-Manajemen‘ ,'Terakreditasi','089/BAN-PT/D3/SK/2006');

Insert into tfakultas values ('751','Psikologi','Psikologi' ,'Terakreditasi','089/BAN-PT/S1/SK/2009');

Insert into tfakultas values ('425','Teknologi Industri','Teknik Industri' ,'Terdaftar','-');

Insert into tfakultas values ('433','Sipil Dan Perencanaan','Teknik Sipil,'Terdaftar','-');

Insert into tfakultas values ('911','Desain Komunikasi Visual','DKV' ,'Terdaftar','-');

Insert into tfakultas values ('811','Pascasarjana','S2-Mag Manajemen' ,'Terakreditasi','089/BAN-PT/S2/SK/2008');

Insert into tfakultas values ('812','Pascasarjana','S2-Mag Komputer' ,'Terakreditasi','089/BAN-PT/S2/SK/2008');



select * from tfakultas;



Insert into Tmtk values ('KKKI53001','Apl. DBServer',2,NULL,NULL,NULL);

Insert into Tmtk values ('KKKI52002','Perbankan',2,NULL,NULL,NULL);

Insert into Tmtk values ('KKKI53011','Multiuser',2,NULL,NULL,NULL);

Insert into Tmtk values ('KKKI53012','Mnj. Sains',2,NULL,NULL,NULL);

Insert into Tmtk values ('KKKI52005','Peng. Sistem Informasi',2,NULL,NULL,NULL);

Insert into Tmtk values ('KKKI52006','Prak. Sistem Operasi Jaringan',2,NULL,NULL,NULL);

Insert into Tmtk values ('KKKI53007','Teknik Kompilasi',2,NULL,NULL,NULL);



select * from tmtk;



Insert into tmhs values ('07101152610254','Widya','4SI-6','261');

Insert into tmhs values ('07101152610255','Atika','4SI-6','261');

Insert into tmhs values ('07101152610256','Danny','4SI-6','261');

Insert into tmhs values ('07101152610257','Debie','4SI-6','261');

Insert into tmhs values ('07101152610258','Thia','4SI-6','261');

Insert into tmhs values ('07101152610259','Susy','4SI-6','261');

Insert into tmhs values ('07101152610260','Egil','4SI-6','261');



select * from tmhs;



Insert into tnilai values ('KKKI53001','07101152610260',80,75,60,60);

Insert into tnilai values ('KKKI52002','07101152610260',80,85,65,75);

Insert into tnilai values ('KKKI53011','07101152610260',70,55,70,80);

Insert into tnilai values ('KKKI53012','07101152610260',80,65,80,90);

Insert into tnilai values ('KKKI52005','07101152610260',90,75,90,60);

Insert into tnilai values ('KKKI52006','07101152610260',60,65,80,70);

Insert into tnilai values ('KKKI53001','07101152610254',80,75,60,60);

Insert into tnilai values ('KKKI52002','07101152610254',80,85,65,75);

Insert into tnilai values ('KKKI53011','07101152610254',70,55,70,80);

Insert into tnilai values ('KKKI53012','07101152610254',80,65,80,90);

Insert into tnilai values ('KKKI52005','07101152610254',90,75,90,60);

Insert into tnilai values ('KKKI52006','07101152610254',60,65,80,70);

Insert into tnilai values ('KKKI53007','07101152610254',70,55,90,80);

Insert into tnilai values ('KKKI53001','07101152610255',80,75,60,60);

Insert into tnilai values ('KKKI52002','07101152610255',80,85,65,75);

Insert into tnilai values ('KKKI53011','07101152610255',70,55,70,80);

Insert into tnilai values ('KKKI53012','07101152610255',80,65,80,90);

Insert into tnilai values ('KKKI52005','07101152610255',90,75,90,60);

Insert into tnilai values ('KKKI52006','07101152610255',60,65,80,70);

Insert into tnilai values ('KKKI53007','07101152610255',70,55,90,80);

Insert into tnilai values ('KKKI53001','07101152610256',80,75,60,60);

Insert into tnilai values ('KKKI52002','07101152610256',80,85,65,75);

Insert into tnilai values ('KKKI53011','07101152610256',70,55,70,80);

Insert into tnilai values ('KKKI53012','07101152610256',80,65,80,90);

Insert into tnilai values ('KKKI52005','07101152610256',90,75,90,60);

Insert into tnilai values ('KKKI52006','07101152610256',60,65,80,70);

Insert into tnilai values ('KKKI53007','07101152610256',70,55,90,80);

Insert into tnilai values ('KKKI53001','07101152610257',80,75,60,60);

Insert into tnilai values ('KKKI52002','07101152610257',80,85,65,75);

Insert into tnilai values ('KKKI53011','07101152610257',70,55,70,80);

Insert into tnilai values ('KKKI53012','07101152610257',80,65,80,90);

Insert into tnilai values ('KKKI52005','07101152610257',90,75,90,60);

Insert into tnilai values ('KKKI52006','07101152610257',60,65,80,70);

Insert into tnilai values ('KKKI53007','07101152610257',70,55,90,80);

Insert into tnilai values ('KKKI53001','07101152610258',80,75,60,60);

Insert into tnilai values ('KKKI52002','07101152610258',80,85,65,75);

Insert into tnilai values ('KKKI53011','07101152610258',70,55,70,80);

Insert into tnilai values ('KKKI53012','07101152610258',80,65,80,90);

Insert into tnilai values ('KKKI52005','07101152610258',90,75,90,60);

Insert into tnilai values ('KKKI52006','07101152610258',60,65,80,70);

Insert into tnilai values ('KKKI53007','07101152610258',70,55,90,80);



select * from tnilai;