Pertemuan VI

Create database Pegawai
Use Pegawai

Create table Golongan(
Kd_Golongan char(5)primary key,
Nama_Golongan Varchar(30))

Select * from Golongan

Create table Pegawai(
Nip_Pegawai Varchar(10)primary key,
Nama_Pegawai Varchar(30),
Jns_Kelamin_Pegawai Char(1),
Kd_Golongan char(5)
Constraint F_Pegawai Foreign Key(Kd_Golongan)
References Golongan (Kd_Golongan))

Select * from Pegawai

Insert Into Golongan Values ('G001','IIIA')
Insert Into Golongan Values ('G002','IIIB')

Insert Into Pegawai Values ('00001','Nita','P','G001')
Insert Into Pegawai Values ('00002','Nina','P','G001')
Insert Into Pegawai Values ('00003','Nino','L','G002')
Insert Into Pegawai Values ('00004','Nini','P','G002')

Tweet