1. Consider the following schema:PlayerplyId1Sportspld1RecordplyNameHilalspNameFootball#evCode place#plyId2Tarek2Tennis1El231E64SultanSalimSwimming2Cycling344E212E51Event3ЕЗ323E88#spId evPlayes4evCodeevTitleE43E1Mini Foot Fest1754E71Ibri TourOman OpenArab Sea RaceE2415ЕЗ232E4336Muscat CyclingDhofar FestIndoors CupSuhar OpenE5448E6E7115326413B8Note: primary keys are underlined, foreign keys have #.Answer the following questions : (after executing the SQL command, copy the command and screen shot of theresult in a word file. Do not forget to indicate the question number, save the file with your student numberand send it by email)Q7. Display player event name and sport name using the above view.

The SQL query is given in step 2.

1. Consider the following schema: Player Sport spld Record plyId plyName Hilal Tarek Sultan spName Football Tennis #plyId #evCode place 1 1 1 El 2 1 E6 4 Swimming Cycling 3 3 4 Salim 4 E2 1 E5 1 Event 3 E3 32 3 E8 8 evCode #spId evPlayes 4 evTitle E4 3 E1 Mini Foot Fest 1 75 4 E7 1 Ibri Tour Oman Open Arab Sea Race Muscat Cycling Dhofar Fest Indoors Cup Suhar Open E2 4 15 ЕЗ 2 32 E4 3 36 E5 4 48 Еб 1 115 E7 3 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 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.

1. Consider the following schema: Player Sport spld Record plyId plyName Hilal Tarek Sultan spName Football Tennis #plyId #evCode place 1 1 1 El 2 1 E6 4 Swimming Cycling 3 3 4 Salim 4 E2 1 E5 1 Event 3 E3 32 3 E8 8 evCode #spId evPlayes 4 evTitle E4 3 E1 Mini Foot Fest 1 75 4 E7 1 Ibri Tour Oman Open Arab Sea Race Muscat Cycling Dhofar Fest Indoors Cup Suhar Open E2 4 15 ЕЗ 2 32 E4 3 36 E5 4 48 Еб 1 115 E7 3 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 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.

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

See similar textbooks

Similar questions

Need help identifying and establishing Primary keys and foreign keys
Film Actor Language Film SMALLINT VARCHARZ (255) VARCHAR2 (2 SMALLINT SMALLINT PF actor d SMALLINT PF fim id .im_id languaged SMALLINT CHAR (20) SMALLINT name description release year anguage_id original_language SMALLINT renta duration *rentaate engh *replacement_cost rating pecial features ustpdate SMALLINT NUMBER (42) SMALLINT Fam Category SMALLINT SMALLINT NUMBER (52) VARCHARZ 6) VARCHAR2 (255) TIMESTAMP PF Sm id KA category Actor actor id first name SMALLINT VARCHARZ (45) last rame VARCHAR (4) nationality CHAR (2) Category category SMALLINT VARCHAR2 (2) Country country d SMALLINT U short_code CHAR (2) VARCHARU (2) name P parent c SMALLINT name Using the film database you have, answer the following queries in your schema then write them down in this paper. Question One: Select the total rental_rate for films grouped by their categories. Order the result (a from largest to smallest. Select all actors who acted together with JOE in any film. Use inner query. (b Create a view, which…
Create entity relationship model based on the table.
Define Normalization & Normalize the following table to 3rd NF
Do it correct plz.. Please write business rules er diagram. Don't be wrong sir
Design the Facebook DB Schema using necessary Entity Relationships
according to tables below, Create 5 views that are reasonable
4. Write the business rules against the following E-R diagram. movie_cast act_id mov_id |integer integer char (30) actor genres Y act_id act_fname integer char (20) Y gen_id integer char (20) role gen_title act_Iname act_gender char (20) char (1) movie mov_id mov_title mov_year mov_time mov_lang mov_dt_rel mov_rel_country char (5) integer char (50) integer integer char (50) date director movie_genres Y dir_id integer integer char (20) char (20) mov_id dir_fname gen_id integer dir_Iname rating mov_id rev_id integer integer integer num_o_ratings integer reviewer movie_direction rev_id integer char (30) dir_id integer rev_stars mov_id integer rev_name w3resource.com 81 8 8Ị 8Ị 81 81
Please Help ASAP!!!
Question 13 sum .Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
Please provide answer and explanation as well
Map the EER diagram to a relational schema and transform the relation into 3NF