Question 2 SQL queries (10 marks) Consider the following relational schema and briefly answer the questions that follow:

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Question 2 SQL queries (10 marks) Consider the following relational schema and briefly answer the questions that follow:

Post by answerhappygod »

Question 2 Sql Queries 10 Marks Consider The Following Relational Schema And Briefly Answer The Questions That Follow 1
Question 2 Sql Queries 10 Marks Consider The Following Relational Schema And Briefly Answer The Questions That Follow 1 (34.9 KiB) Viewed 30 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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”