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

Do it correct plz.. Please write business rules er diagram. Don't be wrong sir
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!!!
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 :
Note:- Put the answer if you are 100% sure of the answer, otherwise no Q1 : pictures Q2:pictures
Make it this schema diagram to ER diagram
Consider the following ER diagram. Attribute 'Code' is an example of a for entity FARE. Airport_code City State Name AIRPORT Company M CAN_ LAND N Type_name Max_seats AIRPLANE TYPE TYPE N Airplane_id AIRPLANE Seat_no SEAT Scheduled_dep_time Dep_time Total_no_of_seats Customer_name DEPARTS N N ASSIGNED DEPARTURE AIRPORT N ARRIVES ARRIVAL AIRPORT RESERVATION N Cphone Scheduled_arr_time Arr_time N N INSTANCE_OF Instances N Number Airline Weekdays Restrictions Amount Code No_of_avail_seats LEG_INSTANCE Date Leg_no FLIGHT LEG N LEGS FLIGHT 1 FARES N FARE Notes: A LEG (segment) is a nonstop portion of a flight A LEG_INSTANCE is a particular occurrence of a LEG on a particular date.
1. Convert the conceptual ERD to Logical ERD 2. Derive the relation schema. Figure 6: AUTHOR PUBLICATION pub_ID (pk) publish_date author_num (pk) Li author_Iname author fname author phone works (MANDATORY, or ORGANIZATION BOOK ARTICLE book title book category book publisher article title keyword org ID (pk) org name org address published_in LI JOURNAL journal ID (pk) journal name year publisher volume SUBJECT LI subject_name (pk) category
Map the EER diagram to a relational schema and transform the relation into 3NF
Make an entity relationship diagram with the following data: Patient Entity: RUT (Primary Key): Integer Name: String Last name: String Date of Birth: Date Email: String Address: String Telephone numbers: String Pension System: String Health Insurance Entity: Code (primary key): Integer Type: String Medical entity: RUT (Primary Key): Integer Name: String Last name: String Date of Birth: Date Specialties: String Years of practice: Integer Medical Specialty Entity: Code (primary key): Integer Specialty Name: String Pharmaceutical company entity: Code (primary key): Integer Name: String Phone number: String Medication Entity: Business name (primary key): String Formula: String Pharmaceutical company code (foreign key): Integer Pharmacy Entity: Code (primary key): Integer Name: String Address: String Phone number: String Patient-Physician Assignment Entity: Assignment ID (primary key): Integer Patient RUT (foreign key): Integer Doctor RUT (Foreign Key): Integer Start date: Date End date:…