1. Create a Crow's Foot ERD. Write the relationship. 8 Points A PROFESSOR teaches one or more CLASSes. A DOCTOR writes one or more PRESCRIPTIONS. A PATIENT may receive one or more PRESCRIPTIONS. A DRUG may appear in one or more PRESCRIPTIONS. An EMPLOYEE may manage many EMPLOYEES, and each EMPLOYEE is managed by one EMPLOYEE. A COURSE may be a prerequisite to many other COURSEs, and each COURSE may have many other COURSEs as prerequisites. 2. Create an ERD based on the Crow's Foot notation, using the following requirements: 8 Points An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices. An INVOICE can include many detail lines (LINE), each of which describes one product bought by the customer. The product information is stored in a PRODUCT entity. The product's vendor information is found in a VENDOR entity. 3. The local city youth league needs a database system to help track children who sign up to play soccer. Data need to be kept on each team and the children who will be playing on each team and their parents. Also, data need to be kept on the coaches for each team. Draw the data model described below. 10 points 3. The local city youth league needs a database system to help track children who sign up to play soccer. Data need to be kept on each team and the children who will be playing on each team and their parents. Also, data need to be kept on the coaches for each team. Draw the data model described below. 10 points Entities required: Team, Player, Coach, and Parent. Attributes required: Team: Team ID number, Team name, and Team colors. Player: Player ID number, Player first name, Player last name, and Player age. Coach: Coach ID number, Coach first name, Coach last name, and Coach home phone number. Parent: Parent ID number, Parent last name, Parent first name, Home phone number, and Home Address (Street, City, State, and Zip Code). The following relationships must be defined: Team is related to Player. Team is related to Coach. Player is related to Parent. Connectivities and participations are defined as follows: A Team may or may not have a Player. A Player must have a Team. A Team may have many Players. A Player has only one Team. A Team may or may not have a Coach. A Coach must have a Team. A Team may have many Coaches. A Coach has only one Team. A Player must have a Parent. A Parent must have a Player. A Player may have many parents. A Parent may have many Players. 4. Create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. 10 Points A department employs many employees, but each employee is employed by only one department. Some employees, known as "rovers," are not assigned to any department. A division operates many departments, but each department is operated by only one division. An employee may be assigned many projects, and a project may have many employees assigned to it. A project must have at least one employee assigned to it. One of the employees manages each department, and each department is managed by only one employee. One of the employees runs each division, and each division is run by only one employee