database managemet system please use data for first question

i say use first question data of all the questions

Question 5 (20 points) Which employee has the maximum number of dependents. List SSN, first name and last name of the emloyee. Hint: Use inner query with IN or NOT IN operator whichever is appropriate. Grading : Displayed next to each question Where to upload : Blackboard MAKEUP EXAM/UPLOAD MAKEUP EXAM Question 1 (20 points) Given the Crow's Foot notation for the Movie Database below: a) Write the database requirements for the Movie database. b) Draw the Entitiy-Relationship Diagram (ERD) for the Movie Database using Chen's notation. If you like you can draw on paper by hand and then scan it and paste it in this document. EMPLOYEE DEPARTMENT DEPT LOCATIONS \begin{tabular}{|l|c|c|c|} \hline \multicolumn{1}{|c|}{ Dname } & Domber & Mos sen & Mor_start date \\ \hline Research & 5 & 333445555 & 198805.22 \\ \hline Administration & 4 & 967654321 & 19950101 \\ \hline Headquarters & 1 & 886865555 & 19810619 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Derumber & Dlocation \\ \hline 1 & Houston \\ \hline 4 & Stattord \\ \hline 5 & Bolaine \\ \hline 5 & Sugarand \\ \hline 5 & Houaton \\ \hline \end{tabular} WORKS_ON PROJECT \begin{tabular}{|c|c|c|} \hline Essn & Pro & Houm \\ \hline 123456789 & 1 & 32. \\ \hline 123456789 & 2 & 25 \\ \hline 666881111 & 3 & 10.0 \\ \hline 453453453 & 1 & 20.0 \\ \hline 403463463 & 2 & 200 \\ \hline 333446666 & 2 & 10.0 \\ \hline 333445555 & 3 & 10.0 \\ \hline 333445555 & 10 & 10.0 \\ \hline 333445555 & 20 & 10.0 \\ \hline 999887777 & 30 & 30.0 \\ \hline 999887777 & 10 & 10.0 \\ \hline 997987997 & 10 & 25.0 \\ \hline 987987987 & 30 & 5.0 \\ \hline 987654321 & 30 & 20.0 \\ \hline 987654321 & 20 & 15.0 \\ \hline 988665555 & 20 & NULL \\ \hline \end{tabular} DEPENDENT database schema given above write the queries in Questions 2-5 using the SQL nota SS. List the first name and last name of all supervisors who supervise the employees working for the "Research" department. Order the list by supervisor first name in ascending order. Write an UPDATE query to decrease the salary of employees working on the "ProductY" project by 5% How many supervisees does each of the supervisors working for "Research" department have? Question 5 ( 20 points) Which employee has the maximum number of dependents. List SSN, first name and last name of the emloyee. Hint: Use inner query with IN or NOT IN operator whichever is appropriate. Question 5 (20 points) Which employee has the maximum number of dependents. List SSN, first name and last name of the emloyee. Hint: Use inner query with IN or NOT IN operator whichever is appropriate. Grading : Displayed next to each question Where to upload : Blackboard MAKEUP EXAM/UPLOAD MAKEUP EXAM Question 1 (20 points) Given the Crow's Foot notation for the Movie Database below: a) Write the database requirements for the Movie database. b) Draw the Entitiy-Relationship Diagram (ERD) for the Movie Database using Chen's notation. If you like you can draw on paper by hand and then scan it and paste it in this document. EMPLOYEE DEPARTMENT DEPT LOCATIONS \begin{tabular}{|l|c|c|c|} \hline \multicolumn{1}{|c|}{ Dname } & Domber & Mos sen & Mor_start date \\ \hline Research & 5 & 333445555 & 198805.22 \\ \hline Administration & 4 & 967654321 & 19950101 \\ \hline Headquarters & 1 & 886865555 & 19810619 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Derumber & Dlocation \\ \hline 1 & Houston \\ \hline 4 & Stattord \\ \hline 5 & Bolaine \\ \hline 5 & Sugarand \\ \hline 5 & Houaton \\ \hline \end{tabular} WORKS_ON PROJECT \begin{tabular}{|c|c|c|} \hline Essn & Pro & Houm \\ \hline 123456789 & 1 & 32. \\ \hline 123456789 & 2 & 25 \\ \hline 666881111 & 3 & 10.0 \\ \hline 453453453 & 1 & 20.0 \\ \hline 403463463 & 2 & 200 \\ \hline 333446666 & 2 & 10.0 \\ \hline 333445555 & 3 & 10.0 \\ \hline 333445555 & 10 & 10.0 \\ \hline 333445555 & 20 & 10.0 \\ \hline 999887777 & 30 & 30.0 \\ \hline 999887777 & 10 & 10.0 \\ \hline 997987997 & 10 & 25.0 \\ \hline 987987987 & 30 & 5.0 \\ \hline 987654321 & 30 & 20.0 \\ \hline 987654321 & 20 & 15.0 \\ \hline 988665555 & 20 & NULL \\ \hline \end{tabular} DEPENDENT database schema given above write the queries in Questions 2-5 using the SQL nota SS. List the first name and last name of all supervisors who supervise the employees working for the "Research" department. Order the list by supervisor first name in ascending order. Write an UPDATE query to decrease the salary of employees working on the "ProductY" project by 5% How many supervisees does each of the supervisors working for "Research" department have? Question 5 ( 20 points) Which employee has the maximum number of dependents. List SSN, first name and last name of the emloyee. Hint: Use inner query with IN or NOT IN operator whichever is appropriate