Database Management Systems COMPUTER SCIENCE 3RD SEMESTER MODEL QUESTION PAPER

Database Management Systems  COMPUTER SCIENCE 3RD SEMESTER MODEL QUESTION 

PAPER MODEL QUESTION PAPER (CIE)

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



 Format for Student Activity Assessment

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


*All student activities should be done in a group of 4-5 students with a team leader.















Diploma in Computer science & Engineering
III- Semester
Course Title: Data Base Management Systems
Time: 3 Hours Max Marks: 100
 
PART-A
Answer any SIX   questions. Each carries 5 marks. 5X6=30 Marks
1. What is database? List the important characteristics of database approach.
2. Explain with examples Entity Integrity Constraints and referential Integrity Constraint.
3. Explain the characteristics of Relations.
4. With examples write a note on CREATE and DROP command.
5. Differentiate Having and Where clause with example.
6. Explain the Boyce-Codd normal form with example.
7. Explain the generation of spurious tuples and how to overcome the same.
8. Discuss the advantages of NoSql versus RDBMS.
9. What is scaling. Explain the types of scaling.

PART-B
Answer any SEVEN full  questions each carries 10 marks. 10X7=70 Marks
1. Discuss the advantages of DBMS Approach.
2. Define the following.
a) Data Model b) Database Schema/Intension c) Database State/Extension
d) Data Sublanguage. e) DML.
3. With a neat diagram explain the different phases of database design.
4. Identify the entities, relationships and develop an E-R diagram for a company database.
5. Explain with example the different Constraints that are violated during UPDATE and DELETE operations
6. 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’.
7. List and explain the different data types used in SQL.
8. Discuss the informal design guidelines for relational schema.
9. Draw a state diagram and discuss the typical states during transaction execution.
10. Explain the need for concurrency control.

MODEL QUESTION BANK
Diploma in Computer Science & Engineering III Semester
Course Title: Data Base Management Systems

CO Question CL Marks

 

 

 

 

 

 

 

 

 

 

 

 

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


Popular Posts