LAPORAN DATABASE

B. One to Many

           PEGAWAI --------- memiliki ---------- GOLONGAN
  - NIP                                                               - Kd_gol
  - Nama                                                            - Nama_gol
  - Alamat
  - Jns_klmn
  - Kd_gol
 


create database golongan
use golongan
create table golongan (
Kd_gol char ( 3 ) not null primary key ,
Nama_gol char ( 4 ))
select * from golongan
insert into golongan values ( 'A01','IIIA' )
insert into golongan values ( 'A02','IIIB' )
insert into golongan values ( 'A03','IIIC' )

create table pegawai (
Nip char ( 10 ) not null primary key ,
Nama varchar ( 20 ) ,
Alamat varchar ( 20 ) ,
Jns_klmn char ( 1 ) ,

constraint f_pegawai foreign key ( Kd_gol ) references golongan ( Kd_gol ))
select * from pegawai
insert into pegawai values ( '0001','Saliyanto','Jln.Seram','L','A01' )
insert into pegawai values ( '0002','Yanti','Jln.Madu','P','A02' )
insert into pegawai values ( '0003','Erick','Jln.Obor','L','A03' )
select * from golongan
select * from pegawai

LAPORAN DATABASE

           DIAGRAM ERD ( Entity Relationship Diagram )

A.Hubungan 1 banding 1 ( One to One )

           PEGAWAI --------- memiliki ---------- JABATAN
  - NIP                                                               - Kd_jab
  - Nama                                                            - Nama_jab
  - Jns_klmn
  - Agama
  - Status
  - Kd_jab


create database jabatan
use jabatan
create table jabatan (
Kd_jab char ( 5 ) not null primary key ,
Nama_jab varchar ( 20 ))
select * from jabatan
insert into jabatan values ( '01','Direktur' )
insert into jabatan values ( '02','Sekretaris' )

create table pegawai (
Nip char ( 10 ) not null primary key ,
Nama varchar ( 20 ) ,
Jns_klmn char ( 1 ) ,
Agama varchar ( 10 ) ,
Status varchar ( 10 ) ,
Kd_jab char ( 5 ) ,
constraint f_pegawai foreign key ( Kd_jab ) references jabatan ( Kd_jab ))
select * from pegawai
insert into pegawai values ( '0001','Dian','P','Islam','Menikah','01' )
insert into pegawai values ( '0002','Miko','L','Kristen','Single','02' )
select * from jabatan
select * from pegawai