Semester : SEMESTER 4
Subject : Database Management System and RDBMS
Year : 2023
Term : APRIL
Branch : BACHELOR OF COMPUTER APPLICATIONS
Scheme : 2019 Full Time
Course Code : BCA 4B 05
Page:2
15.
16.
17.
18.
19.
20.
21.
367162
2 C 41184
Discuss different join operations and its types.
Write a note on join dependencies and fifth normal form.
What are locks ? Discuss different locks in detail.
How will you create a user-defined function ? Explain with an example.
What is relational calculus ? Explain with example queries.
Section C (Essay Type Questions)
Answer any one question, correct answer carries 10 marks.
Explain different data models in detail.
What is a Trigger ? Write its relevance. How will you create a trigger ?
367162