Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following tables form part of a database held in a relational DBMS: Hotel ( hotelNo , hotelName, city ) Room ( roomNo , hotelNo,
The following tables form part of a database held in a relational DBMS:
Hotel hotelNo hotelName, city
Room roomNo hotelNo, type, price
Booking hotelNo guestNo, dateFrom, dateTo, roomNo
Guest guestNo guestName, guestAddress
where Hotel contains hotel details and hotelNo is the primary key;
Room contains room details for each hotel and roomNo hotelNo forms the primary key;
Booking contains details of the bookings and hotelNo guestNo, dateFrom forms the primary key;
and Guest contains guest details and guestNo is the primary key.
Using the above information which answer best represents this RA statement: sigma space g u e s t N a m e comma space g u e s t A d d r e s s space left parenthesis G u e s t right parenthesis
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started