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
Redo Logs: Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type


Describe Interfaces for the DBA? Interfaces for the DBA - Most database systems holds privileged commands which could be used only through the DBA's staff. These involves com

waht is a repeating group?

Define the categories of SQL Statements? 1) Statements that don't return a result set. This statement class includes INSERT, DELETE, and UPDATE. 2)Statements that return

write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.

Briefly explain each of the following database terms. Use no more than 2-3 lines for each term. 1. DBMS 2. Update Anomaly 3. Alias (referring to tables in SQL queries)

Define and differentiate between ordered indexing and hashing. Ans: Ordered indexing: To gain fast random access to records in a file, we can make of an index structure. Every

how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

Write short notes on domain relational calculus The domain relational calculus uses domain variables that take on values from an attribute domain rather than values for whole t