EMPLOYEE Sex Salary Super_ssn Dno M 40000 888665555 5 43000 888665555 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 5 Fname Minit Lname Ssn Bdate Address Wong Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Franklin т 333445555 1955-12-08 638 Voss, Houston, TX Jennifer F 4 Ramesh K 1. Use above relation EMPLOYEE and write the relational algebra query. a) Retrieve the records form EMPLOYEE whose department is 4. b) Select the tuples where salary > 40000. c. Retrieve the records of all employee who are Male and work for department number 5. 2. Use above relation EMPLOYEE and write the relational algebra query. i a) List each employee's First name, Last name and salary. b) List First name, Last name and salary of all employees who work in department number 5. 3. Convert the given below relational algebra operation into relational query. a) ((Dno=4 AND Salary > 30,000) (EMPLOYEE) b) e. (Fname, Lname, Salary( ( Dno=5(EMPLOYEE))

EMPLOYEE Sex Salary Super_ssn Dno M 40000 888665555 5 43000 888665555 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 5 Fname Minit Lname Ssn Bdate Address Wong Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Franklin т 333445555 1955-12-08 638 Voss, Houston, TX Jennifer F 4 Ramesh K 1. Use above relation EMPLOYEE and write the relational algebra query. a) Retrieve the records form EMPLOYEE whose department is 4. b) Select the tuples where salary > 40000. c. Retrieve the records of all employee who are Male and work for department number 5. 2. Use above relation EMPLOYEE and write the relational algebra query. i a) List each employee's First name, Last name and salary. b) List First name, Last name and salary of all employees who work in department number 5. 3. Convert the given below relational algebra operation into relational query. a) ((Dno=4 AND Salary > 30,000) (EMPLOYEE) b) e. (Fname, Lname, Salary( ( Dno=5(EMPLOYEE))

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

Relational databases store data in tables that are organized into columns and rows, sometimes called records and cells. T or F
Explain the steps involved in data processing.
Explain how a repository affects computer system development.
Briefly explain whether you can create your system database or any database and put it in the System Databases folder.
Explain how to create a physical database.
Explain the concept of spatial data types in a database system. Provide examples of applications where spatial data types are crucial.
Data hedling
Data refers to the format in which data is stored, processed, and transferred.
large scale database