You have been asked to model the data requirements for football teams based on the following...

Transcribed Image Text:

You have been asked to model the data requirements for football teams based on the following description: Each football team has several players signed to it and competes in a football league. Each team is sponsored by one company although each company can sponsor more than one team. A player can be signed to only one team but it is also possible for a player not to be signed to any team (free agent). The details that are to be stored for each player are squad number, name, date of birth, nationality and player valuation. Each team has a team name, stadium name and established date. The details of the sponsor name and annual sponsorship also need to be recorded as well as the league number and league name that the team competes in. a) Represent the system description above as an Entity-Relationship Diagram. Ensure you have the correct cardinality and participation for each relationship. Include suitable attributes in your diagram. Indicate any assumptions you have made. b) Convert the ERD from part a) above to a relational model. A garage maintains a stock of parts for Renault cars. Each part has a part number, a description, and a price. The garage also records the quantity in stock for each part. The garage keeps a record of all cars they have worked on. Cars are identified by their registration number. The garage also records the car model and the owner's name, address and phone number. Cars can be booked in for a service or to mend a fault. The cost of the service will include the cost of labour as well as the cost of spare parts used. a) Represent the system description above as an Entity-Relationship Diagram. Ensure you have the correct cardinality and participation for each relationship. Include attributes in your diagram. b) Convert the ERD from part a) above to a relational model. You have been asked to model the data requirements for football teams based on the following description: Each football team has several players signed to it and competes in a football league. Each team is sponsored by one company although each company can sponsor more than one team. A player can be signed to only one team but it is also possible for a player not to be signed to any team (free agent). The details that are to be stored for each player are squad number, name, date of birth, nationality and player valuation. Each team has a team name, stadium name and established date. The details of the sponsor name and annual sponsorship also need to be recorded as well as the league number and league name that the team competes in. a) Represent the system description above as an Entity-Relationship Diagram. Ensure you have the correct cardinality and participation for each relationship. Include suitable attributes in your diagram. Indicate any assumptions you have made. b) Convert the ERD from part a) above to a relational model. A garage maintains a stock of parts for Renault cars. Each part has a part number, a description, and a price. The garage also records the quantity in stock for each part. The garage keeps a record of all cars they have worked on. Cars are identified by their registration number. The garage also records the car model and the owner's name, address and phone number. Cars can be booked in for a service or to mend a fault. The cost of the service will include the cost of labour as well as the cost of spare parts used. a) Represent the system description above as an Entity-Relationship Diagram. Ensure you have the correct cardinality and participation for each relationship. Include attributes in your diagram. b) Convert the ERD from part a) above to a relational model.