Obtain the house numbers street wise from database, Database Management System

Assignment Help:

For the relations answer the following queries in SQL
Street (name, location, city)
House (number, street_name)
Lives (name, house_number)
(i) Obtain the names of persons who live in the street named ‘Mahatma Gandhi'.
(ii) Obtain the house numbers street wise.
(iii) Obtain the numbers of houses which are not occupied.

(i) Select lives.name from Street, House, Lives where Street.name = House.street_name and House. Number = Lives. House_number and street_name =
‘Mahatma Gandhi';
(ii) Select number from House
order by street_name;
(iii) Select number from house
minus
Select house_number from lives;


Related Discussions:- Obtain the house numbers street wise from database

Explain the terms data warehousing and data mining, Question: i) Explai...

Question: i) Explain the terms data warehousing and data mining. ii) Discuss the importance of the following security principles that a digital firm should amongst others, n

What are the requirements of algorithm designer, What are the Requirements ...

What are the Requirements of algorithm designer Algorithm designer should: i) Select proper algorithm so as to minimize implementation cost ii) Find most appropriate d

Oracle, how oracle can be used

how oracle can be used

Datawarehouse, Define a job scheduling strategy that will meet business req...

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Distributed database management system, Question (a) Differentiate betw...

Question (a) Differentiate between the following terms: (i) Distributed Database v/s Distributed Database management System (ii) Homogeneous Distributed Database v/s Hete

Need for client server computing, Need for Client Server Computing- Client/...

Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

Explain saving derived attributes to avoid re-computation, Saving Derived A...

Saving Derived Attributes to Avoid Re-computation   As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

Although how will the system recover, Although how will the system recover ...

Although how will the system recover The selection of REDO or UNDO for a transaction for the recovery is completed on the basis of the state of the transactions. This state is

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd