Write a query to find name from the relational algebra, Database Management System

Consider the relations
City (city_name, state)
Hotel (name, address)
City_hotel (hotel_name, city_name, owner)

Answer the following queries in relational algebra
(i) Find out the names and address of hotels in Agra.
(ii) List the names of cities that have no hotel.
(iii) List the names of the hotels owned through ‘Taj Group'.

Ans: (i) Π name, address ( σ city_name= ‘Agra' (Hotelname=city_name City_hotel))
(ii) Π city_name (City) - Π city_name(City_hotel)
(iii) Π hotel_name ( σ owner='Taj Group' (City_hotel))

Posted Date: 5/11/2013 4:02:50 AM | Location : United States







Related Discussions:- Write a query to find name from the relational algebra, Assignment Help, Ask Question on Write a query to find name from the relational algebra, Get Answer, Expert's Help, Write a query to find name from the relational algebra Discussions

Write discussion on Write a query to find name from the relational algebra
Your posts are moderated
Related Questions
Failure Controlling Methods: Failures can be handled using different recovery methods that are talk about later in the unit. But the first question is doing we really require recov

Fragmentation: It is definite as partitioning of a relation into various fragments.Every fragment can be stored at a dissimilar site.

Illustrate the State model for the ATM class let us take state model for the ATM class given below in Figure showing state model of the ATM class and the pseudo code derived fr

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

What Is Sql?  Structured Query Language (SQL) is a standard query language. It is usually used with all relational databases for data manipulation and definition. All the re

List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

Short Note on mid Square Method of hashing? Mid square method of hashing: In the method midsquare hashing, the key is squared and the address selected from the center of the s

Example: RELATIONAL SCHEMA for PERSON: PERSON (PERSON_ID: integer, NAME: string, AGE: integer, ADDRESS: String) RELATION INSTANCE In this instance, m = 3 and n = 4

Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass