icots) A university database contains information about instructors Gidentified by social security mumber, or her, or SSN, with name, email address and office number as attributes) and courses (identified by aoratseid, with course name, session number). Instructors teach courses and can teach the same in several semesters, and each offering must be recorded. Every instructor teaches at least one and every course must be taught by some instructor Draw an ER diagram that captures this information. Page: 2 3. (20pts) Based on the following relational schema: Emp(eid: integer, name: string, birthday: date, salary: real, office: string) Works(eid integer, did integer, pcttime: integer) Dept(did: integer, dname: string, budget: real, location: string, managerid: integer) Write the SQL statements required to create the preceding relations, including appropriate versions of all primary and foreign key integrity constraints. a. 5/20, b. Write an SQL statement to add John William as an employee with eid-104, birthday salary $30, 000, and office "LRC 104