Database Management Systems COMPUTER SCIENCE 3RD SEMESTER MODEL QUESTION PAPER
|
Test/Date
and Time |
Semester/year |
Course/Course
Code |
Max Marks |
|
Ex: I test/6 th week |
III SEM |
Data Base Management Systems |
20 |
|
of sem 10-11 AM |
Year: 2015-16 |
Course code:15CS33T |
|
||||
|
Name of Course coordinator : Units:1,2 Co: 1,2 Note: Answer all questions |
|||||||
|
Questio n no |
Question |
CL |
C O |
PO |
|||
|
1 |
Define the following. (5) 1. Data Model 2. Database Schema/Intension 3. Database State/Extension 4. Data
Sublanguage 5. DML. |
R |
1 |
1,2 |
|||
|
2 |
Define data independence and explain different
types of it. (5) |
R |
1 |
1,2 |
|||
|
3 |
Explain the different cardinality ratios for binary relationship
types. (5) |
U |
2 |
1,2 |
|||
|
4 |
Explain
with suitable examples 1:1 and M:N relationship types. (5) OR Develop an E-R diagram for a company database. |
A |
2 |
1,2 |
|||
|
Collection of data |
Does not collect any information relating to the topic |
Collects Collects very limited some basic information; information; some relate refer
to the to the topic topic |
Collects Collects a relevant great
deal of information; information; concerned all refer to to the topic the topic |
3 |
|
Fulfill team’s roles &
duties |
Does not
perform any duties assigned to the
team role |
Performs Performs very little nearly all duties duties |
Performs all Performs all duties duties
of assigned team roles with presentation |
4 |
|
Shares work equally |
Always relies
on others to do the work |
Rarely does Usually the assigned does the work; often assigned needs work;
rarely reminding needs reminding |
Does the Always assigned job does the without assigned
having to be work reminded. without having to be reminded
and on given time frame |
3 |
|
Listen to other Team mates |
Is always
talking; never allows anyone else to speak |
Usually Listens, but does most sometimes of the talk too talking; much rarely allows others
to speak |
Listens and Listens and
contributes contributes to the precisely to relevant the relevant topic topic
and exhibit leadership qualities |
3 |
|
|
|
|
TOTAL |
13/4=3.25=4 |
|
I |
What is database? List the
important characteristics of database approach. |
R |
05 |
|
What do you mean by data model?
List and explain the different types of data model. |
R |
||
|
What is Data Independence?
Differentiate between logical & physical Data Independence. |
U |
||
|
Define the following. 1. Data Model 2. Database Schema/Intension 3. Database State/Extension 4. Data
Sublanguage 5. DML. |
R |
||
|
Explain the functions of
database administrators and database designers. |
U |
||
|
Briefly explain the different
types of End Users. |
U |
||
|
Define data independence and
explain different types of it. |
U |
||
|
List the various DBMS languages
and explain each. |
R |
||
|
List the various DBMS interfaces
and explain each. |
R |
||
|
Explain the functions of
different Database utilities. |
U |
||
|
Explain the important
characteristics of database approach. |
U |
10 |
|
|
Explain the actors on the scene
and workers behind the scene. |
U |
||
|
Discuss the advantages of DBMS
Approach. |
U |
||
|
Explain the two-tier
client/server architecture for DBMS with neat diagram. |
U |
||
|
Explain the DBMS components
modules with neat diagram. |
U |
||
|
Write a note on classification
of DBMS. |
U |
||
|
II |
What is E-R diagram? List out
the notations used for E-R diagram. |
R |
5 |
|
Explain the different
cardinality ratios for binary relationship types. |
U |
||
|
Differentiate between a) an
attribute and value set b) stored and derived attributes. |
U |
||
|
Explain the structural
constraints of relationship type. |
U |
||
|
Explain with suitable examples
1:1 and M:N relationship types. |
A |
||
|
With a neat diagram explain the
different phases of database design. |
U |
10 |
|
|
What is a Weak entity type,
explain with an example how the entities are
identified in a Weak entity. |
U |
||
|
Define the following term with
examples:- a) Entity b) Entity set c) Multi-valued attribute d) Composite attribute e)Derived
attribute |
R |
||
|
Identify the entities,
relationships and develop an E-R diagram for a company database. |
A |
||
|
Identify the entities,
relationships and develop an E-R diagram for a Hospital database. |
A |
||
|
III |
Compare entity integrity and
referential integrity constraints. |
U |
5 |
|
Classify the constraints on
databases and give examples for each of them. |
U |
||
|
Explain the characteristics of
Relations. |
U |
||
|
Explain with examples Entity
Integrity Constraints and referential Integrity Constraint |
A |
||
|
Differentiate
i) Key and super Key ii)
degree and cardinality |
U |
||
|
Define the following term with
examples:- |
R |
|
|
|
a) Domain b) Attribute c) Tuple d) Relation schema (R) e) Relation (r) |
|
10 |
|
Explain the insert, delete and
update operation with examples. |
A |
||
|
Explain with example the
different constraints that are violated during UPDATE
and DELETE operations |
U |
||
|
IV |
Write a note on different data
types supported by SQL. |
R |
5 |
|
Write the general syntax of
specifying Check constraint and default constraint while creating a
table. |
R |
||
|
Differentiate Having and Where
clause with example. |
A |
||
|
Write a note on aggregate
functions in SQL. |
U |
||
|
Discuss the strategies for View
Implementation. |
U |
||
|
With examples write a note on
CREATE and DROP command. |
A |
||
|
Define view. How to create it?
Give example. |
U,A |
||
|
Explain UPDATE and ALTER command
with example. |
U,A |
||
|
Write a note on basic queries in
SQL. |
U |
||
|
Explain the different schema
change statements in SQL with example. |
A |
||
|
List and explain the different
data types used in SQL. |
U |
10 |
|
|
Explain different constraints
available in SQL with example. |
U |
||
|
List and explain the different
aggregate functions available in SQL with example. |
A |
||
|
Explain the following with
examples: a) Insert b) Delete c) Distinct
d) Order by e) Where |
A |
||
|
Explain the following Operators
with examples: a) ANY b) ALL c) IN d) LIKE e)
BETWEEN |
A |
||
|
Consider the following schema
& write the SQL queries. SAILORS (sid, sname, rating, age) BOATS (bid, bname, color)
RESERVES (sid, bid, day) a) Retrieve names of sailors who reserved green boat. b) Retrieve the colors of boats reserved by ‘ramesh’. c) Retrieve the names of sailors who have reserved a red or a green
boat. d) Retrieve the sid of sailors with age over 20 who have not
reserved a red boat. e) Retrieve the names of sailors who have reserved all boats called
‘Interlake’. And Similar databases to be considered with different set
of queries. |
A |
||
|
V |
Explain the generation of
spurious tuples and how to overcome the same. |
U |
5 |
|
Differentiate between i) prime attribute and non prime attribute ii) Full functional dependencies and partial
dependencies with
examples. |
U |
||
|
Explain the functional
dependencies with examples. |
U |
||
|
Explain second normal form with
an example. |
U |
||
|
Explain third normal form with
an example. |
U |
|
|
Explain the Boyce-Codd normal
form with example. |
U |
|
|
Explain the different UPDATE
anomalies of tables. |
U |
10 |
|
|
Discuss the informal design
guidelines for relational schema. |
U |
||
|
What is normalization? Explain
the different types of normal forms with examples. |
U |
||
|
VI |
Explain the following terms:
transaction, concurrency control. |
U |
5 |
|
Explain the desirable properties
of a transaction. |
U |
||
|
Write a note on System Log. |
U |
||
|
Write a note on commit point of
a transaction. |
U |
||
|
Discuss the advantages of NoSql
versus RDBMS. |
U |
||
|
Explain CAP theorem. |
U |
||
|
Explain the advantages of
distributed computing. |
U |
||
|
What is scaling. Explain the
types of scaling. |
U |
||
|
Differentiate between ACID and
BASE. |
U |
||
|
Bring out the advantages and
disadvantages of Nosql. |
U |
||
|
Draw a state diagram and discuss
the typical states during transaction execution. |
A |
10 |
|
|
Discuss the different types of
failures that occur during transaction execution. |
A |
||
|
Explain the need for concurrency
control. |
A |
||
|
Explain the categories of NoSql. |
U |
||
|
Explain Column store and Row
store with suitable examples. |
A |
Comments