Bangalore University 2007 M.Sc Computer Science MD-3403 DBMS - Question Paper

M.Sc. Computer Science MD-3403 DBMS MAY 2007
Time : 3 hours Maximum : 100 marks
part A — (10 * three = 30 marks)
ans ALL the ques..
1. What is DBMS? provide an introduction.
2. Define the term ‘Data Abstraction’.
3. What are weak entity sets?
4. Give a suitable name for the subsequent relation and also write the scheme for the identical :
Supplier # Suppler - name Status City
S1 Smith 20 London
S2 Jones 10 Paris
S3 Blake 30 Paris
5. What are NULL values? provide example.
6. Define Attributes and Tuples.
7. List the elements of SQL language.
8. Name the set operations on Relations.
9. Write the syntax for creating a table in SQL.
10. What is Dense Index?
part B — (4 × 10 = 40 marks)
ans any 4 ques..
11. Write down the advantages of DBMS and discuss them.
12. Consider the relation of Q.No four and discuss the Basic concepts of relation with respect to the provided relation.
13. Briefly discuss the kinds of Databases.
14. Discuss the concept of Data manipulation languages in detail.
15. Consider the subsequent Relation Schemas :
employee (employee - name, street, city)
works (employee - name, company - name, salary)
company (company - name, city).
Write your own Relation and do the subsequent :
(a) Find the names of all employee who belong to city ‘Trichy’.
(b) Find the name of those employees whose salary is quotes than 60,000.
(c) Find all the names of the companies in ‘Karaikudi’.
16. Write short notes on the subsequent :
(a) Renaming a Table
(b) Dropping a Table.
part C — (2 × 15 = 30 marks)
ans any 2 ques..
17. Describe in detail about the Role of database Administrator.
18. Explain in detail about Relation Model with examples.
19. Discuss oracle Database Architecture in detail.

Earning:   Approval pending.