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