Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribed

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 fbez

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

Step: 3

blur-text-image

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

Linked Data A Geographic Perspective

Authors: Glen Hart, Catherine Dolbear

1st Edition

1000218910, 9781000218916

More Books

Students also viewed these Databases questions