Consider the following schema: Player plyId 1 Sport spld 1 Record plyName Hilal spName Football #plyId #evCode place Tarek Tennis 1 El 2 E6 4 Swimming Cycling Sultan 3 4 Salim E2 1 E5 1 Event 3 E3 32 3 E8 8. evPlayes 4 evCode evTitle #spId E4 3 El Mini Foot Fest 1 75 4 E7 1 E2 Ibri Tour 4 15 ЕЗ Oman Open 32 1. 23

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
GUCJTTONT
Consider the following schema:
Player
plyId
Sport
spld
Record
plyName
Hilal
spName
Football
Tennis
#evCode place
#plyId
1
1
Tarek
1
El
3
Sultan
1
E6
4
Swimming
Cycling
3
4
Salim
E2
1
E5
1
Event
ЕЗ
32
E8
8.
evCode
evTitle
#spld evPlayes
E4
3
Mini Foot Fest
Ibri Tour
E1
1
75
E7
1
E2
4
15
Oman Open
Arab Sea Race
ЕЗ
32
E4
3
36
Muscat Cycling
Dhofar Fest
E5
4
48
Еб
1
115
Indoors Cup
Suhar Open
E7
32
B8
64
Note: primary keys are underlined, foreign keys have #.
Answer the following questions : (after executing the SQL command, copy the command and screen shot of the result in a word
M344
3/2
Transcribed Image Text:GUCJTTONT Consider the following schema: Player plyId Sport spld Record plyName Hilal spName Football Tennis #evCode place #plyId 1 1 Tarek 1 El 3 Sultan 1 E6 4 Swimming Cycling 3 4 Salim E2 1 E5 1 Event ЕЗ 32 E8 8. evCode evTitle #spld evPlayes E4 3 Mini Foot Fest Ibri Tour E1 1 75 E7 1 E2 4 15 Oman Open Arab Sea Race ЕЗ 32 E4 3 36 Muscat Cycling Dhofar Fest E5 4 48 Еб 1 115 Indoors Cup Suhar Open E7 32 B8 64 Note: primary keys are underlined, foreign keys have #. Answer the following questions : (after executing the SQL command, copy the command and screen shot of the result in a word M344 3/2
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Securing Systems
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
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