B.C.A. DEGREE EXAMINATION, NOVEMBER 2017
Third Semester
Computer Applications
DATABASE MANAGEMENT SYSTEMS
(CBCS 2014 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 X 2 20)
Answer all the questions.
1. Define instance and schema of the database.
2. What is an entity set? Distinguish between weak and
strong entity sets.
3. Define first normal form.
4. What is meant by multivalued dependency?
5. List out the purpose of query server system.
6. Distinguish between horizontal and vertical
fragmentation.
7. What is a sequence? Give example.
8. List out any two advantages of synonyms.
9. What is a stored procedure? How it differs from function?
10. What do you mean by a transaction?
Sub. Code
4BCA3C1
AFF-4587
2
WS6
Part B X 5 25)
Answer all questions by choosing either or
11. What is DBMS? Explain the various data models.
Or
Describe the components of E-R diagram with
suitable examples.
12. What is an atomic domain? Explain the second
normal form with example.
Or
Write short notes on database design process.
13. Discuss about centralized and client-server
architecture.
Or
Explain the concept of distributed query processing.
14. What is data integrity? Explain the various types of
integrity.
Or
What is synonym? Explain the synonyms creation
and remove with example.
15. What is a trigger? List out the components and
types of triggers.
Or
What do you mean by rolling back? Explain the
rollback during transactions.
AFF-4587
3
WS6
Part C X 10 30)
Answer any three questions.
16. Explain in detail about various database system
applications and database languages.
17. Discuss about the features of good relational designs.
18. Explain about the parallel and distributed systems.
19. How can you create and maintain a table? Explain with
an example.
20. What is PL/SQL? Explain any two control structures of
PL/SQL with examples.
————————