Minggu, 22 April 2012
Senin, 16 April 2012
Tugas Praktek Sistem Basis Data
NPM : 201043501220
Nama : Anton Sumanjaya
Kelas : S4O
Dosen : Nahot Frastian, S.Kom
Teknik Informatika
Universitas Indraprasta PGRI
Nama : Anton Sumanjaya
Kelas : S4O
Dosen : Nahot Frastian, S.Kom
Teknik Informatika
Universitas Indraprasta PGRI
Membuat Database dan tabel
Nama Database : Mahasiswa
Sintak :
Create Database 'mahasiswa';
Nama Tabel : Penilaian
Sintak :
Create table penilaian (nim int(8), KdMK varchar(5) null, NamaMK varchar(25) null, Mid float(5) null, Final float(5) null, NilRata float(5) null);
Nama Database : Karyawan
Sintak :
Create Database 'karyawan';
Nama Tabel : Identitas
Sintak :
CREATE TABLE `karyawan`.`identitas` (`nip` INT(7) NOT NULL, `nama_karyawan` VARCHAR(25) NOT NULL, `alamat` VARCHAR(55) NOT NULL, `tgl_lahir` DATE NOT NULL, `jabatan` VARCHAR(15) NOT NULL, `kota` VARCHAR(10) NOT NULL, `gaji` INT(10) NOT NULL, PRIMARY KEY (`nip`)) ENGINE = MyISAM;
Nama Database : Penjualan
Sintak :
Create Database 'penjualan';
Nama Tabel : barang
Sintak :
CREATE TABLE `penjualan`.`barang` (
`kode_barang` VARCHAR( 4 ) NOT NULL ,
`nama_barang` VARCHAR( 25 ) NOT NULL ,
`satuan` VARCHAR( 20 ) NOT NULL ,
`harga` INT NOT NULL ,
PRIMARY KEY ( `kode_barang` )
`nama_barang` VARCHAR( 25 ) NOT NULL ,
`satuan` VARCHAR( 20 ) NOT NULL ,
`harga` INT NOT NULL ,
PRIMARY KEY ( `kode_barang` )
) ENGINE = MYISAM ;
Menyisipkan Isi
Sintak :
INSERT INTO `penjualan`.`barang` (`kode_barang`, `nama_barang`, ‘satuan`, `harga`) VALUES ('A001', 'Saus ABC 100ml', 'Botol', '6000'), ('A002', 'Attack 2kg', 'Bungkus', '20000'), ('A003', 'Pulpen Faster', 'Benda', '2000'), ('A004', 'Clink ',
'Botol', '12000');
Nama Database : Transaksi
Sintak :
Create Database 'transaksi';
Nama Tabel: costumer
Sintak :
CREATE TABLE `TRANSAKSI`.`COSTUMER` (`KODE_TRANSAKSI`
VARCHAR(10) NOT NULL, `ID_COSTUMER`VARCHAR(10) NOT NULL, `KODE_BARANG` VARCHAR(5) NOT NULL, `NAMA_BARANG` VARCHAR(20) NOT NULL, `TGL_TRANSAKSI` DATE NOT NULL, PRIMARY KEY (`ID_COSTUMER`)) ENGINE = MYISAM;
VARCHAR(10) NOT NULL, `ID_COSTUMER`VARCHAR(10) NOT NULL, `KODE_BARANG` VARCHAR(5) NOT NULL, `NAMA_BARANG` VARCHAR(20) NOT NULL, `TGL_TRANSAKSI` DATE NOT NULL, PRIMARY KEY (`ID_COSTUMER`)) ENGINE = MYISAM;
Menyisipkan Isi
- Pada database mahasiswa dan tabel penilaian
INSERT INTO `trt`.`penilaian` (`nim`, `KdMK`, `NamaMK`, `Mid`,
`Final`, `NilRata`)VALUES
('10296832', 'KK021', 'Sistem Basis Data', '75', '82', '78.5'),
('10297732', 'KD132', 'SIM', '77.5', '73.5', '75.5'), ('20216832',
'KK021', 'Sistem Basis Data', '83.5', '81.7', '82.'),
('30216832', 'KU122', 'Pancasila', '65.4', '77', '71.2'),
('11297732', 'KK021', 'Sistem Basis Data', '79.5', '82.5', '81'),
('21216832', 'KD132', 'SIM', '80', '83', '81.75'),
('31216832', 'KK021', 'Sistem Basis Data', '67', '78', '72.5')
Menampilkan Seluruh Record Mahasiswa yang Berkode KK021
Sintak :
Select * from penilaian where kdmk=’kk021’;
Menampilkan record field Nim,KdMK dan Mid saja bagi yang nilai mid-nya antara 75 dan 90
Sintak :
Select nim, kdmk, mid from penilaian where mid >= 75 and mid <= 90;
Hapus record yang memiliki Nim = 10296832!
Sintak :
Delete from penilaian where nim = 10296832;
Mencari Total Nilai Keseluruhan
Sintak :
select sum(mid) as Total_Mid from penilaian;
Menampilkan Total Record
Sintak :
select count(*) as Jumlah_Record from penilaian;
Mencari Nilai Rata-Rata
Sintak :
Select AVG(Final) as ‘Rata-rata_Final’ from penilaian;
Mencari Nilai Tertinggi
Sintak :
select max(final) as Nilai_Final_Tertinggi from penilaian;
Mencari Nilai Terendah
Sintak :
select min(mid) as Nilai_Mid_Terendah from penilaian;
Langganan:
Postingan (Atom)