Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
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 name of the supplier who sells shoes at prices below the average shoe price - Show the name of the customer who bought shoes with odd sizes - Show Customer Name and Average Payment Amount for Customers who make 5 transaction more than 1   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 name of the supplier who sells shoes at prices below the average shoe price - Show the name of the customer who bought shoes with odd sizes - Show Customer Name and Average Payment Amount for Customers who make 5 transaction more than 1   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)
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
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 name of the supplier who sells shoes at prices below the average shoe price
- Show the name of the customer who bought shoes with odd sizes
- Show Customer Name and Average Payment Amount for Customers who make 5
transaction more than 1

 

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 2 steps with 13 images

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS