Create Tabel

Tabel Karyawan

Nip	Nama	Alamat	Golongan
10101	Rahayu	Bantar gebang	I
10102	Wardatul Janah	Pondok kopi	II
10103	Tri Anggun Mulyati	Pekayon	III
10104	Listiani Dewi	Tambun	II
10105	Nammeta Riski	Cakung	III
10106	Fikry Ardiansah	Cikarang	II
10107	Rangga	Bekasi	III
10108	Hamdi	Pondok indah	I
10109	Ayu	Harapan kita	I
101010	Tata	Babakan	II

Create tabel karyawan

( Nip,               char (5) not null,

Nama               char (50) not null,

Alamat                        char (20) ,

Golongan        char (5) ,

Primary key     (nip))

à ( 10101 rahayu bantargebang I )

( Nip,               char (5) not null,

Nama               char (50) not null,

Alamat                        char (20) ,

Golongan        char (5) ,

Primary key     (nip))

à ( 10102 wardatul janah pondok kopi II )

( Nip,               char (5) not null,

Nama               char (50) not null,

Alamat                        char (20) ,

Golongan        char (5) ,

Primary key     (nip))

à ( 10103 tri anggun mulyati pekayon III )

( Nip,               char (5) not null,

Nama               char (50) not null,

Alamat                        char (20) ,

Golongan        char (5) ,

Primary key     (nip))

à ( 10104 listiani dewi tambun II)

( Nip,               char (5) not null,

Nama               char (50) not null,

Alamat                        char (20) ,

Golongan        char (5) ,

Primary key     (nip))

à ( 10105 nammeta riski cakung III )

( Nip,               char (5) not null,

Nama               char (50) not null,

Alamat                        char (20) ,

Golongan        char (5) ,

Primary key     (nip))

à ( 10106 fikri ardiansyah cikarang II )

( Nip,               char (5) not null,

Nama               char (50) not null,

Alamat                        char (20) ,

Golongan        char (5) ,

Primary key     (nip))

à ( 10107 rangga bekasi III )

( Nip,               char (5) not null,

Nama               char (50) not null,

Alamat                        char (20) ,

Golongan        char (5) ,

Primary key     (nip))

à ( 10108 hamdi pondok indah I )

( Nip,               char (5) not null,

Nama               char (50) not null,

Alamat                        char (20) ,

Golongan        char (5) ,

Primary key     (nip))

à ( 10109 ayu harapan kita I )

( Nip,               char (5) not null,

Nama               char (50) not null,

Alamat                        char (20) ,

Golongan        char (5) ,

Primary key     (nip))

à ( 101010 tata babakan II )

Tabel penggajian

No	Nama	Jabatan	Gaji	Alamat	Golongan
121	Romi	Admint	1.500.000	Galaksi	III
122	Charli	Enginner	2.500.000	Pondok hijau	II
123	Alan	Operator	2.300.000	Padurenan	II
124	Giring	Programmer	3.000.000	Anggrek	I
125	Vivin	Finance	2.200.000	Bantargebang	I
126	Marina	Logistic	3.200.000	Kemang	I
127	Ita	Marketing	2.900.000	Rawalumbu	II
128	Nurarianti	Supervisor	2.500.000	Jatiasih	II
129	Riri	Team leadger	3.100.000	Jatimulya	I
130	Rosi	Staff	2.800.000	Pendawa	II

Create tabel penggajian

( No,                char (5) not null,

Nama               char (50) not null,

Jabatan            char (20),      

Gaji                 number (20),

Alamat                        char (20) ,

Golongan        char (5) ,

Foreign  key    (no))

à ( 121 romi admint 1.500.000 galaksi III )

( No,                char (5) not null,

Nama               char (50) not null,

Jabatan            char (20),      

Gaji                 number (20),

Alamat                        char (20) ,

Golongan        char (5) ,

Foreign  key    (no))

à ( 122 charli engginner 2.500.000 pondok hijau II )

( No,                char (5) not null,

Nama               char (50) not null,

Jabatan            char (20),      

Gaji                 number (20),

Alamat                        char (20) ,

Golongan        char (5) ,

Foreign  key    (no))

à ( 123 alan operator 2.300.000 padurenan II )

( No,                char (5) not null,

Nama               char (50) not null,

Jabatan            char (20),      

Gaji                 number (20),

Alamat                        char (20) ,

Golongan        char (5) ,

Foreign  key    (no))

à ( 124 giring programmer 3.000.000 anggrek I )

( No,                char (5) not null,

Nama               char (50) not null,

Jabatan            char (20),      

Gaji                 number (20),

Alamat                        char (20) ,

Golongan        char (5) ,

Foreign  key    (no))

à ( 125 vivin finance 2.200.000 bantargebang I )

( No,                char (5) not null,

Nama               char (50) not null,

Jabatan            char (20),      

Gaji                 number (20),

Alamat                        char (20) ,

Golongan        char (5) ,

Foreign  key    (no))

à ( 126 marina logistic 3.200.000 kemang I )

( No,                char (5) not null,

Nama               char (50) not null,

Jabatan            char (20),      

Gaji                 number (20),

Alamat                        char (20) ,

Golongan        char (5) ,

Foreign  key    (no))

à ( 127 ita marketing 2.900.0000 rawalumbu II )

( No,                char (5) not null,

Nama               char (50) not null,

Jabatan            char (20),      

Gaji                 number (20),

Alamat                        char (20) ,

Golongan        char (5) ,

Foreign  key    (no))

à ( 128 nurarianti supervisor 2.500.000 jatiasih  II )

( No,                char (5) not null,

Nama               char (50) not null,

Jabatan            char (20),      

Gaji                 number (20),

Alamat                        char (20) ,

Golongan        char (5) ,

Foreign  key    (no))

à ( 129  riri team leadger 3.100.000 jatimulya I )

( No,                char (5) not null,

Nama               char (50) not null,

Jabatan            char (20),      

Gaji                 number (20),

Alamat                        char (20) ,

Golongan        char (5) ,

Foreign  key    (no))

à ( 130 rosi staff 2.800.000 pendawa II )