Create
Database Kepegawaian
Use
Kepegawaian
Create Table
Jabatan (
Kode_Jabatan char (4) not null Primary
Key,
Nama_Jabatan char (20))
SELECT * FROM
Jabatan
Create Table
Kota (
Kode_Kota char (3) not null Primary Key,
Nama_Kota char (25))
SELECT * FROM
Kota
Create Table
Pegawai (
NIP char (4) not null Primary Key,
Nama_Pegawai char (25),
Alamat char (30),
Kode_Kota char (3) references Kota
(Kode_Kota),
Kode_Jabatan char (4) references Jabatan
(Kode_Jabatan),
Gaji int )
SELECT * FROM
Pegawai
Create Table
Absensi (
NIP char (4) references Pegawai (NIP),
Bulan tinyint,
Jlh_Masuk int )
SELECT * FROM
Absensi
Insert Into
Jabatan Values ('011', 'Programer')
Insert Into
Jabatan Values ('002', 'Operator')
Insert Into
Jabatan Values ('003', 'System Analis')
Insert Into
Jabatan Values ('004', 'Pimpinan Proyek')
SELECT * FROM
Jabatan
Insert Into
Kota Values ('BDG', 'Bandung')
Insert Into
Kota Values ('JKT', 'Jakarta')
Insert Into
Kota Values ('CRB', 'Cirebon')
Insert Into
Kota Values ('DIY', 'Yogyakarta')
SELECT * FROM
Kota
Insert Into
Pegawai Values ('111','Totok','Jln.Ganesha','BDG','011',700000)
Insert Into Pegawai
Values ('222','Udin','Jln.Thamrin','JKT','002',500000)
Insert Into
Pegawai Values ('333','Budi','Jln.Kalasan','DIY','003',1500000)
Insert Into
Pegawai Values ('444','Ahmad','Jln.Tamansari','BDG','004',1000000)
Update Pegawai
Set Gaji = '700000' Where NIP = '111'
SELECT * FROM
Pegawai
Insert Into
Absensi Values ('111','1','22')
Insert Into
Absensi Values ('222','1','21')
Insert Into
Absensi Values ('333','1','21')
Insert Into
Absensi Values ('444','1','20')
Insert Into
Absensi Values ('111','2','20')
Insert Into
Absensi Values ('222','2','21')
Insert Into
Absensi Values ('333','2','23')
Insert Into
Absensi Values ('444','2','20')
Insert Into
Absensi Values ('111','3','22')
Insert Into
Absensi Values ('222','3','20')
Insert Into
Absensi Values ('333','3','21')
Insert Into
Absensi Values ('444','3','18')
Insert Into
Absensi Values ('111','4','19')
Insert Into
Absensi Values ('222','4','21')
Insert Into
Absensi Values ('333','4','20')
Insert Into
Absensi Values ('444','4','20')
SELECT * FROM
Absensi