team, ributo olayed that a ongger a. Identify the candidate keys of each relation. b. Identify the primary key and any alternate keys of each relation. c. How many foreign keys does ench relation have? d. Identify the foreign keys of each relation. e. Indicate any instances in which a foreign key serves as part of the primary key of the relation in which it is a foreign key. Why does each of those relations require a multi-attribute primary key? f. Identify the relations that support many-to-many relationships, the primary keys of those relations, and any intersection data. g. Assume that we add the following STADIUM relation to the Super Baseball League relational database. Each team has one home stadium, which is what is represented in this relation. Assume that a stadium can serve as the home stadium for only one team. Stadium Name is unique across the league. Enoch eplene STADIUM Relation ees of Dellence Tecm Studium None Size What kind of binary relationship exists between the STADIUM relation and the TEAM relation? Could the data from the two relations be combined into one without reducine data redundancy If so, how? 9 7 115 Serial Numbor (for bata) unique only within a team. In the AFFILIATION relation, the Years attributo indicates that number of years that a player played on a team; the Batting Averago is for the years that a player played on a team. TEAM Relation Team Team Nome .. Identify the candida b. Identify the primar coholon. o. How many foreign d. Identify the foreign e. Indicate any instanc as part of the prima it is a foreign key. require a multi-attrit f. Identify the relation relationships, the po and any intersection g. Assume that we relation to the Sur database. Each team is what is represente stadium can serve as tearn. Stadium Name Number Oy Manager COACH Relation Toom Number Coach Nome Cooch Telephone WORK EXPERIENCE Rection STADIU Experience Teom Munter Coach Nome Years of Experience Stadium None BATS Relation Team Number Serid Number What kind of binary STADIUM relations the data from the two without introducing d h. Using the informal described in this chan L. Retrieve the recor Manufacturer STADIUM Relation WORK EXPERIENCE Ration Cooch Emporience Type Team Years of Experience Stadium None You Built Teem Team Member Namo Size BATS Roletim Suid Number Toom Habar Manufacturer What kind of binary relationship exists between the STADIUM relation and the TEAM relation? Could the data from the two relations be combined into one without introducing data redundancy? If so, how? h. Using the informal relational command language described in this chapter, write commands to: i. Retrieve the record for tenni number 12. ii. Retrieve the record for conch Adams on team number 12. iii. List the player number and age of every player, iv. List the work experience of every coach. v. List the work experience of every coach on team number 25, vi. Find the age of player number 42459. vil. List the serial numbers and manufacturers of all of the Vultures' (the name of a team) bats. viii. Find the number of years of college coaching experience that coach Taylor of the Vultures has PLAYER Roletion Nantie More Number 120 AFFILIATION Relation Toon Number Botting Ave Norber Years a team, attribute - played rs that a Manager a. Identify the candidate keys of each relation. b. Identify the primary key and any alternate keys of cach relation, c. How many foreign keys does each relation have? d. Identify the foreign keys of each relation. e. Indicate any instances in which a foreign key serves as part of the primary key of the relation in which it is a foreign key. Why does each of those relations require a multi-attribute primary key? f. Identify the relations that support many-to-many relationships, the primary keys of those relations, and any intersection data. g. Assume that we add the following STADIUM relation to the Super Baseball League relational database. Each team has one home stadium, which is what is represented in this relation. Assume that a stadium can serve as the home stadium for only one team. Stadium Name is unique across the league. Cooch malophone STADIUM Relation ears of perience Stadium Name You Built Teom Number Size What kind of binary relationship exists between the STADIUM relation and the TEAM relation? Could the data from the two relations be combined into one without introducing data redundancy? If so, how? h. Using the informal relational command language described in this chapter, write commands to: i. Retrieve the record for team number 12. facturer database. Each team has one home stadium, which is what is represented in this relation. Assume that a stadium can serve as the home studium for only one team. Stadium Name is unique across the league, STADIUM Relation Stadium Name Your Built Team Team Nurnber Size What kind of binary relationship exists between the STADIUM relation and the TEAM relation? Could the data from the two relations be combined into one without introducing data redundancy? If so, how? h. Using the informal relational command language described in this chapter, write commands to: i. Retrieve the record for team number 12. ii. Retrieve the record for coach Adams on team number 12 iii. List the player number and age of every player. iv. List the work experience of every coach. v. List the work experience of every couch on team number 25. vi. Find the age of player number 42459. vii. List. the serial numbers and manufacturers of all of the Vultures' (the name of a team) bats. viii. Find the number of years of college coaching experience that coach Taylor of the Vultures bas. Team Mumbar Cooch Name Cooch Telephone Team Mamber WORK EXPERIENCE Rolotion Cooch Experience Nomo Type Years Of Experience BATS Relation Toom Number Serial Number Menufacturer PLAYER Robotion Mumba Player Name Mover Ago AFFILIATION Relation Ployer Mumber Toom Number Years Batting Average 136 Chapter 5 The Relatione Database Model hraduction Serial Number (for bats) is unique only within a team. In the AFFILIATION relation, the Years attribute indicates that number of years that a player played on a team; the Batting Average is for the years that a player played on a team. a. Ident b. Ident cach c. How d. Ident e. Indic TEMA Relation as po it is Teen Team Nome Number GY Manager requi f. Ident relati and a CONCH Relation 8. Assu Toom Number Coach Name Cooch Telephone relati datat is wh stadio team WORK EXPERIENCE Relation Team Number Coach Nome Experience Type Years Of Experience Stadium Nome BAIS Relation Toom Number Sonid Numhet Wha STA the with h. Usin desc Manufacturer What kind of binary relationship exists between the STADIUM relation and the TEAM relation? Could the data from the two relations be combined into one without introducing data redundancy? If so, how? h. Using the informal relational command language described in this chapter, write commands to: i. Retrieve the recordhor team number 12. ii. Retrieve the record for coach Adams on team number 12. iii. List the player member and age of every player. iv. List the work experience of every coach. v. List the work experience of every coach on team number 25. vi. Find the age of player number 42459. vii. List the serial numbers and manufacturers of all of the Vultures' (the name of a team) bats. viii. Find the number of years of college coaching experience that coach Taylor of the Vultures has. 0 90 cam ibute ayed a. Identify the candidate keys of each relation. b. Identify the primary key and any altemate keys of each relation. c. How many foreign keys docs cach relation have? d. Identify the foreign keys of cach relation. e Indicate any instances in which a foreign key serves as part of the primary key of the relation in which it is a foreign key. Why does each of those relations require an multi-attribute primary key? 1. Identify the relations that support many-to-many relationships, the primary keys of those relations, and any intersection data. 8. Assume that we add the following STADIUM relation to the Super Baseball League relational databasc. Each team has one home stadium, which is what is represented in this relation. Assume that a stadium can serve as the home stadium for only one tcem. Stadium Name is unique across the league ch STARUM Relation Your Site Nam Bolt Team Nubet What kind of binary relationship exists between the STADIUM relation and the TEAM relation? Could the data from the two relations be combined into one without introducing data redundancy? If so, how? h. Using the informal relational command language described in this chapter, write commande to: i. Retrieve the record for team number 12. ii. Retrieve the record for coach Adams on team number 12 fii. Last the player number and age of every player. iv. List the work experience of every coach. v. List the work experience of every coach on team number 25 vi. Find the age of player number 42459. vii. List the serial numbers and manufacturers of all of the Vultures' (the name of a team) bats. vili. Find the number of years of college coaching experience that coach Taylor of the Vultures has 24 b. I Serial Number (for buts) is unique only within a team. in the AFFILIATION relation, the Years attribute indicates that number of years that a player played on a team; the Batting Average is for the years that a player played on a team. CE d. c. 1 TEAM Poletion it Toon Team Number Menager TI T! CBAC Relation Coach Cach d Nurser S leon ube WORK EXPERIENCE Mefon Code trate Mom Experience No BAIS Route Serie Team Menu h. 1 PLAYER Relation Name Number Hoy fore Age AFFILIATION Police Toon Kombo Borting Hoyer Number V