One To One

One To One

create database perusahaan

create table jabatan(

        kd_jabatan char(12)not null primary key,

        Nm_jabatan varchar(20))

select*from jabatan

create table pegawai(

        NIP char(12)not null primary key,

        nama varchar(20),

        Agama varchar(10),

        JNS_kelamin char(1),

        kd_jabatan char(12)references jabatan(kd_Jabatan))

        alter table pegawai add alamat varchar(20)

select*from pegawai

insert into jabatan values('201202030040','Direktur')

insert into jabatan values('201202030041','Personalia')

insert into jabatan values('201202030042','Marketing')

insert into pegawai values('201202030050','Anto','Islam','L','201202030040','JL.asahan')

insert into pegawai values('201202030051','Muhammad','Islam','L','201202030041','JL.Jawa')