The screenshot of the Query and the results below is from the question of each number, and saved with the file name: UAS_NIM.docx or UAS_NIM.pdf Create database : - Show the date of the transaction that sells the red shoes - Show the name of the shoe purchased by the customer who has a name with the 2nd character 5 being a vowel - Show the name of the supplier who sells shoes at prices below the average shoe price Jenis_Sepatu: INSERT INTO Jenis_Sepatu values('S-01', 'Sepatu Lari'); INSERT INTO Jenis_Sepatu values('S-02', 'Sepatu Basket'); INSERT INTO Jenis_Sepatu values('S-03', 'Sepatu Soccer'); Supplier:  INSERT INTO SUPPLIER Values('MA', 'PT. MitraAdi', 'Jl. Monginsidi 87'); INSERT INTO SUPPLIER Values('SO', 'PT. Shakti Omega', 'Jl. Sudirman 23'); INSERT INTO SUPPLIER Values('SS', 'PT. Sport Station', 'Jl. GunungKelud 8');   Merek: INSERT INTO Merek values('AS', 'Adidas','MA'); INSERT INTO Merek values('DA', 'Diadora','SS'); INSERT INTO Merek values('PA', 'Puma','SO'); INSERT INTO Merek values('RK', 'Reebok','SS'); Customer:   INSERT INTO Customer values( 'C-01', 'Adi Kurniawan', 'Jl. Sawentan 48', 'Jakarta'); INSERT INTO Customer values( 'C-02', 'Linda Pujiastuti', 'Jl. Kuda Nil 87', 'Surabaya'); INSERT INTO Customer values( 'C-03', 'Sarbans Edi', 'Jl. Cendrawasih 6', 'Medan'); INSERT INTO Customer values( 'C-04', 'Micheal Budi', 'Jl. Ciliwung 32', 'Semarang');   Sepatu: INSERT INTO Sepatu values( 'FT', 'Flynit', 'S-03', 'DA', 42, 485000 , 'Merah'); INSERT INTO Sepatu values( 'HE', 'Hyperfose', 'S-01', 'RK', 41, 675000 , 'Putih'); INSERT INTO Sepatu values( 'SN', 'Slip On', 'S-02', 'PA', 44, 390000 , 'Biru'); INSERT INTO Sepatu values( 'ML', 'Max Cool', 'S-03', 'AS', 43, 535000 , 'Ungu'); Jenis_Transaksi Insert into Jenis_Transaksi values('KT', 'Kredit'); Insert into Jenis_Transaksi values('TI', 'Tunai'); Transaksi Insert into Transaksi values('2015-01-02', 'C-02', 'SN', 1, 'TI', 390000); Insert into Transaksi values('2015-01-03', 'C-04', 'ML', 2, 'KT', 1070000); Insert into Transaksi values('2015-01-04', 'C-01', 'HE', 1, 'KT', 675000); Insert into Transaksi values('2015-01-05', 'C-03', 'FT', 2, 'TI', 970000); Insert into Transaksi values('2015-01-06', 'C-02', 'HE', 1, 'KT', 675000);

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

The screenshot of the Query and the results below is from the question of each number, and saved with the file name: UAS_NIM.docx or UAS_NIM.pdf

Create database :

- Show the date of the transaction that sells the red shoes
- Show the name of the shoe purchased by the customer who has a name with the 2nd character 5 being a vowel
- Show the name of the supplier who sells shoes at prices below the average shoe price

Jenis_Sepatu:

INSERT INTO Jenis_Sepatu values('S-01', 'Sepatu Lari');
INSERT INTO Jenis_Sepatu values('S-02', 'Sepatu Basket');
INSERT INTO Jenis_Sepatu values('S-03', 'Sepatu Soccer');

Supplier: 

INSERT INTO SUPPLIER Values('MA', 'PT. MitraAdi', 'Jl. Monginsidi 87');
INSERT INTO SUPPLIER Values('SO', 'PT. Shakti Omega', 'Jl. Sudirman 23');
INSERT INTO SUPPLIER Values('SS', 'PT. Sport Station', 'Jl. GunungKelud 8');

 

Merek:

INSERT INTO Merek values('AS', 'Adidas','MA');
INSERT INTO Merek values('DA', 'Diadora','SS');
INSERT INTO Merek values('PA', 'Puma','SO');
INSERT INTO Merek values('RK', 'Reebok','SS');

Customer:

 

INSERT INTO Customer values( 'C-01', 'Adi Kurniawan', 'Jl. Sawentan 48', 'Jakarta');
INSERT INTO Customer values( 'C-02', 'Linda Pujiastuti', 'Jl. Kuda Nil 87', 'Surabaya');
INSERT INTO Customer values( 'C-03', 'Sarbans Edi', 'Jl. Cendrawasih 6', 'Medan');
INSERT INTO Customer values( 'C-04', 'Micheal Budi', 'Jl. Ciliwung 32', 'Semarang');

 

Sepatu:

INSERT INTO Sepatu values( 'FT', 'Flynit', 'S-03', 'DA', 42, 485000 , 'Merah');
INSERT INTO Sepatu values( 'HE', 'Hyperfose', 'S-01', 'RK', 41, 675000 , 'Putih');
INSERT INTO Sepatu values( 'SN', 'Slip On', 'S-02', 'PA', 44, 390000 , 'Biru');
INSERT INTO Sepatu values( 'ML', 'Max Cool', 'S-03', 'AS', 43, 535000 , 'Ungu');

Jenis_Transaksi

Insert into Jenis_Transaksi values('KT', 'Kredit');
Insert into Jenis_Transaksi values('TI', 'Tunai');

Transaksi

Insert into Transaksi values('2015-01-02', 'C-02', 'SN', 1, 'TI', 390000);
Insert into Transaksi values('2015-01-03', 'C-04', 'ML', 2, 'KT', 1070000);
Insert into Transaksi values('2015-01-04', 'C-01', 'HE', 1, 'KT', 675000);
Insert into Transaksi values('2015-01-05', 'C-03', 'FT', 2, 'TI', 970000);
Insert into Transaksi values('2015-01-06', 'C-02', 'HE', 1, 'KT', 675000);

Tabel Jenis Sepatu
Tabel Merek
Kode Jenis Sepatu Varchar (10) --> PK
Kode Merek Varchar (10) -
--> PK
Nama Jenis Sepatu Varchar (25) --> NN
Nama Merek Varchar (30) --> NN
Kode Suplier references tabel suplier
Tabel Sepatu
Kode Sepatu Varchar (10) -
--> PK
Tabel Suplier
Nama Sepatu Varchar (40) --
> NN
Kode Suplier Varchar (10) -
-> PK
Kode Jenis Sepatu references Tabel Jenis Sepatu
Nama Suplier Varchar (30) --> NN
Kode Merek references Tabel Merek
Alamat Suplier Varchar (40) --
> NN
Size Int --> NN
Harga Money --> NN
Tabel Customer
Tabel Transaksi
Kode Customer Varchar (10) --> PK
Tanggal Transaksi date
--> PK
Nama Customer Varchar (30) --> NN
Kode Customer references Tabel Customer --> PK
Alamat Customer Varchar (40) --> NN
Kota Customer Varchar (20) --> NN
Kode Sepatu references Tabel Sepatu
Jumlah Sepatu Int --> NN
Kode Jenis Transaksi references Tabel Jenis Transaksi
Tabel Jenis Transaksi
Jumlah Pembayaran Int --> NN
Kode Jenis Transaksi Varchar (10) --> PK
Nama Jenis Transaksi Varchar (30) --> NN
Tabel Jenis Sepatu
Tabel Merek
Kode Jenis Sepatu
Nama Jenis Sepatu
Kode Merek
Nama Merek
Kode Suplier
Sepatu Lari
Sepatu Basket
S-01
AS
Adidas
МА
S-02
DA
Diadora
SS
S-03
Sepatu Soccer
PA
Puma
SO
RK
Reebok
SS
Tabel Sepatu
Kode Sepatu Nama Sepatu | Kode Jenis Sepatu
Kode Merek
Size
Harga
Warna
42 485000
41 675000
44 390000
FT
Flyknit
S-03
DA
Merah
Нуperfose
Slip On
НЕ
S-01
RK
Putih
SN
S-02
PA
Biru
ML
Max Cool
S-03
AS
43 535000
Ungu
Tabel Suplier
Kode Suplier
Nama Suplier
Alamat Suplier
РТ. MitraAdi
JI. Monginsidi 87
JI. Sudirman 23
МА
PT. Sakti Omega
PT. Sport Station
SO
SS
JI. Gunungkelud 8
Tabel Transaksi
Kode Jenis
Tanggal
Transaksi
Kode
Kode
Jumlah
Jumlah
Customer
Sepatu
Sepatu
Transaksi
Pembayaran
02/01/2015
C-02
SN
1
TI
390000
03/01/2015
C-04
ML
2 KT
1070000
04/01/2015
05/01/2015
06/01/2015
1| КТ
2 TI
C-01
НЕ
675000
C-03
FT
970000
С-02
НЕ
1 | КТ
675000
Tabel Customer
Kode Customer
Nama Customer
Alamat Customer
Kota Customer
С-01
Adi Kurniawan
JI. Sawentar 48
Jakarta
С-02
Linda Pujiastuti
JI. Kuda Nil 87
Surabaya
С-03
Sarbans Edi
JI. Cendrawasih 6
Medan
C-04
Michael Budi
JI. Ciliwung 32
Semarang
Tabel Jenis Transaksi
Kode Jenis Transaksi
Nama Jenis Transaksi
KT
Kredit
TI
Tunai
Transcribed Image Text:Tabel Jenis Sepatu Tabel Merek Kode Jenis Sepatu Varchar (10) --> PK Kode Merek Varchar (10) - --> PK Nama Jenis Sepatu Varchar (25) --> NN Nama Merek Varchar (30) --> NN Kode Suplier references tabel suplier Tabel Sepatu Kode Sepatu Varchar (10) - --> PK Tabel Suplier Nama Sepatu Varchar (40) -- > NN Kode Suplier Varchar (10) - -> PK Kode Jenis Sepatu references Tabel Jenis Sepatu Nama Suplier Varchar (30) --> NN Kode Merek references Tabel Merek Alamat Suplier Varchar (40) -- > NN Size Int --> NN Harga Money --> NN Tabel Customer Tabel Transaksi Kode Customer Varchar (10) --> PK Tanggal Transaksi date --> PK Nama Customer Varchar (30) --> NN Kode Customer references Tabel Customer --> PK Alamat Customer Varchar (40) --> NN Kota Customer Varchar (20) --> NN Kode Sepatu references Tabel Sepatu Jumlah Sepatu Int --> NN Kode Jenis Transaksi references Tabel Jenis Transaksi Tabel Jenis Transaksi Jumlah Pembayaran Int --> NN Kode Jenis Transaksi Varchar (10) --> PK Nama Jenis Transaksi Varchar (30) --> NN Tabel Jenis Sepatu Tabel Merek Kode Jenis Sepatu Nama Jenis Sepatu Kode Merek Nama Merek Kode Suplier Sepatu Lari Sepatu Basket S-01 AS Adidas МА S-02 DA Diadora SS S-03 Sepatu Soccer PA Puma SO RK Reebok SS Tabel Sepatu Kode Sepatu Nama Sepatu | Kode Jenis Sepatu Kode Merek Size Harga Warna 42 485000 41 675000 44 390000 FT Flyknit S-03 DA Merah Нуperfose Slip On НЕ S-01 RK Putih SN S-02 PA Biru ML Max Cool S-03 AS 43 535000 Ungu Tabel Suplier Kode Suplier Nama Suplier Alamat Suplier РТ. MitraAdi JI. Monginsidi 87 JI. Sudirman 23 МА PT. Sakti Omega PT. Sport Station SO SS JI. Gunungkelud 8 Tabel Transaksi Kode Jenis Tanggal Transaksi Kode Kode Jumlah Jumlah Customer Sepatu Sepatu Transaksi Pembayaran 02/01/2015 C-02 SN 1 TI 390000 03/01/2015 C-04 ML 2 KT 1070000 04/01/2015 05/01/2015 06/01/2015 1| КТ 2 TI C-01 НЕ 675000 C-03 FT 970000 С-02 НЕ 1 | КТ 675000 Tabel Customer Kode Customer Nama Customer Alamat Customer Kota Customer С-01 Adi Kurniawan JI. Sawentar 48 Jakarta С-02 Linda Pujiastuti JI. Kuda Nil 87 Surabaya С-03 Sarbans Edi JI. Cendrawasih 6 Medan C-04 Michael Budi JI. Ciliwung 32 Semarang Tabel Jenis Transaksi Kode Jenis Transaksi Nama Jenis Transaksi KT Kredit TI Tunai
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY