create database kepegawaian
use kepegawaian
create table jabatan (
kdjabatan
char (4) not null primary key,
namajabatan
varchar (10))
select * from jabatan
insert into jabatan values ('1234','Direktur')
insert into jabatan values ('1235','manager')
insert into jabatan values ('1236','sekretaris')
create table pegawai (
NIP
char (12) not null primary key,
NAMA
varchar (10),
ALAMAT
varchar (15),
JNS_KLMN
char (1),
AGAMA
varchar (10),
kdjabatan
char (4) references jabatan (kdjabatan))
select * from pegawai
insert into pegawai values
('201201030171','Dian','jln.karya','L','Islam','1234')
insert into pegawai values
('201201030177','Martin','jln.mangga','L','Kristen','1235')
insert into pegawai
values ('201201030175','Frans','jln.cebong','L','Kristen','1236')
select * from pegawai cross join jabatan
Tidak ada komentar:
Posting Komentar