Consider the following two relational database tables to answer all the below questions. Smart Phone Table Sale Table Phone ID Brand Model Cost Date Sale Sale_ID Phone_ID Galaxy Note of Sale Price P-001 Samsung 180.00 KD 10 REC 4- 320.00 P-003 Galaxy S10- April- 2021 101 KD P-002 Samsung 160.00 KD Lite 11-

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
icon
Related questions
Question
100%

please make sure the answer is correct 100%

Consider the following two relational database tables
to answer all the below questions.
Smart Phone Table
Sale Table
Phone ID
Brand
Model
Cost
Date
Sale
Sale_ID Phone_ID
of
Galaxy
Note
Price
P-001
Samsung
180.00
Sale
KD
10
REC
320.00
4-
P-003
Galaxy
S10-
April-
2021
101
KD
P-002
Samsung
160.00
KD
Lite
REC
100.00
11-
P-001
March-
2021
P-003
Apple
IPhone
250.00
102
KD
12
KD
P-004
IPhone
300.00
REC
120.00
5-
Apple
P-001
March-
12 Pro
KD
103
KD
2021
1) Identify the primary keys and foreign keys for
each table.
2) Create a data dictionary for the Smart Phone
table. You should use appropriate data types
and lengths.
Transcribed Image Text:Consider the following two relational database tables to answer all the below questions. Smart Phone Table Sale Table Phone ID Brand Model Cost Date Sale Sale_ID Phone_ID of Galaxy Note Price P-001 Samsung 180.00 Sale KD 10 REC 320.00 4- P-003 Galaxy S10- April- 2021 101 KD P-002 Samsung 160.00 KD Lite REC 100.00 11- P-001 March- 2021 P-003 Apple IPhone 250.00 102 KD 12 KD P-004 IPhone 300.00 REC 120.00 5- Apple P-001 March- 12 Pro KD 103 KD 2021 1) Identify the primary keys and foreign keys for each table. 2) Create a data dictionary for the Smart Phone table. You should use appropriate data types and lengths.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Single Table
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education