B.C.A. DEGREE EXAMINATION, APRIL 2018
Third Semester
Computer Application
DATABASE MANAGEMENT SYSTEMS
(CBCS 2011 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. What is a database?
2. What are the E R design issues?
3. What is a temporal data?
4. What are the conditions for Second Normal form?
5. What do you mean by Heterogeneous database?
6. Define Query.
7. Define Data Integrity.
8. What is a Sequence?
9. What are the parts of PL/SQL?
10. Define Transaction.
Sub. Code
1BCA3C1
AFC-10670
2
WSS
Part B x 5 25)
Answer all questions choosing either or
11. Explain the strong and weak entity sets with
example.
Or
Explain the E R model with diagram.
12. Explain BCNF with example.
Or
Explain the database design process.
13. Explain the parallel systems.
Or
Explain the Client-Server architecture.
14. How will you create a Table? Explain with an
example.
Or
How will you create a View? Explain with an
example.
15. Write a function to reverse the given string.
Or
What is a Trigger? Explain with an example.
AFC-10670
3
WSS
Part C x 10 30)
Answer any three questions.
16. Explain
Purpose Database systems
Transaction Management.
17. Explain Decomposition with multivalued dependencies
with example.
18. Explain
Distributed data storage
Intraquery Parallelism.
19. Explain Roles with example.
20. Write a procedure to print the EB bill. (Assume your
own data).
————————