database

QUESTION 2 Answer both() and (b) The followme information that made a male rughy squad, the games they play and the players cach.com In the dewen we want to capture the following We have a set oftcams.cach team has an ID (unique identifieri, come Home Grounds, and crty they are the Each team has many players, and each player belongs to one team. Each player has a number onique dentific, name, Dok, start year, and jersey number that he uses Teams play matches, in cach match there is a home team and an away team. The match takes place on the home grounds of the hort Icam . For each match we need to keep track of the following . The date on which the game is played . The final result of the match The players participated in the match. For each player, how many try's he scored, whether or not he was awarded a yellow, and whether or not got a red card. . During the match, one player may substitute another player. We want to capture this substitution and the time at which it took place Each match has exactly Four referees. For each referee we have an ID (unique identifier), name, Dob, years of experience. One referee is the main referee and the other two are assistant referees and the last is a Television Match Official (TMO). You are required to draw an entity relationship diagram (ERD) representing the above model. Be sure to list any assumptions you make and show all attributes for each entity. Scanned with CamScanner (15 marks) (b) Convert your ERD to a set of relations. (a) 110 marks)