he screenshot of the query and the results below is from the question of each number, and saved with the file name: UAS_35200103.docx or UAS_35200103.pdf
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
The screenshot of the query and the results below is from the question of each number, and saved with the file name: UAS_35200103.docx or UAS_35200103.pdf
Enter the data in the table as follows:
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F868cc903-c829-4341-9ee7-c4aeb2fe0cdc%2Fda9ab9fd-0362-4e2a-aa2f-aad04472286c%2Fqhtwupf_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 7 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)