Vinayaka Missions University 2008 B.E Information Technology data base management system bank - Question Paper

VINAYAKA MISSIONS UNIVERSITY,
V.M.K.V.ENGINEERING COLLEGE, SALEM – 308.
DEPARTMENT OF info TECHNOLOGY
ques. BANK
DATABASE MANAGEMENT SYSTEMS
THIRD YEAR/V SEMESTER
UNIT – I

PART – A

1. What is Database Management System?
2. List out the disadvantages of file processing system?
3. Define Data Abstraction?
4. What is meant by Instances and Schemas?
5. Define Data Independence?
6. What is meant by Data Model?
7. Define E-R Model?
8. State the symbols used for E-R Diagram?
9. Draw an E-R diagram of Banking System?
10. What is Entity Set with example?
11. describe relational model?
12. What is object-Oriented data model?
13. What is meant by Data-Definition Language?
14. Define Data Manipulation Language?
15. Who are Sophisticate users?
16. Define Database Administrator?
17. Write the functions of Database Administrator?
18. What is Transaction Manager?
19. State the components of Storage Manager?
20. Define Single-valued and Multi-valued attribute?
21. What is mapping cardinalities?
22. Define Primary key? provide example.
23. What is meant by relational algebra?
24. List out the fundamental operations in relational algebra?
25. Define Tuple relational calculus?

PART – B

1. Explain the disadvantages of file processing system?
2. Describe briefly about data abstraction and data independence?
3. Discuss briefly about database languages?
4. Describe the database users and user interface in detail?
5. Explain briefly about Transaction manager and storage manager?
6. Explain the overall system structure with neat diagram?
7. Discuss briefly about Entity-Relationship diagram with example?
8. Explain the basic structure of relational algebra?
9. Write a detailed note on database schema?
10. Explain the fundamental operations of relational algebra with example?


UNIT – II

PART-A

1. What is SQL?
2. List out the parts of SQL language?
3. Write the basic structure of an SQL expression?
4. How do you create a table in a Relational model?
5. What are the set operations used in SQL?
6. List out a few aggregate function in SQL?
7. What are nested sub queries?
8. How do you create views in SQL?
9. Write the SQL command for deletion and drop table?
10. What is the difference ranging from truncate and delete commands?
11. List out a few domain kinds in SQL?
12. Write the update command with example?
13. How do you insert multiple rows in the table?
14. Give example for string operations?
15. Define Authorization?
16. What is meant by granting of privileges?
17. Give the properties for a good encryption technique?
18. Define the statistical databases?
19. Write the pitfalls in relational database design?
20. Define decomposition? provide an example?
21. What is lossless-join decomposition?
22. Define functional dependencies?

Earning:   Approval pending.