Use the ERD to respond to the following questions. Supply your code below.

1. Describe the cardinality of the tables within the ERD.

2. Write the DDL for each of the 6 tables above, including all constraints.

3. Write the DQL for the following:

All Employees, their titles, salaries, and the department they work for making over fifty thousand dollars.

All department managers information, his or her department information, and start date.

Total salary paid to all employees in each department.

Average number of managers per department.

Total number of department managers.

4. Write the DML for the following:

Updating a department manager.

Inserting a new employee, their salary, title, and department association.

Insert a new department.

Delete an employee.

salaries v emp no INT(10) salary INT (11) from date DATE to date DATE Indexes titles emp no INT(10) title VARCHAR(50) from date DATE to date DATE Indexes employees v emp no INT(10) birth date DATE first name VARCHAR(14) last name VARCHAR(16) t gender ENUM(M', F) hire date DATE Indexes dept manager dept no CHAR(4) emp no INT(10) from date DATE to date DATE Indexes dept emp emp no INT(10) dept no CHAR(4) from date DATE to date DATE Indexes LU departments dept no CHAR(4) dept name VARCHAR(40) Indexes