sri yn college mca 2nd sem database management systems 2024 question paper

sri yn college MCA 2nd sem database management systems 2024 question paper

Uploaded at Fri 06/06/2025

sri yn college autonomous narasapur west godavari district 2nd sem database management systems 2024 question paper affiliated by adikavi nannaya university

Paper Code:MCA-20203

SRI Y.N.COLLEGE (AUTONOMOUS)-NARSAPUR, W.G.Dt.

Dr.C.S.RAO PG CENTRE(A)

(Affiliated to Adikavi Nannaya University)

1 M.C.A PG Examinations, JULY/AUG 2024

(At the end of 2nd Semester)

For Regular (2023-25) Batch

(DATABASE MANAGEMENT SYSTEMS)

Paper-III

Date:01.08.2024 FN

Duration: 3hrs

Max Marks:75

SECTION-A (4X5-60M)

Answer ALL Questions

1. a) Write a brief note on advantages of DBMS. (7 M)

b) Breifly explain about Three-Schema Architecture with neat diagram. (8 M)

(OR)

c) Draw the ER diagram for company database and explain. (15 M)

2. a) Explain in detail about Tuple and Domain Relational Calculus with examples. (15 M)

(OR)

b) Write and explain Schema change statements in SQL. (15M)

3. a) Explain Informal design guidelines for Relational Schemas (15 M)

(OR)

b) What is normalization? Discuss INF, 2NF, 3NF with examples. (15 M)

4. a) Explain the translation from SQL Queries into Relatinal Algebra. (15 M)

(OR)

b) Briefly explain Concurrency Control techniques. (15 M)

SECTION-B (5X3=15M)

Answer any FIVE of the following

5. Answer any FIVE Questions of the following.

a) Data Independence.

b) EER diagram.

c) DML statements in SQL.

d) Transaction Properties.

e) What is View in SQL?.

f) Explain BCNF.

g) Lock Compatibility.

h) Indexes in SQL.

***

sri yn college MCA 2nd sem database management systems 2024 question paper

espapers.com

Select Lable

Recent Uploads

sri yn college MCA 1st sem discreate mathematical structures 2024 question paper

sri yn college MCA 1st sem design and analysis of algorithms 2024 question paper

sri yn college MCA 1st sem operating systems 2024 question paper

sri yn college MCA 1st sem c programming and data structures 2024 question paper

sri yn college MCA 1st sem computer organization 2024 question paper

Most viewed Posts

sri yn college mca 2nd sem data mining concepts and techniques 2024 question paper 470

sri yn colege mca 2nd sem formal languages and automata theory 2024 question paper 344

sri yn college mca 2nd sem object oriented programing through java 2024 quetion paper 331

sri yn college mca 2nd sem internet of things 2024 question paper 252

sri yn college mca 2nd sem database management systems 2024 question paper 209

ESpapers