Question: Problem 2. (Based on Exercise 5.10) (35pts] Consider again the following relational schema. The meaning of each relation and attribute is straight- forward. Again, the
![Problem 2. (Based on Exercise 5.10) (35pts] Consider again the following](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f38e7607bdb_74966f38e757245c.jpg)
Problem 2. (Based on Exercise 5.10) (35pts] Consider again the following relational schema. The meaning of each relation and attribute is straight- forward. Again, the managerid refers to the employee (eid) that is the manager of this department. Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, since: date) Dept (did: integer, dname: string, budget: real, managerid: integer) Write SQL integrity constraints (domain, key, foreign key, or CHECK constraints; or assertions) or SQL triggers to ensure each of the following requirements, considered independently. You have to give the CREATE TABLE statements for each relation and you can modify it to add constraints if needed. 1. Employees must make a minimum salary of $1000. 2. Every manager must be also be an employee. 3. The budget of a department must be larger than the sum of the salaries of the employees that work in this department. 4. A manager must always have a higher salary than any employee that he or she manages. 5. Whenever an employee is given a raise, the manager's salary must be increased to be at least as much
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
