Scribd
Upload
39 views

ATCD

.. ..

Uploaded by

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

ATCD

.. ..

Uploaded by

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

R22 REG II B.

TECH II SEM
DATABASE MANAGEMENT SYSTEM
ACADEMIC YEAR: (2023-2024)

Unit-1

1) What is DBMS? What are the advantages of DBMS


2) What are the disadvantages of file systems?
3) What are the applications of DBMS?
4) Give a brief note on the History of Database Systems.
5) Discuss the levels of data abstraction.
6) Explain different types of data models
7) Explain structure of a DBMS?
8) What guidelines would you use for each of these choices when doing ER design: Whether to
use an attribute or an entity set, an entity or a relationship set, a binary or ternary
relationship,.
9) Discuss the additional features of ER model
10) Explain generalization, specialization and aggregation in E-R Model.
11) Explain the functions of Database Administrator
12) A company database needs to store information about employees (identified by ssn, with
salary and phone as attributes), departments (identified by dno, with dname and budget as
attributes), and children of employees (with name and age as attributes). Employees work in
departments; each department is managed by an employee; a child must be identified
uniquely by name when the parent (who is an employee; assume that only one parent works
for the company) is known. We are not interested in information about a child once the
parent leaves the company. Draw an ER diagram that captures this information. hat is a
relation? Differentiate between a relation schema and a relation instance.
13) Draw an E-R Diagram for any Banking system.
14) Explain how to build an ER model for university with entities department, instructor,
student, and class. Instructors and students belong to one department only. Instructors and
students related to a class with many to many relations. Assume suitable attributes. Explain
how the ER model can be translated into relations.
15) Develop an E-R Diagram for Banking enterprise system.
16) Construct an ER-Diagram for a hospital with a set of patients and set of medical doctors.
Associated with each patient a log of the various tests and examinations conducted.
Unit- 2

1) What is a relation? Differentiate between a relation schema and a relation


instance.
2) Explain integrity constraints over relations.
3) Explain enforcing integrity constraints.
4) Explain TRC and DRC.
5) What is the difference between a candidate key and the primary key for a given
relation? What is a super key?
6) Describe the set operations of relational algebra, including union(U), intersection(n),
set-difference(-), and cross-product(x). For each, what can you say about the
cardinality of their input and output tables?
7) Describe the projection operator. What can you say about the cardinality of the
input and output tables for this operator?
8) Create a view? how to destroying and altering views?

Unit- 3

1) Write the answer of the following SQL queries


a) Prepare all queries
b) Find all sailors with a rating above 7
c) Find the names of sailors who have reserved boat number 103.
d) Find the sids of sailors who have reserved a red boat
e) Find the colors of boats reserved by Lubber

2) Explain DDL, DML commands?

3) What is redundancy? explain problems caused by redundancy?

4) Explain Union, intersect, except?

5) What is normalization? Why do we need normalization? Define 1NF and 2NF.

What is the motivation for putting a relation in BCNF? What is the motivation

for 3NF?

6) Define multi-valued dependencies, explain 4NF and 5NF.

7) Explain joins with example?

8) Explain triggers with example?


9) When is decomposition said to be dependency preserving? Why this property
Useful? Explain.

10)

Unit-IV

1) What is transaction? Explain the properties of transaction


Or

Explain ACID properties

2) Explain concurrency problems in DBMS(Dirty read,Unrepeatble read,lost

update, phantom read problems)

3) What is serializability? Explain its conflict and view searializability?

4) Explain Recoverability?

5) Explain concurrency control protocols

6) Explain Multiple Granularity concurrency control protocols

7) Explain locking protocols

8) Compare and contrast two phase protocol and strict two phase locking protocols

9) Explain the TimeStamp – Based Concurrency Control protocol.

10) Explain validation based protocol ?

11) Explain about log based recovery method

12) Implementation of isolation

Unit-V

1) Explain Data on external storage

2) Explain about the file organization and indexing.


3) Explain primary and secondary index, cluster index

4) Discuss the relationship between Extendible and Linear Hashing.

5) Explain deletion and insertion operation in B+ trees.

6)Explain ISAM

You might also like