Use relational algebra to generate reports for the following databases.

#1

Hotel (HotelNo, Name, Address)

Room (RoomNo, HotelNo, Type, Price)

Booking (HotelNo, GuestNo, DateFrom, DateTo, RoomNo)

Guest (GuestNo, Name, GuestAddress)

-> List the details of all rooms at Hotel MIS, including the name of the guest staying in the room if the room is occupied during January 2022. The report contains HotelNo, RoomNo, HotelNo, Type, Price, GuestNo, GuestName, DateFrom, DateTo.

#2

Employee (empNo, fName, lName, address, DOB, sex, position, deptNo)

Department (deptNo, deptName, mgrEmpNo)

Project (projNo, projName, deptNo)

WorksOn (empNo, projNo, dateWorked, hoursWorked)

-> For each project on which more than ten employees worked on February 9, 2022, list the project number, project name, and the number of employees who work on that project.

#3

Book (ISBN, title, edition, year)

BookCopy (copyNo, ISBN, available)

Borrower (borrowerNo, borrowerName, borrowerAddress)

BookLoan (copyNo, dateOut, dateDue, borrowerNo)

-> For each book title with more than 5 copies list the borrower number and borrower name who have borrowed them during last year (2021). The report contains title, ISBN, borrowerNo, borrowerName.

#4

Branch (Bno, Street, Area, City, Pcode, Tel_No, Fax_No)

Staff (Sno, FName, LName, Address, Tel_No, Position, Sex, DOB, Salary, NIN, Bno)

Property (Pno, Street, Area, City, Pcode, Type, Rooms, Rent, Ono, Sno, Bno)

Renter (Rno, Fname, Lname, Address, Tel_No, Pref_Type, Max_Rent)

Owner (Ono, Fname, LName, Address, Tel_No)

Viewing (Rno, Sno, Pno, Date, Comment)

-> A list of staff members (Sno, Fname, Lname, Position, Sex, DOB, Salary, Bno) who only manage apartment and located at Tahoe.