Consider the following relational data model.Employee (empid, ename, address, title, headid)Works (Empid,Deptid,joindate)Department (Deptid, dname, block)Payment (title, salary)A) Write relational algebra forDisplay the employee name and department name of each employee.Display the employee who works as senior lecturer and belongs to BEI or BCT department.Display the employee name with corresponding department head. B) Write sql query forCreating the above relations; including appropriate versions of all primary and foreign key constraintsFind the employee name and address whose address name ends with substring ‘pur’.Update the salary of senior lecturer by 25%.(Solve A - 1,2,3 only)

The given relational data model consists of four relations: Employee, Works, Department, and…

Answered: Consider the following relational data…

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

Related questions

Question

Consider the following relational data model.

Employee (empid, ename, address, title, headid)

Works (Empid,Deptid,joindate)

Department (Deptid, dname, block)

Payment (title, salary)

A) Write relational algebra for

Display the employee name and department name of each employee.
Display the employee who works as senior lecturer and belongs to BEI or BCT department.
Display the employee name with corresponding department head.

B) Write sql query for

Creating the above relations; including appropriate versions of all primary and foreign key constraints
Find the employee name and address whose address name ends with substring ‘pur’.
Update the salary of senior lecturer by 25%.

(Solve A - 1,2,3 only)

Expert Solution

Step by step

Solved in 5 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions