KEMBAR78
DBMS 22mca21 | PDF | Databases | Sql
Scribd
Upload
59 views3 pages

DBMS 22mca21

This document outlines the examination structure for the Second Semester MCA Degree Examination in Database Management Systems, scheduled for June/July 2023. It includes details on the modules, topics covered, and types of questions to be answered, with a focus on various database concepts, SQL queries, normalization, and transaction properties. Students are required to answer five full questions, selecting one from each module.

Uploaded by

lomic31750
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
59 views3 pages

DBMS 22mca21

This document outlines the examination structure for the Second Semester MCA Degree Examination in Database Management Systems, scheduled for June/July 2023. It includes details on the modules, topics covered, and types of questions to be answered, with a focus on various database concepts, SQL queries, normalization, and transaction properties. Students are required to answer five full questions, selecting one from each module.

Uploaded by

lomic31750
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

BOl22-sc, McA

CBCS SCHEME
USN 22MCA21

Second Semester MCA Degree Examination, June/July 2023


Database Management System
Time: 3 hrs. Max. Marks: 100

asmalpractice.
reated
Note: Answer any FlVEfull questions, choosing ONE full question from each module.
Module-1
1 a. Explain the Database System Environment with neat diagram. (10 Marks)
b. Discuss the characteristics and advantages of Database Approaches. (10 Marks)

OR
2 a. Explain with proper diagran, the 3 - schema architécture of DBMS. (10 Marks)
b. What are the different types of atributes? Explain with example. (10 Marks)

Module-2
3 a. Explain Unary Operation SELECT (G) and prove it is commutative. (10 Marks)
b. Explain Schema Update Operations, with a suitable examples. (10 Marks)

OR
a. Withasuitable example, explain Join and division operation in relational algebra. (10 Marks)
b. Explain in detail ER- to- Relational Mapping algorithm. (10 Marks)

Module-3
5 a. Explain with suitable example the basic structure of SQL query. (10 Marks)
b. What are Views in SQL? Explain. (10 Marks)
dcompulsorily
OR
6
a. In SQL how to handle the Aggregate functions with group by and having clauses? With
examples. (06 Marks)
identification. b. What are Aggregate functions? Explain with an exa1ples. (06 Marks)
answe c. Explain the architecture of JDBC main components and types of drivers. (08 Marks)

your Module-4
of 7 a. Discuss informal design guidelines for relationalschema. (10 Marks)
revealing
completing
b What is Normalization? What are its advantages? Discuss INF, 2NF and 3NE. (10 Marks)
OR
OnAny 8 a. Explain with an example the Boyce -Codd Normal Form (BCNF). (10 Marks)
1. 2. b. Discuss the different inference rules for functional dependencies. (10 Marks)
Note:
Module-5
Important 9 a. Explain ACID properties of transaction in details. (10 Marks)
b. Discuss the characterizing schedules based on recoverability. (10 Marks)
OR
10 a. Discuss a Lock based concurrency control issue in DBMS transaction processing.
(10 Marks)
b. Deseribe Granularity of data items and Multiple Granularity locking. (10 Marks)
20

You might also like