SRM University 2007 B.Tech Information Technology IT202-Data Base Management Systems - Question Paper

IT202-Data Base Management Systems

UNIT-I

Part-A

1. Define data and info.
2. What is a database?
3. Define a DBMS.
4. Name a few applications of database systems.
5. List the major disadvantages of keeping organizational info in a file-processing system.
6. Define data inconsistency and data redundancy.
7. Transactions of a database are atomic.Justify.
8. What is meant by data abstraction?
9. What are the 3 levels of data abstraction?
10. Define an instance and schema.
11. What is meant by data independence?
12. Define a data model.
13. What are the kinds of data models?Explain.
14. Define an entity set and a relationship set.
15. What is meant by mapping cardinalities?
16. Name any six data models.
17. What are database languages?
18. Define data dictionary.
19. Define metadata.
20. What is DML? elaborate the kinds of DML?
21. Define query and query language.
22. Broadly classify the functional components of a database system.
23. What is a storage manager?
24. Name a few data structures implemented by the storage manager.

Part-B

1. What are the disadvantages of traditional file processing system?
(or)
elaborate the advantages of DBMS over File processing system?
2. Explain data models in detail.
3. Briefly explain DBMS Languages.
4. Explain with a neat diagram DBMS System Structure.
5. Explain DBMS Architecture and the levels in data abstraction in detail.







UNIT-II

Part-A

1. Define Data model.
2. Define Entity-relationship data model.
3. What is the use of E-R model?
4. Define Entity with an example.
5. What is an Entity set? provide an example.
6. Define attributes. List the kinds of attributes.
7. Define domain or value set.
8. Compare simple & composite attributes
9. Compare single-valued & multivalued attributes.
10. Define derived attributes. (or) Briefly discuss derived attributes with an example.
11. What is a null value?
12. Define relationship &relationship set?
13. What is meant by participation?
14. What is meant by relationship instance?
15. Explain briefly about entity’s role?
16. Define recursive relationship set?
17. Define Descriptive attributes?
18. What is meant by degree of relationship set?
19. Define mapping cardinalities?
20. Give the use of Mapping Cardinalities?
21. What is Binary relationship set?
22. Give the possible mapping Cardinalities for a binary relationship set?
23. Define Constraints. provide the kinds of constraints.
24. Briefly discuss Participation constraint.
25. Define Total & Partial participation.
26. What is a key?
27. Briefly discuss superkey with an example.
28. Define Candidate key.
29. Define Primary Key.
30. What is meant by E-R diagram.
31. Define the term weak entity set.
32. Compare Weak Entity set with Strong Entity set.

Earning:   Approval pending.