A hotel "Nyaman" requires a system to be used for the hotel management. Below are the database specifications to build t

[answerhappygod]

A hotel "Nyaman" requires a system to be used for the hotelmanagement. Below are the database specifications to build thesystem:
EMPLOYEE : Employee_name, Employee_ID, Position, Phone, Address,StartWorking_Year.
GUEST: Guest_name, Guest_ID, Address, Phone,Duration_of_Stay
ROOM: Room_ID, Room_Qty, Room_type, Price
TRANSACTION_IN: TransactionIN_ID, Reservation, checkin_Date,Guest_ID, Employee_ID
TRANSACTION_OUT: TransactionOUT_ID, checkout_Date, Guest_ID,Employee_ID
The employee records every guest they have. A guest can order 1or more rooms.Every room have a different facility with one another, thereforehave a different price.The employee records every transaction in and out.
Based on the case:
a) Write the relational algebra to display Guest_name,Guest_ID where the guests don't stay for over 2days.
b) Write the relational algebra to display Room_ID,Room_type, Price where the price is the mostexpensive.
c) Write the relational algebra to display Employee_nameand Employee_ID who has never made a transactionin or out