Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help making this into a database The following tables form part of a database held in a relational DBMS:- HOTEL ROOM (HOTELNO, HOTELNAME, CITY)
Need help making this into a database
The following tables form part of a database held in a relational DBMS:- HOTEL ROOM (HOTELNO, HOTELNAME, CITY) (ROOMNO, HOTELNO, RTYPE, PRICE) Hotel Room HOTELNO HOTELNAME CITY ROOMNO HOTELNO RTYPE PRICE fbei Grosvenor London Sez fbel fbei fbe2 watergate single 19 double 29 family 39 Paris 701 fbei chei London Omni Shoreham Phoenix Park 1001 fbe2 single 58 chez London 1101 fbe2 dcei Lathan Berlin double 86 single 29.99 1001 chei Formulate the additional queries in relational algebra. 1. Create the following relation that results from applying a UNION relational operatorto the tables Hotel and Room HOTELNO chei chez dce1 fbei fbe2 2. Create the following relation that results from applying a INTERSECT relational operatorto the tables Hotel and Room HOTELNO chei che2 fbei fbezStep 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