The following tables form part of a database held in a relational DBMS ( Primary Key ,
Fantastic news! We've Found the answer you've been seeking!
Question:
The following tables form part of a database held in a relational DBMS (Primary Key,Foreign Key):
Book (Book_ID, Publisher, Type, Year, Edition, Price)
Employee (Employee_No, FirstName, LastName, Role)
EmployeeBook (Book_ID,Employee_No, Date_Taken, Date_Returned)
Give the relational algebra (not SQL) expressions for each of the queries in Question 2:
- List the numbers of Books taken by each IT Officer
- Show the employees who have taken more than two Books
- List the maximum number of Books taken by any Employee
- Show the Employees who are Managers and have not taken any Book
- List the full details of the most expensive as well as the cheapest Book.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: