Database Schema for a Employee-pay scenario employee(emp_id: integer, emp_name: string) department(dept id: integer, dept_name:string) paydetails(emp_id :...

Transcribed Image Text:

Database Schema for a Employee-pay scenario employee(emp_id: integer, emp_name: string) department(dept id: integer, dept_name:string) paydetails(emp_id : integer, dept_id: integer, basic: integer, deductions: integer, additions: integer, DOJ: date) payroll(emp_id: integer, pay_date: date) For the above schema, perform the following- a) Create the tables with the appropriate integrity constraints Insert around 10 records in each of the tables List the employee details department wise List all the employee names who joined after particular b) c) d) date e) List the details of employees whose basic salary is between 10,000 and 20,000 f) Give a count of how many employees are working in each department g) h) i) Give a names of the employees whose netsalary> 10,000 List the details for an employee_id=5 Create a view which lists out the emp_name, department, basic, dedeuctions, netsalary j) Create a view which lists the emp_name and his netsalary Database Schema for a Employee-pay scenario employee(emp_id: integer, emp_name: string) department(dept id: integer, dept_name:string) paydetails(emp_id : integer, dept_id: integer, basic: integer, deductions: integer, additions: integer, DOJ: date) payroll(emp_id: integer, pay_date: date) For the above schema, perform the following- a) Create the tables with the appropriate integrity constraints Insert around 10 records in each of the tables List the employee details department wise List all the employee names who joined after particular b) c) d) date e) List the details of employees whose basic salary is between 10,000 and 20,000 f) Give a count of how many employees are working in each department g) h) i) Give a names of the employees whose netsalary> 10,000 List the details for an employee_id=5 Create a view which lists out the emp_name, department, basic, dedeuctions, netsalary j) Create a view which lists the emp_name and his netsalary

Answer rating: 100% (QA)

11 a bx eyx X eyx 11 x abx log y x log ... View the full answer