Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ul alfa- 7:26 PM 27% CSC1335L Final Sam... Page 1 of 2 CSC1335L Sample Final Consider the following tables for the EmployeeInfo database: Employee_Info (employee_id,
ul alfa- 7:26 PM 27% CSC1335L Final Sam... Page 1 of 2 CSC1335L Sample Final Consider the following tables for the EmployeeInfo database: Employee_Info (employee_id, username, first_name, last_name, gender, password, job ip); Job (job id position, salary); Primary keys are underlined. There are foreign key constraints on Employee_Info.job_id referencing Job. Answer the following questions: 1. Display the number of jobs with salary greater than 3000. [5 points) 2. Display the second highest salary of the proposed jobs. [10 points) 3. Display the lowest salary and name it as "The lowest salary" [10 points) 4. Display the sum of salaries between 3000 and 3999. [10 points) 5. Display all jobs not Ito any employee. [10 points) 6. Display the data of the data of the employees having the most paid salary. [10 points) 7. Find, for each job position, the number of times it has been assigned to the employees (15 points) 8. Find the positions assigned more than twice to the employees [10 points). the average number of salaries. [5 points) 10. Display the number of employees for each gender. [5 points) 11. Suppose that each of the following operations is applied directly to the above database state. Discuss all integrity constraints violated by each operation, if any, and the different ways of enforcing these constraints. [10 points a. Insert into Job b. Insert 8. 'HR Coordinator',750> into Job c. Delete from Job where job_id-2 Page 2 of 2
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started