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

Explain the various kinds of database queries and transactions.
List the functions of a database application.
DML refers to the language used to manipulate data. Explain what it is.
Define the terms "DBMS" (Database Management System) and "RDBMS" (Relational Database Management System). Explain why relational databases are widely used.
accessing and modifying data in a relational database with a computer programming language
What is information. Explain types of information.
Explain the different types of databases and their uses.
Describe the process of designing and developing a database.
Relational databases store data in tables that are organized into columns and rows, sometimes called records and cells. T or F
What is physical and logical blog explain it (database question)
Explain how patent rights may be used economically and protected.
Explain the role of the database administrator in the development, implementation and maintenance of a database system.