1. There are three relationships between the entities Player, Team and Match as shown below: Player...

 

Transcribed Image Text:

1. There are three relationships between the entities Player, Team and Match as shown below: Player Match Team Has pid {PK} PlaysHome home Team (PK} name tid {PK} matchDate (PK} dob address name PlaysAway away Team city score a) For each of the relationships Has, PlaysHome and PlaysAway: Determine the multiplicities, i.e. constraints on the relationship. Justify your choice. State the degree and type of the relationship. b) Map the given conceptual data model to a relational schema, indicating both primary and foreign keys. 1. There are three relationships between the entities Player, Team and Match as shown below: Player Match Team Has pid {PK} PlaysHome home Team (PK} name tid {PK} matchDate (PK} dob address name PlaysAway away Team city score a) For each of the relationships Has, PlaysHome and PlaysAway: Determine the multiplicities, i.e. constraints on the relationship. Justify your choice. State the degree and type of the relationship. b) Map the given conceptual data model to a relational schema, indicating both primary and foreign keys.