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