Make the following tables database: 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) --> NN Kode Sepatu references Tabel SepatuKota Customer Varchar (20) --> NNJumlah Sepatu Int --> NNKode Jenis Transaksi references Tabel Jenis TransaksiTabel Jenis TransaksiJumlah Pembayaran Int --> NNKode Jenis Transaksi Varchar (10) --> PKNama Jenis Transaksi Varchar (30) ---> NN

Answered: Image /qna-images/answer/e4edb73e-9c25-4c78-a74f-aa71ee6648b0.jpg

Tabel Jenis Sepatu Tabel Merek Kode Jenis Sepatu Varchar (10) -- 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) -- 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

Tabel Jenis Sepatu Tabel Merek Kode Jenis Sepatu Varchar (10) -- 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) -- 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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Using the Bowlers and Bowler_Scores tables, list the BowlerID, bowler name, and raw score for each…

A: The given problem requires us to find the BowlerID, bowler name, and raw score for each bowler who…

Q: list of clauses in sql. Give examples of very clauses.

A: sql clause facilitates us to retrieve a hard and fast or bundles of information from the table. sql…

Q: eans that: Question 4 options: Not only SQL is us

A: Accessing Data with NoSQL Means that: Question 4 options: Not only SQL is used Only SQL is used No…

Q: ts: You will need to add data to both tables. Remember that the movie table has th duction co., not…

A: Description: 1- If a user wants to insert records one by one then needs to use the following…

Q: How do I view tables in SQL?

A: In the given question SQL stand for structured query language.

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: That is not the answer to the above question. Please create CKY tables for the question that was…

A: 0 1 2 3 0 S - - - 1 NP VP - - 2 - V - NP 3 - - Det Noun 4 - - a View S -> NP VP…

Q: access databases Normalization Exercise Represent this table as a collection of tables in 3NF:…

A: The key for the given relation is (StudentNumber, CourseNumber) The partial functional dependency…

Q: How can you pick partial table contents?

A: Solution:- We can pick partial table contents by naming the desired fields and by placing…

Q: List at least 3 differences between Oracle PL/SQL programming functions and procedures (Differences…

A: Differences between Oracle PL/SQL programming functions and procedures S.N. function…

Q: Most of the time, tables and data ranges are sorted in ascending sequence. When would you want to…

A: Sorting data is an important process in data analysis that involves organizing data in a specific…

Q: SQL SUM Problem -SELECT * FROM [Sale Order] INNER JOIN Product ON [Sale Order] productID =…

A: Structured Query Language (SQL) is a programming language used to create, manipulate and query data…

Q: Need top product name by revenue (by month) using sql 3 different tables order - table (order id,…

A: The answer is

Q: List the names of the production companies and the titles of their movies. This time, include all…

A: Given that, The names of the tables are Movie and Production Assume that, The attributes of Movie…

Concept explainers

Binomial Heap

A binomial heap is a group of binomial trees. This data structure acts as a priority queue and implements the merge operation faster.

Question

Make the following tables database:

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

Kode Sepatu references Tabel Sepatu
Kota Customer Varchar (20) --> NN
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

Organized collection of structured information, or data, typically stored in a computer system.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Which of these is more important, Primary Key or Unique? In the JustLee Books database, you may look up the tables
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
#SQL Question Use TopBabyNamesbyState.csv1 and write queries to extract the following information: 4) How many unique names are there in this dataset? 5) Which name in which state and in which year had the highest number of occurrences. 6) What is the average occurrence of “Jessica” as a top name in the state of CA? 7) How many years was “Mary” the top name in California? Name the computed column as “Mary_topinCA”. 8) The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. 9) Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order.
4. In the OrderItems table, display a count of the number of products, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BNBG01 BNBG02 BNBG03 BR03 4 rows returned in 0.00 seconds PROD_ID Download 3 3 3 4 NUM_PROD_ID
Explain replace and translate functions in Oracle sql
Use the appropriate MySQL command to list all tables in the books database