SRM University 2007 B.Tech Computer Science and Engineering Bank DATABASE MANAGEMENT SYSTEMS - Question Paper

S.R.M. INSTITUTE OF SCIENCE AND TECHNOLOGY
DEEMED UNIVERSITY
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
ques. Bank
Subject:DATABASE MANAGEMENT SYSTEMS Branch : CSE
Sub.code :CS302 Year/Sem : III yr B.Tech (VI sem)

UNIT-I
PART-A(2 MARKS)
1. Define database
2. Define DBMS
3. Mention the disadvantages of file system over DBMS
4. Explain data redundancy and inconsistency
5. What is data isolation?
6. What is atomicity issue in file systems?
7. What are the three levels of data abstraction?
8. What are instances and schemas?
9. What are the different data models available?
10. What are entities and entity sets? provide eg.
11. What are relationship and relationship sets? provide eg.
12. Draw ER diagram for the subsequent entity set
Employee: eno, ename, salary, doj, phone_no, dob, age
where ename is composite, phone_no is multi-valued and age is derived attribute
13. What is DDL?
14. What is DML?
15. What is the role of DBA?
16. What are the functions of transaction management?
17. What are the components of storage manager?
18. Explain 2-tier architecture
19. Explain 3-tier architecture.
20. What are the components of query processor?
21. Define data model
22. Define mapping cardinality.
23. What are the participation constraints?
24. What are the various kinds of mapping cardinalities?
25. Differentiate primary key and candidate key
26. Differentiate super key and candidate key.
27. What is a foreign key? provide eg.
28. What is a weak entity set?
29. What is a strong entity set?
30. Differentiate specialization and generalization.
31. What are the constraints on generalizations?
32. Explain aggregation
33. What is E-R model?


UNIT I
PART-B(10 MARKS)

1. Comment on DBMS vs FileSystems.
2. Explain the different data models.
3. Explain the design of an E-R database schema
4. Write short notes on:
(a) Specialization
(b) Generalisation
(c) Aggregation
5. Write short notes on
(a) Weak entity set
(b) Strong entity set
6. Write short notes on
(a) Mapping cardinalities
(b) Participation constraints
7. Explain the system structure of database
8. Write short notes on
(a) Database users
(b) Transaction management

Unit II

PART-A

1. How the storage media are classified ?
2. What are the storage media available ?
3. Define tracks & sectors .
4. What is the use of read-write head in magnetic disks ?
5. Define striping data and bit level striping.
6. Write short notes on Buffer Manager .
7. Give example for fixed length record.
8. What is sequential file organization ?
9. What is hashing file organization ?
10. describe data dictionary .
11. describe clustering and non clustering indices.
12. What is dense index ?
13. What is sparse index ?

Earning:   Approval pending.