create database tender;
use tender;
create table pegawai(
nip varchar(5) NOT NULL PRIMARY KEY,
nama varchar(30) NOT NULL,
alamat varchar(30) NOT NULL,
jenis_kelamin varchar(30) NOT NULL);
create table proyek(
Kode_proyek varchar(5) NOT NULL,
nama_proyek varchar(20) NOT NULL,
nip varchar(5) NOT NULL,
Primary Key (Kode_proyek, nip));
create table lokasi(
Kode_lokasi varchar(5) NOT NULL,
nama_lokasi varchar(25) NOT NULL,
kode_proyek varchar(5) NOT NULL,
nip varchar(5) NOT NULL,
Primary Key (kode_lokasi, Kode_proyek, nip));
insert into pegawai values
('001','kiki','semarang','perempuan'),
('002','mila','bandung','perempuan'),
('003','ardi','medan','laki-laki'),
('004','permana','jakarta','laki-laki'),
('005','hendra','semarang','laki-laki'),
('006','lilin','bandung','perempuan');
insert into proyek values
('p01','jalan raya','001'),
('p02','jembatan','003'),
('p03','perumahan','004'),
('p04','pasar','005'),
('p05','jalan tol','006'),
('p06','tanggul sungai','007');
insert into lokasi values
('l01','semarang','p01','001'),
('l02','bandung','p05','007'),
('l03','medan','p06','006'),
('l04','semarang','p03','002'),
('l05','jakarta','p04','005');
SELECT pegawai.nip, pegawai.nama, pegawai.alamat, pegawai.jenis_kelamin
FROM pegawai, proyek
where pegawai.nip = proyek.nip and proyek.nama_proyek='jalan tol';
SELECT pegawai.nip, pegawai.nama, pegawai.alamat, pegawai.jenis_kelamin
FROM pegawai, proyek
where pegawai.nip = proyek.nip and proyek.nama_proyek='perumahan'
and pegawai.jenis_kelamin='laki-laki';
SELECT pegawai.nip, pegawai.nama, pegawai.alamat, pegawai.jenis_kelamin
FROM pegawai, proyek, lokasi
where pegawai.nip = proyek.nip and proyek.nama_proyek='pasar'
and lokasi.nama_lokasi='jakarta';
select pegawai.nip,pegawai.nama,pegawai.alamat,pegawai.jenis_kelamin,
proyek.nama_proyek,lokasi.nama_lokasi
from proyek natural join pegawai natural join lokasi where pegawai.alamat=lokasi.nama_lokasi;
select pegawai.nip,pegawai.nama,pegawai.alamat,pegawai.jenis_kelamin,
proyek.nama_proyek,lokasi.nama_lokasi
from proyek natural join pegawai natural join lokasi where pegawai.nama='Hendra';
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon