Laporan Praktikum Admisitrasi basis data

Laporan Praktikum

Administrasi Basis Data 2

Nama         :Isnawaty Ibrahim

Nim            :131314018

create table Mahasiwa (

NIM char (15) NOT NULL,

nama varchar (15),

alamat varchar (20),

CONSTRAINT pk_NIM PRIMARY KEY (NIM)

Create table Dosen (

      Id_Dos char (20) NOT NULL,

      Nama_Dos varchar varchar (20) ,

      Alamt varchar (20),

CONSTRAINT pk_NIM PRIMARY KEY (NIM)

Dosen punya

insert into dosen (id_dos, nama_dos, alamat)

values ('IM0108','Ismail_Mohidin','jl,selayar');

insert into dosen (id_dos, nama_dos, alamat)

values ('HG0206','Hilmansya_Gani','jl,Duku.no,10a');

insert into dosen (id_dos, nama_dos, alamat)

values ('HG0206',Fajar_Hermawanto','jl,Rambutan.no,10a');

Mahasiswa  punya

insert into Mahasiswa (NIM,nama,alamat)

values ('1313140119','Fatmah','jl,ka_Kos');

insert into Mahasiswa (NIM,nama,alamat)

values ('1313140115','Hariyono','jl,ka_aspura'

insert into Mahasiswa (NIM,nama,alamat)

values ('1313140179','Irvan_Yunus','jl,ka_Rumah'

insert into Mahasiswa (NIM,nama,alamat)

values ('131314021','Ilyas','jl,ka_Aspura'

insert into Mahasiswa (NIM,nama,alamat)

values ('313140118','isnawaty','jl,blok_plan’),