Q8. Write a plsahprogram using cursors to display contents of table Sport.

Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter3: Data Representation
Section: Chapter Questions
Problem 3RP
icon
Related questions
Question
1. Consider the following schema:
Player
plyId
1
Sport
spld
1
Record
sp Name
Football
#plyId
#evCode place
plyName
Hilal
Tarek
El
2
2
Tennis
Sultan
Еб
4
Swimming
2
Cycling
3
3
4
Salim
4
E2
1
E5
1
Event
3
ЕЗ
32
E8
evCode
evTitle
#spId evPlayes
E4
Mini Foot Fest
Ibri Tour
El
1
75
4
E7
1
E2
ЕЗ
4
15
Oman Open
Arab Sea Race
Muscat Cycling
2
32
E4
3
36
E5
E6
4
48
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 number, save the file with your student number
and send it by email)
Q7. Display player event name and sport name using the above view.
Q8. Write a plsahprogram using cursors to display contents of table Sport.
Transcribed Image Text:1. Consider the following schema: Player plyId 1 Sport spld 1 Record sp Name Football #plyId #evCode place plyName Hilal Tarek El 2 2 Tennis Sultan Еб 4 Swimming 2 Cycling 3 3 4 Salim 4 E2 1 E5 1 Event 3 ЕЗ 32 E8 evCode evTitle #spId evPlayes E4 Mini Foot Fest Ibri Tour El 1 75 4 E7 1 E2 ЕЗ 4 15 Oman Open Arab Sea Race Muscat Cycling 2 32 E4 3 36 E5 E6 4 48 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 number, save the file with your student number and send it by email) Q7. Display player event name and sport name using the above view. Q8. Write a plsahprogram using cursors to display contents of table Sport.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning