Page 1 of 1
Question 2 SQL queries (10 marks) Consider the following relational schema and briefly answer the questions that follow:
Posted: Mon Jun 06, 2022 5:33 pm
by answerhappygod
- Question 2 Sql Queries 10 Marks Consider The Following Relational Schema And Briefly Answer The Questions That Follow 1 (34.9 KiB) Viewed 50 times
Question 2 SQL queries (10 marks) Consider the following relational schema and briefly answer the questions that follow: Emp (eid: integer, ename: string, age: integer, salary: real) Works (eid: integer, did: integer, pct_time: integer) Dept (did: integer, budget: real, managerid: integer) a. Define a table constraint on Emp that will ensure that every employee's salary is greater than $30,000. (4 marks) b. Write SQL statements to delete all information about managers whose salaries are more than three times of the average salary of the employees in the department. Be sure to ensure that all the relevant integrity constraints are satisfied after your updates. (6 marks)