Nama : Dhaniar Ruandha Putri
NPM : 19.1.03.02.0078
Kelas : 2C
KUIS PRA-UTS
create database toko_sepatu;
use toko_sepatu;
create table sepatu(
-> kd_sepatu int(3) PRIMARY KEY NOT NULL,
-> merk VARCHAR(10) NOT NULL,
-> stok int(3) NOT NULL,
-> ukuran int(2) NOT NULL);
create table pembeli(
-> id_pembeli int(2) PRIMARY KEY NOT NULL,
-> nama VARCHAR(20) NOT NULL,
-> kd_sepatu int(3) NOT NULL,
-> alamat VARCHAR(10) NOT NULL);
INSERT INTO sepatu VALUES(001,"ADIDAS",50,40);
INSERT INTO sepatu VALUES(002,"ADIDAS",50,41);
INSERT INTO sepatu VALUES(003,"ADIDAS",50,42);
INSERT INTO sepatu VALUES(004,"ADIDAS",50,43);
INSERT INTO sepatu VALUES(005,"NIKE",50,40);
INSERT INTO sepatu VALUES(006,"NIKE",50,41);
INSERT INTO sepatu VALUES(007,"NIKE",50,42);
INSERT INTO sepatu VALUES(008,"NIKE",50,43);
INSERT INTO pembeli VALUES(01,"ROY",002,"Jombang");
INSERT INTO pembeli VALUES(02,"JOY",006,"Kediri");
INSERT INTO pembeli VALUES(03,"RIO",008,"Kediri");
desc sepatu;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| kd_sepatu | int(3) | NO | PRI | NULL | |
| merk | varchar(10) | NO | | NULL | |
| stok | int(3) | NO | | NULL | |
| ukuran | int(2) | NO | | NULL | |
+-----------+-------------+------+-----+---------+-------+
desc pembeli;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id_pembeli | int(2) | NO | PRI | NULL | |
| nama | varchar(20) | NO | | NULL | |
| kd_sepatu | int(3) | NO | | NULL | |
| alamat | varchar(10) | NO | | NULL | |
+------------+-------------+------+-----+---------+-------+
SELECT *FROM sepatu;
+-----------+--------+------+--------+
| kd_sepatu | merk | stok | ukuran |
+-----------+--------+------+--------+
| 1 | ADIDAS | 50 | 40 |
| 2 | ADIDAS | 50 | 41 |
| 3 | ADIDAS | 50 | 42 |
| 4 | ADIDAS | 50 | 43 |
| 5 | NIKE | 50 | 40 |
| 6 | NIKE | 50 | 41 |
| 7 | NIKE | 50 | 42 |
| 8 | NIKE | 50 | 43 |
+-----------+--------+------+--------+
SELECT *FROM pembeli;
+------------+------+-----------+---------+
| id_pembeli | nama | kd_sepatu | alamat |
+------------+------+-----------+---------+
| 1 | ROY | 2 | Jombang |
| 2 | JOY | 6 | Kediri |
| 3 | RIO | 8 | Kediri |
+------------+------+-----------+---------+
UPDATE pembeli SET nama = "JOKO" WHERE id_pembeli = 3;
SELECT *FROM pembeli;
+------------+------+-----------+---------+
| id_pembeli | nama | kd_sepatu | alamat |
+------------+------+-----------+---------+
| 1 | ROY | 2 | Jombang |
| 2 | JOY | 6 | Kediri |
| 3 | JOKO | 8 | Kediri |
+------------+------+-----------+---------+
DELETE FROM sepatu WHERE kd_sepatu = 008;
SELECT *FROM sepatu;
+-----------+--------+------+--------+
| kd_sepatu | merk | stok | ukuran |
+-----------+--------+------+--------+
| 1 | ADIDAS | 50 | 40 |
| 2 | ADIDAS | 50 | 41 |
| 3 | ADIDAS | 50 | 42 |
| 4 | ADIDAS | 50 | 43 |
| 5 | NIKE | 50 | 40 |
| 6 | NIKE | 50 | 41 |
| 7 | NIKE | 50 | 42 |
+-----------+--------+------+--------+
Komentar
Posting Komentar