Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Task 3 You are given the following set of relations. COUNTRY (countryld, language, timezone, currency) REGION (regionld, landtype, page, scenery, country [FK: COUNTRY]) RESORT (resortld,
Task 3 You are given the following set of relations. COUNTRY (countryld, language, timezone, currency) REGION (regionld, landtype, page, scenery, country [FK: COUNTRY]) RESORT (resortld, page, region [FK: REGION], beachNo) HOTELS (hotelld, hotelname, resort [FK: RESORT], page, roomtotal, rating) FACILITIES (facld, description, category) FACINRESORT (resort [FK: RESORT], facld [FK: FACILITIES]) FACINHOTEL (hotelld [FK: HOTEL], facid [FK: FACILITIES], numof) Write the following queries as Relational Algebra Expressions. 1) Find all hotels which have swimming pool and disco. 2) Find all hotels which belong GTM+2 timezone. 3) Find all hotels which have more than 100 rooms. 4) Find all hotels which have more than 10 facilities 5) Find all hotels which are rated 5 out of 5
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