please use information for first question and solve each one of them.

Givon 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|}{ Doame } & Doumber & Mos sen & Mor_start date \\ \hline Research & 5 & 333445555 & 198805.22 \\ \hline Administration & 4 & 967654321 & 19950101 \\ \hline Headquanters & 1 & 888665555 & 19810619 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Derumber & Dlocation \\ \hline 1 & Houston \\ \hline 4 & Staftord \\ \hline 5 & Belaine \\ \hline 5 & Sugarland \\ \hline 5 & Hounton \\ \hline \end{tabular} WORKS_ON PROJECT \begin{tabular}{|c|c|c|} \hline Essn & Pro & Hours \\ \hline 123456789 & 1 & 32. \\ \hline 123456789 & 2 & 75 \\ \hline 666881111 & 3 & 10.0 \\ \hline 453453453 & 1 & 20.0 \\ \hline 453463453 & 2 & 20n \\ \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 987987987 & 10 & 25.0 \\ \hline 987987987 & 30 & 5.0 \\ \hline 987654321 & 30 & 20.0 \\ \hline 987654321 & 20 & 16.0 \\ \hline 888665555 & 20 & NULL \\ \hline \end{tabular} \begin{tabular}{|l|c|l|c|} \hline \multicolumn{1}{|c|}{ Prame } & Phumber & Plocation & Doum \\ \hline Product & 1 & Bellaire & 5 \\ \hline ProductY & 2 & Sugarland & 5 \\ \hline ProdueZ & 3 & Hoveton & 5 \\ \hline Computerzation & 10 & Statlord & 4 \\ \hline Ruryericaliun & 20 & Hrwaton & 1 \\ \hline Nowbenotha & 00 & Slaflord & 4 \\ \hline \end{tabular} DEPENDENT \begin{tabular}{|l|l|c|c|l|} \hline Esan & Dependent name & Sex & Bdate & Relaborahip \\ \hline 333445555 & Aice & F & 19860405 & Davahter \\ \hline 333445555 & Thoodore & M & 10831025 & Son \\ \hline 333446560 & Jyr & F & 19080003 & Spvas \\ \hline 987654321 & Abner & M & 19420228 & Spouse \\ \hline 123456789 & Michael & M & 19880104 & Son \\ \hline 123456789 & Mice & F & 19881230 & Daughter \\ \hline 123456789 & Eliabeth & F & 19670505 & Spouse \\ \hline \end{tabular} database schema given above write the queries in Questions 2-5 using the SQL note ss. Givon 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 } & Doumber & Mor_ssn & Moz_star date \\ \hline Rosoarch & 5 & 333445555 & 19880522 \\ \hline Administration & 4 & 987654321 & 19950101 \\ \hline Headquartors & 1 & 888665555 & 19810619 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Deumber. & Dlocation \\ \hline 1 & Houston \\ \hline 4 & Staftord \\ \hline 5 & Belaire \\ \hline 5 & Sugarland \\ \hline 5 & Hounton \\ \hline \end{tabular} WORKS ON PROJECT \begin{tabular}{|c|c|c|} \hline Essn & Pno & Hours \\ \hline 123456789 & 1 & 32.5 \\ \hline 123456789 & 2 & 75 \\ \hline 666061111 & 3 & 10.0 \\ \hline 453453453 & 1 & 20.0 \\ \hline 453453463 & 2 & 200 \\ \hline 333445666 & 2 & 10.0 \\ \hline 333445555 & 3 & 10.0 \\ \hline 333445555 & 10 & 10.0 \\ \hline 333445555 & 20 & 10.0 \\ \hline 999867777 & 30 & 30.0 \\ \hline 999867777 & 10 & 10.0 \\ \hline 967067987 & 10 & 35.0 \\ \hline 987987987 & 30 & 5.0 \\ \hline 987654321 & 30 & 20.0 \\ \hline 987654321 & 20 & 15.0 \\ \hline 988665655 & 20 & NULL \\ \hline & & \\ \hline \end{tabular} DEPENDENT database schema given above write the queries in Questions 2-5 using the SQL note 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%