Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP DATABASE IF EXISTS db18k10062;
- CREATE DATABASE db18k10062;
- USE db18k10062;
- CREATE TABLE tblMobil(
- noplat varchar(8) primary key,
- mobil varchar(30),
- tarifperjam double
- );
- CREATE TABLE tblPenyewa(
- noid int primary key,
- nama varchar(20),
- alamat varchar(30)
- );
- CREATE TABLE tblSewa(
- noplat varchar(8),
- noid int,
- jamsewa int,
- biayaperjam double
- FOREIGN KEY (noplat) REFERENCES tblMobil(noplat),
- FOREIGN KEY (noid) REFERENCES tblPenyewa(noid)
- );
- INSERT INTO tblMobil VALUES
- ('H 9234 A','Avanza','25000'),
- ('H 9235 A','Xenia','25000'),
- ('H 9237 A','Ertiga','30000'),
- ('H 9434 A','Panther','35000'),
- ('H 9534 A','Livina','30000'),
- ('H 9634 A','Innova','35000'),
- ('H 9734 A','Terios','27500');
- INSERT INTO tblPenyewa VALUES
- ('1','Denny','Jl Mataram 32'),
- ('2','Linda','Jl Soedirman 02'),
- ('3','Petra','Jl A Yani 99'),
- ('4','Vania','Jl Let Jend Soeprapto 153'),
- ('5','Deborah','Jl Katamso 55'),
- ('6','Benny','Jl A Yani 678'),
- ('7','Yanny','Jl Mataram 982'),
- ('8','Ditta','Jl Majapahit 1227'),
- ('9','Anna','Jl DI Panjaitan 552'),
- ('10','Venda','Jl Hasanudin 97');
- INSERT INTO tblSewa VALUES
- ('H 9235 A','9','6','25000'),
- ('H 9237 A','4','3','30000'),
- ('H 9434 A','1','5','35000'),
- ('H 9534 A','5','8','30000'),
- ('H 9634 A','6','5','35000'),
- ('H 9734 A','6','6','27500'),
- ('H 9234 A','1','10','25000'),
- ('H 9235 A','4','3','25000'),
- ('H 9237 A','2','2','30000'),
- ('H 9434 A','5','5','35000'),
- ('H 9534 A','9','1','30000'),
- ('H 9634 A','7','1','35000'),
- ('H 9734 A','4','8','27500'),
- ('H 9234 A','6','9','25000'),
- ('H 9235 A','7','7','25000'),
- ('H 9237 A','4','8','30000'),
- ('H 9434 A','7','4','35000'),
- ('H 9534 A','7','2','30000'),
- ('H 9634 A','9','9','35000'),
- ('H 9734 A','7','2','27500');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement