LAPORAN PRAKTIKUM

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