1. Consider the following schema:Sportspld1PlayerRecordplyld plyNameHilalTarekspNameFootball#evCode place#plyId11El22Tennis233Sultan1E64SwimmingCycling4Salim4E21E51Event3E332evCodeev Title#spId evPlayes43E88E43ElMini Foot FestIbri Tour1754E71E2415Oman OpenArab Sea RaceЕЗ232E4336Muscat CyclingDhofar FestIndoors CupSuhar OpenE5448E61115E7332B864Note: 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)Q2. Insert data in tables as in the figure.

FIRST WE NEED TO CREATE THE TABLES AND THEN INSERT THE DATA. NOTE: In the Event table the last entry…

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

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

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

I need the discussion about this figure Tiny College ERD.
1. Consider the following schema: Player plyId plyName Hilal Sport spld 1 Record #evCode place spName Football #plyId 1 Tarek Tennis 1 El 2 Sultan 1 Еб 4 Swimming Cycling 3 3 4 Salim 4 2 E2 1 2 E5 1 Event 3 ЕЗ 32 3 E8 8 evCode ev Title #spId evPlayes E4 3 Mini Foot Fest Ibri Tour Oman Open E1 1 75 4 E7 E2 15 ЕЗ 2 32 Arab Sea Race Muscat Cycling Dhofar Fest Indoors Cup Suhar Open 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 sereen 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) Q6. Create a view named games that contains event title, number of event plaxes, sport name of all events.
s/4491/lessons/4180/slides/31019 合 3.1.2: Entity Relationship Modelling Prev Next Question SAVED Question Training P. Name Visual Basic Visual Basic SOL SOL P Code Instructor Dennis Dennis Term 15-1 15-2 15-1 15-2 15-1 Duration (Hrs) Hourly Rate 20 Room NO P1 A1 P1 P2 P2 P3 30 A2 Jason 10 20 30 A4 Jason Joneph Joseph Rys A5 P3 P4 C.. Java 15-2 15-2 20 10 A3 A7 A9 6 Identify the most suitable primary key for the table above and explain how this key uniquely defines all other attributes. Baragraph BIU > 8 E E Submit
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.
create an Entity Relationship Diagram using the following Entities and their respective attritubes for an online programming competition registration for both leaners and university students. 1. Host it's attributes (host Id, hostFirstName,hostLastName, hostTelNum,hostEmail,hostPassword) 2. Student(StudentId, StudentfirstName, Student Email, StudentPassword, InstitutionName) 3. Learners(leaner Id, leanerFirstName, leanerLastName, leanerPassword, SchoolName) 4. Competition(compId, comName, compDate,comTime, compRules, compRequirements) 5. Qualified Student/Leaner (id, firstName, compId,email)
Please help me answer the following questions
help need correct solution
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 let me know if you have any thoughts in accordance with the prompt for what I currently have. Also, what relationship cardinalities should be used to connect ERD?
1. Consider the following schema: Player plyId 1 Sport spld 1 Record plyName Hilal spName Football #evCode place #plyId 2 Tarek 2 Tennis 1 El 2 3 1 E6 4 Sultan Salim Swimming 2 Cycling 3 4 4 E2 1 2 E5 1 Event 3 ЕЗ 32 3 E8 8 #spId evPlayes 4 evCode evTitle E4 3 E1 Mini Foot Fest 1 75 4 E7 1 Ibri Tour Oman Open Arab Sea Race E2 4 15 ЕЗ 2 32 E4 3 36 Muscat Cycling Dhofar Fest Indoors Cup Suhar Open E5 4 48 E6 E7 115 32 64 1 3 B8 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.
Please explain this Enhanced entity-relationship (EER) Diagram (see attached photo)