QUESTION 1 Requirements Specification (this is a fictional scenario) Continue your S3 assignment for a young soccer leag

[answerhappygod]

QUESTION 1
Requirements Specification (this is a fictional scenario)
Continue your S3 assignment for a young soccer league with thefollowing specification.
A player plays in a single team in a given season. However, theplayer may change the teams from a season to the next. For a playerwe keep the name (we want to search based on the last name), thedate of birth, the jersey number (which can change when the playerchanges the team or from a season to another) and the player homecity.
A coach coaches one or more teams per seasons, but at most 5. Ateam is coached by a single coach. For a coach we keep the name (wesearch based on first and last name), the date of birth, the yearstarting coaching and home zipcode.
For the new entities in S4, as applicable, the first, last andmiddle name components are at most 22 characters long. We storeZipcodes-5. Cities are at most 25 characters long.
Organize the persons associated with the league in ahierarchy.
Database Constraints for Step 4
Database Questions for Step 5
Your questions must work on any data, you must not assumeanything about the data when writing the question.
PLEASE I JUST NEED THE SQL CODE ESPECIALLY DATABASEQUESTION 4 AND 5