3. a) Consider the following relational database model: Employee (eid, ename, email, phone, address) Department (dept_id, dname, block) Designation (did, title, salary) Works (eid, dept_id, did, effective_date) Write relational algebra expression for the following: (i) List all the designation title with starting letter 'M'. (ii) List the name and id of employees who worked for 10 years in the same department. (iii) Find the total salary that should be paid by the organization every month. (iv) List all the employees who are from KTM and works in ADMIN department. b) For the relational database model given in the Question no.3. Write SQL statements f the following: (i) List the name, email of all employees from electronics department who have join the department in this month. (ii) List the name, designation of the employee with their monthly salary. (iii) List the name of the departments having more than 10 employees. (iv) Find the highest paying employee's name for each department.

3. a) Consider the following relational database model: Employee (eid, ename, email, phone, address) Department (dept_id, dname, block) Designation (did, title, salary) Works (eid, dept_id, did, effective_date) Write relational algebra expression for the following: (i) List all the designation title with starting letter 'M'. (ii) List the name and id of employees who worked for 10 years in the same department. (iii) Find the total salary that should be paid by the organization every month. (iv) List all the employees who are from KTM and works in ADMIN department. b) For the relational database model given in the Question no.3. Write SQL statements f the following: (i) List the name, email of all employees from electronics department who have join the department in this month. (ii) List the name, designation of the employee with their monthly salary. (iii) List the name of the departments having more than 10 employees. (iv) Find the highest paying employee's name for each department.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

1- What activities can be automated using PL/SQL, give 3 examples.
Please answer the following question about SQL
Answer the following SQL questions using MySQL command language in MySQL Workbench, sakila database environment!
Please please all questions solve
Please solve question no. 10 including screenshots of SQL results.
DVD Rental • DVD: Title, Director, Serial, Genre, Year Published • Customers: Customer ID, Name, Address, Email • Rentals: RentNum, Rent Date, Due Date, Customer ID, Serial • Employee: Employee ID, Name, Address, Email • Transactions: Transaction ID, Customer ID, Serial, Date 1. Write necessary SQL commands to create tables and input data to each table. 2. Write the queries using SQL statements. Show the output of your SQL queries using screen shot (a) Three queries for one table. (b) Three queries for two tables. (c) Three queries for three tables.
v