determine the multiplicity plz1. There are three relationships between the entities Player, Team and Match as shown below: Player Match Team pid (PK) Has PlaysHomehomeTeam (PK) name dob address tid (PK) name city PlaysAway matchDate (PK 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) M ap the given conceptual data model to a relational schema, indicating both primary and foreign keys. Show transcribed image text 1. There are three relationships between the entities Player, Team and Match as shown below: Player Match Team pid (PK) Has PlaysHomehomeTeam (PK) name dob address tid (PK) name city PlaysAway matchDate (PK 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) M ap the given conceptual data model to a relational schema, indicating both primary and foreign keys.
Expert Answer
Answer to 1. There are three relationships between the entities Player, Team and Match as shown below: Player Match Team pid (PK) …