Scribd
Upload
278 views3 pages

Database Management System Exam Guide

This document contains instructions for a Database Management System exam with 5 questions covering key DBMS concepts. The exam covers: 1) The definition and structure of a DBMS and different data models. 2) Entity-relationship diagrams, specialization, generalization, and aggregation. Key types including primary keys, candidate keys, alternate keys, and foreign keys. 3) Join types and relational algebra operations. The difference between simple and complex queries. 4) Normalization objectives and relational database design pitfalls. Functional dependency and dependency preservation. 5) Uses of group functions, having, order by, and views in tables. Nested subqueries. Database integrity,

Uploaded by

HEMANT MOHBEKAR
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
278 views3 pages

Database Management System Exam Guide

This document contains instructions for a Database Management System exam with 5 questions covering key DBMS concepts. The exam covers: 1) The definition and structure of a DBMS and different data models. 2) Entity-relationship diagrams, specialization, generalization, and aggregation. Key types including primary keys, candidate keys, alternate keys, and foreign keys. 3) Join types and relational algebra operations. The difference between simple and complex queries. 4) Normalization objectives and relational database design pitfalls. Functional dependency and dependency preservation. 5) Uses of group functions, having, order by, and views in tables. Nested subqueries. Database integrity,

Uploaded by

HEMANT MOHBEKAR
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

Roll No. ...................................

ED–2863
B. C. A. (Part II) EXAMINATION, 2021
Paper Second
DATABASE MANAGEMENT SYSTEM
Time : Three Hours
Maximum Marks : 80
Minimum Pass Marks : 27
Note : Attempt any two parts (each 5 marks) from each
question. All questions carry equal marks.
Unit—I

1. (a) Define the DBMS. Explain the overall strucute of


DBMS.
(b) What is Data Model ? Explain the differnet types of
data models.
(c) Explain the advantages of DBMS over file
processing system.
Unit—II

2. (a) What is E-R diagram ? Explain Entity Set,


relationship set and attributes.

P. T. O.
[2] ED–2863

(b) Explain the process of specialization, generalization


and aggregation.

(c) Explain the concept of key and describe the


following keys :

(i) Primary Key

(ii) Candidate Key

(iii) Alternate Key

(iv) Foreign Key

Unit—III

3. (a) What is Join ? Explain the different types of join.

(b) What is relational algebra ? Explain there different


operation with example.

(c) Differentiate between simple and complex queries.


Explain with example.

Unit—IV

4. (a) What is normalization ? Explain the objectives of


the normalization.

(b) What are the pitfalls in relational database design ?


Explain with suitable example.

(c) Write short notes on the following :

(i) Functional dependency

(ii) Dependency preservation.


[3]

Unit—V

5. (a) What is the use of the following in table :

(i) Group function

(ii) Having

(iii) Order by

(iv) View

(b) What is the query ? Explain the nested sub queries.

(c) Explain integrity, security and recovery with


example.

ED–2863

You might also like