FOUR YEAR B.A./B.Com./B.Sc./B.C.A./B.B.A./B.Voc. (Honours) (CBCS)
Database Management System
Fourth Semester – Computer Science · March/April 2026Section A
Answer any FIVE · 5 × 5 = 25 Marks
1
Define database and Database Management System.
2
Explain file-based system and its disadvantages.
3
Write about building blocks of Entity-Relationship diagram.
4
Write about different types of entities.
5
Write about advantages of relational algebra.
6
What is a view? Give the syntax for view creation.
7
What is the difference between procedure and function?
8
What is PL/SQL? Write about structure of PL/SQL with example.
Section B
Answer FIVE · 5 × 10 = 50 Marks
9
(a) What is Data Model? Explain various data models.
— OR —
9
UNIT – II
(b) What is a Database? Explain three schema architecture with a neat diagram.
10
UNIT – II · Relational Algebra
(a) Write about ISA relationship and attribute inheritance.
(b) Explain relationship degree.
(c) Relationship classification.
11
UNIT – III
Explain different relational algebra operations.
12
UNIT – IV
What is Normalization? Differentiate between 3NF and 2NF.
13
Explain the aggregate functions in SQL with an example.
14
List Data types allowed in PL/SQL.
15
UNIT – V
What is JOIN operation? Explain different types of joins with syntax and example.
16
What is a database trigger? Explain any four types of triggers.
మా వాట్సాప్ ఛానెల్లో జాయిన్ అవ్వండి
AP ప్రభుత్వ పథకాలు & జాబ్ అప్డేట్స్ కోసం జాయిన్ అవ్వండి!
Join WhatsApp Channel
