SnehaJobs.com

GSWS Updates|| VSU Previous Papers||Study Materials||Latest Jobs

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
Disclaimer- We (snehajobs.com) provide Degree previous papers/ Jobs / Career related information gathered from various reliable sources. We have tried our best to provide accurate information about syllabus, previous paper, Study Materials, results, jobs, vsws updates, private job and other informative links. Any error or false information is not our responsibility. We are a Non-Government service provider and does not guarantee 100% accuracy. Please double-check the information from the official source/website before taking any action. All Rights Reserved

You cannot copy content of this page