AKNU III SEMESTER MODEL PAPERS

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

 

ADIKAVI NANNAYA UNIVERSITY:: RAJAHMAHENDRAVARAM

Updated: April 8, 2022 — 10:33 pm
SnehaJobs.com © 2022 All Rights Reserved
You cannot copy content of this page