AKNU III Semester Model Papers for B.SC / BA Computer Applications
ADIKAVI NANNAYA UNIVERSITY:: RAJAHMAHENDRAVARAM
B.Sc /B.A – Computer Applications Syllabus (w.e.f:2020-21 A.Y)
MODEL QUESTION COURSE
B.Sc /B.A DEGREE EXAMINATION
SEMESTER: III
COMPUTER APPLICATIONS
Course 3: DATABASE MANAGEMENT SYSTEMS
Section – A
Answer any 5 question 5X5 = 25M
1. Define Database management systems.
2. What is a Data Model?
3. What is Specialization?
4. What is a Weak Entity?
5. What is referential integrity Constraint?
6. Define Functional Dependency?
7. List out Aggregate Functions
8. Explain SQL Data Types.
Section -B
Answer following question 5X10 = 50M
9. a) What are the characteristics of the Database? Explain the responsibilities of the Actors of the database.
(OR)
b) Explain about the Three-Schema Architecture with the help of a neat diagram.
10. a) Discuss the convention for constructing an ER-diagram along with an example.
(OR)
b) Discuss the Enhanced Entity-Relationship with a suitable example.
11. a) Explain the concepts of relational model with example.
(OR)
b) What is Normalization? Explain 1NF, 2NF, 3NF, BCNF and multivalve dependency.
12. a) Discuss various types of Join operations with examples.
(OR)
b) List the operations of relational algebra and the purpose of each.
13. a) Explain Data Definition Commands with example database and queries for each command.
(OR)
b) Explain Data Manipulation Commands with suitable queries