Q5. Update the sRld of player 3 to 2.

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
1. Consider the following schema:
Player
Sport
spld
Record
plvId plyName
Hilal
Tarek
#evCode place
spName
Football
#plyId
1
1
2
2
Tennis
1
El
2
1
Еб
4
Sultan
Salim
Swimming
Cycling
3
3
4
4
E2
1
2
E5
1
3
ЕЗ
32
Event
evCode
3
E8
#spId evPlayes
4
75
evTitle
E4
3
Mini Foot Fest
Ibri Tour
Oman Open
Arab Sea Race
Muscat Cycling
E1
1
4
E7
1
E2
15
ЕЗ
32
E4
3
36
E5
4
48
E6
Dhofar Fest
1
115
Indoors Cup
Suhar Open
E7
3
32
B8
2
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 file. Do not forget to indicate the question nu
and send it by email)
er, save the file with your student number
Q4. Add attribute şspld to the table Player.
Q5. Update the SRIA of player 3 to 2.
Transcribed Image Text:1. Consider the following schema: Player Sport spld Record plvId plyName Hilal Tarek #evCode place spName Football #plyId 1 1 2 2 Tennis 1 El 2 1 Еб 4 Sultan Salim Swimming Cycling 3 3 4 4 E2 1 2 E5 1 3 ЕЗ 32 Event evCode 3 E8 #spId evPlayes 4 75 evTitle E4 3 Mini Foot Fest Ibri Tour Oman Open Arab Sea Race Muscat Cycling E1 1 4 E7 1 E2 15 ЕЗ 32 E4 3 36 E5 4 48 E6 Dhofar Fest 1 115 Indoors Cup Suhar Open E7 3 32 B8 2 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 file. Do not forget to indicate the question nu and send it by email) er, save the file with your student number Q4. Add attribute şspld to the table Player. Q5. Update the SRIA of player 3 to 2.
Expert Solution
steps

Step by step

Solved in 2 steps

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