Conside the relations, City (city_name, state) and Hotel (name, addres

1.	Conside the relations, City (city_name, state) and Hotel (name, address, city_name). Answer the following queries in relational algebra (a) Find the names and address of hotels in Kochi. (b) List the details of cities in Kerala state. (c) List the names of the hotels in Thrissur. (d) Find the names of different hotels. (e) Find the names of hotels in Kozhikode or Munnar.
Answer» (a) π_{name, address} (σ city_name = "kochi"(Hotel)) (b) π_city__name(σ state = "kerala"(city)) (c) π_name(Hotel) (d) π_name(σ city_name = "kozhikodi"V city_name = "Munnar"(Hotel))

Conside the relations, City (city_name, state) and Hotel (name, address, city_name). Answer the following queries in relational algebra (a) Find the names and address of hotels in Kochi. (b) List the details of cities in Kerala state. (c) List the names of the hotels in Thrissur. (d) Find the names of different hotels. (e) Find the names of hotels in Kozhikode or Munnar.

Answer»

(a) π_{name, address} (σ city_name = "kochi"(Hotel))

(b) π_city__name(σ state = "kerala"(city))

(d) π_name(σ city_name = "kozhikodi"V city_name = "Munnar"(Hotel))