You want to find about the Universities that offer Programmes in Computer Science and Information Technology but does not offer programmes in Medical Science. Make efficient query or queries that will show the desired result as above. Also explain the activities performed by a search engine.
Answers
You want to find about the Universities that offer Programmes in Computer Science and Information Technology but does not offer programmes in Medical Science. Make efficient query or queries that will show the desired result as above. --- DB design will be required to prepare SQL query to this part of question. Typical query will look something like below. Assumption:- All universities are stored in single table which has attributes about the courses it offers and not offering.
select * from Universities where Computer_Science = 'T' and Information_Technology = 'T' and Medical_Science = 'F'.
Activities performed by a search engine :-
1) Web Crawling to collect the data on World wide web
2) Indexing to store the data efficiently
3) Algorithm to retrieve data quickly.