Laporan Praktikum

LAPORAN PRAKTIKUM

create database persediaan

use persediaan

create table barang(

       kdbarang char(4),

       Nama_brg varchar(30),

       Jumlah int)

select*from barang

insert into barang values('B001','Buku','10')

insert into barang values('B002','Pulpen','9')

insert into barang values('B003','Spidol','15')

insert into barang values('B004','Penggaris','21')

select count (*) from barang

select avg (jumlah) from barang

select max (jumlah) from barang

select min (jumlah) from barang

select floor(-496.45)

select floor($49.45)

select Round (224.9980,1)

select Round (224.9980,2)

select Round (224.9980,3)

select Round (224.9980,4)

SENIN, 10 JUNI 2013

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