Question: Consider the following E-R Diagram. Based on this ERD, answer the following questions. TOURNAMENTS TourneyID PK H TourneyDate TourneyLocation TOURNEY_MATCHES MatchID PK FK MATCH_GAMES TourneyID

Consider the following E-R Diagram. Based on this ERD, answer the following questions. TOURNAMENTS TourneyID PK H TourneyDate TourneyLocation TOURNEY_MATCHES MatchID PK FK MATCH_GAMES TourneyID Lanes OddLane TeamID FK MatchID CPK GameNumber CPK TEAMS EvenLaneTeamID FK WinningTeamID FK TeamID PK TeamName CaptainID FK HO- BOWLERS BOWLER_SCORES BowlerID PK MatchID CPK BowlerLastName GameNumber CPK BowlerFirstName BowlerID CPK BowlerMiddleInit RawScore BowlerStreetAddress Handicap Score BowlerCity WonGame BowlerState Bowler ZipCode BowlerPhoneNumber TeamID FK ERD diagram of Question 1. Question A.1. Attributes of the entity Teams are and and among them, is its primary key, and is Foreign Key. (5 Points) Question A.2. In the entity Match_Games, and are primary keys. (2 Points) Question A.3. The relation of Tourney_Matches and Match_Games is (1 Point) Question A.4. The foreign keys of the relation Teams is and its value comes form the column of the relation (3 Points) Question A.5. CPK stands for (1 Points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
