Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro Database Migration To Azure Data Modernization For The Enterprise

Authors: Kevin Kline, Denis McDowell, Dustin Dorsey, Matt Gordon

1st Edition

1484282299, 978-1484282298

Students also viewed these Databases questions

Question

Have roles been defined and assigned?

Answered: 1 week ago