can you please do this

(37 points) Q1 A. Consider the following ER diagram. Write SQL statements to create the corresponding tables and capture as many of the constraints as possible (create 2 tables only). name date ssn pid sponsor age mployee Work Project B. Assume we have the following instances for two tables Employee and Project: Project Employee pio 100 102 sponsor Computer Science Biolo Ssn name 5380 Guldu 5381Ali 5382 Jil age 30 32 27 Assume Jill and Ali work on project 100. What will be the new instances of the tables Employee and Project after running the following query? DELETE FROM Project P WHERE P.pid-'100 (35 points) Q2. Consider the following relations Student(sid: integer, sname: string, major: string, level: string, age: integer) Class(cname: string, meets at: string, room: string, fid: integer) Enrolled(sid: integer, cname: string) Faculty(fid: integer, fname: string, deptid: integer)