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
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
Chapter3: Data Representation
Section: Chapter Questions
Problem 3RP
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F74124882-63e6-41ee-bb16-1947b6c7806e%2F37024f1c-b590-4959-82a2-c7e50f803527%2Fkmi70vu_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781305971776/9781305971776_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781305971776/9781305971776_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning