(Solved) : 1 Three Relationships Entities Player Team Match Shown Player Match Team Pid Pk Playshomeh Q35008676 . . .

determine the multiplicity plz1. There are three relationships between the entities Player, Team and Match as shown below: Player Match Team pid (PK) Has P1. 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) …

Leave a Comment

About

We are the best freelance writing portal. Looking for online writing, editing or proofreading jobs? We have plenty of writing assignments to handle.

Quick Links

Browse Solutions

Place Order

About Us