1. Consider the following schema:PlayerplvId plyNameHilalTarekSportspld1Record#plyId#evCode placespNameFootballTennisSwimmingCycling11E1223Sultan31E64Salim42E212E51Event3ЕЗ32evCodeev Title#spId evPlayes43ESE43Mini Foot FestIbri TourEl175E71E2415Oman OpenArab Sea RaceMuscat CyclingDhofar FestIndoors CupSuhar OpenE332E4336E5448Еб1115E7332B8264Note: 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.

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

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

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

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
Do it correct plz.. Please write business rules er diagram. Don't be wrong sir
4. Transform the PARTNER supertype in the following model for a DJ business, using Single-Table/Supertype Implementation. supervise 1 PARTNER #id *first name *last name EVENT PLANNER *expertise PO DJ *specialty MANAGER authorized expense limit OTHER supervised by
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
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.
Create an entity-relationship diagram for the three entities showing the correct cardinalities. Save and print a copy.
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
Decipher the business rules for this ER Diagram :
Transform the above ER diagram into Relational Schemas