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.pdfCreate 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 priceJenis_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_TransaksiInsert into Jenis_Transaksi values('KT', 'Kredit');Insert into Jenis_Transaksi values('TI', 'Tunai');TransaksiInsert 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 SepatuTabel MerekKode Jenis Sepatu Varchar (10) --> PKKode Merek Varchar (10) ---> PKNama Jenis Sepatu Varchar (25) --> NNNama Merek Varchar (30) --> NNKode Suplier references tabel suplierTabel SepatuKode Sepatu Varchar (10) ---> PKTabel SuplierNama Sepatu Varchar (40) --> NNKode Suplier Varchar (10) --> PKKode Jenis Sepatu references Tabel Jenis SepatuNama Suplier Varchar (30) --> NNKode Merek references Tabel MerekAlamat Suplier Varchar (40) --> NNSize Int --> NNHarga Money --> NNTabel CustomerTabel TransaksiKode Customer Varchar (10) --> PKTanggal Transaksi date--> PKNama Customer Varchar (30) --> NNKode Customer references Tabel Customer --> PKAlamat Customer Varchar (40) --> NNKota Customer Varchar (20) --> NNKode Sepatu references Tabel SepatuJumlah Sepatu Int --> NNKode Jenis Transaksi references Tabel Jenis TransaksiTabel Jenis TransaksiJumlah Pembayaran Int --> NNKode Jenis Transaksi Varchar (10) --> PKNama Jenis Transaksi Varchar (30) --> NNTabel Jenis SepatuTabel MerekKode Jenis SepatuNama Jenis SepatuKode MerekNama MerekKode SuplierSepatu LariSepatu BasketS-01ASAdidasМАS-02DADiadoraSSS-03Sepatu SoccerPAPumaSORKReebokSSTabel SepatuKode Sepatu Nama Sepatu | Kode Jenis SepatuKode MerekSizeHargaWarna42 48500041 67500044 390000FTFlyknitS-03DAMerahНуperfoseSlip OnНЕS-01RKPutihSNS-02PABiruMLMax CoolS-03AS43 535000UnguTabel SuplierKode SuplierNama SuplierAlamat SuplierРТ. MitraAdiJI. Monginsidi 87JI. Sudirman 23МАPT. Sakti OmegaPT. Sport StationSOSSJI. Gunungkelud 8Tabel TransaksiKode JenisTanggalTransaksiKodeKodeJumlahJumlahCustomerSepatuSepatuTransaksiPembayaran02/01/2015C-02SN1TI39000003/01/2015C-04ML2 KT107000004/01/201505/01/201506/01/20151| КТ2 TIC-01НЕ675000C-03FT970000С-02НЕ1 | КТ675000Tabel CustomerKode CustomerNama CustomerAlamat CustomerKota CustomerС-01Adi KurniawanJI. Sawentar 48JakartaС-02Linda PujiastutiJI. Kuda Nil 87SurabayaС-03Sarbans EdiJI. Cendrawasih 6MedanC-04Michael BudiJI. Ciliwung 32SemarangTabel Jenis TransaksiKode Jenis TransaksiNama Jenis TransaksiKTKreditTITunai

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);

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...

See similar textbooks

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);