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

Topic: Database Which one of these option will slow down the execution of your queries? Indexes Query Optimizer Linear Search
SQL queries please, thank you. Will upvote, no copied answer please. Use SQL QUERIES to create and record a database of students participating in a class, the class will have 20 students and is attended 30 occasion each semesters. Please make the SQL queries so that I can track these records: A database record of those 20 students attending class in each date (out of those 30 occasions) A record of the dates of classes that a student has attended A record showing number of students that attended each day of class (out of the 30) Show running image of the program.
Write 5 queries with explanations for online book store system,(USE MySQL)-- Write 5 queries. Your queries should do a task that is meaningful in online book store system.-- At least one that joins two or more tables-- At least one that include group functions-- At least one with one or more sub-query(es)-- At least one update-- At least one delete-- At least one include arithmetic functions-- At least one uses alias
How to use LIKE in SQL?
used PL/SQL - Procedures Find the best selling product in March in Restaurant database ( i need cod )
Database Management Systems (SQL) Assume a company sells music albums. Each album consists of a few songs from a single artist. The tables used by this company are as follow: Artist: (The attributes describing an artist) Song: (the attributes of a song, includes a foreign key to Album) Album: (includes attributes of the album. Also includes a foreign key referring to Artist) Write necessary SQL commands to create the tables. Add necessary constraints including primary key, foreign key, not null, unique, etc. Write necessary SQL commands to add a few records to each table Query the database: 1. Find all albums belonging to an artist given his/her name 2. Given the name of a song, find the album name and the artist 3. Find out how many songs have been included in an album given the album name 4. Find out the total number of songs of an artist given his/her name 5. Add an attribute to the song table named genre. Update the values of all records giving meaningful genre attribute values to…
What is the case when in SQL Server?
What is the solution for this question (sql queries)
Im having trouble with the code. So do I place all these codes in one page? the query.sql?
1- What activities can be automated using PL/SQL, give 3 examples.
Please answer the following question about SQL
DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted directly. Thank you!