Please do not copy from others please!!

Thank you in advance

You have agreed to create a database for a kids' football union. The requirements for the database are as follows: The union is composed of some number of teams, each of which has a name, a budget, and a home park (the park where they play home games). The teams are coached by parents who have associate with them a unique id, a name, a home address, and the number of years they have coached. Equally important to the coaches are the drivers who shuttle the teams from the home park to the park at which a given game occurs. The drivers have names and addresses and drive vehicles that have maximum passenger occupancy and a maximum number of miles they can travel. The team players have a player id, name, position, age, gender, and weight. The parks are identified by a name and the city where it is located and have additional information of the number of football fields and address. Games between teams are played in a park on a specific date, at a certain starting time. Conduct the ER modeling for the database and draw an ER diagram using traditional ER notations. The ER diagram should include the followings: Indicate all entities and their attributes. Indicate primary keys for all entities. Indicate all relationships along with their attributes if exist. Indicate the following constraints. o cardinality constraints o participation constraints State any assumptions you make. Your assumptions should be logical