3rd SEM : Model Question Paper- Programming in C

Model Question Paper- Programming in CMODEL QUESTION PAPER (CIE)    

 

 

Test/Date and Time

Semester/year

Course/Course Code

Max Marks

Ex: I test/6 thweek

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

Definethefollowing.                                                                               (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 typesof 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:Nrelationshiptypes.            (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; somerelate      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 remindingneeds

reminding

Doesthe         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             preciselyto

relevant          therelevant

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.

 

 

Text Box: MODEL QUESTION PAPER	Code: 15CS33T

Diploma in Computer science & Engineering

III- Semester

Course Title: Data Base Management Systems

Time: 3 Hours  Max Marks:100

 

 

            Answer any SIX   questions. Each carries5marks.       5X6=30 Marks

1.      What is database? List the important characteristics of databaseapproach.

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 DROPcommand.

5.      Differentiate Having and Where clause withexample.

6.      Explain the Boyce-Codd normal form withexample.

7.      Explain the generation of spurious tuples and how to overcome thesame.

8.      Discuss the advantages of NoSql versusRDBMS.

9.      What is scaling. Explain the types ofscaling.

 

PART-B

Answer any SEVEN full  questions each carries10marks.       10X7=70 Marks

1.  Discuss the advantages of DBMSApproach.

2.  Define thefollowing.

3.  Data Model b) Database Schema/Intension c) DatabaseState/Extension

4.  d) Data Sublanguage. e) DML.

5.  With a neat diagram explain the different phases of database design.

6.  Identify the entities, relationships and develop an E-R diagram for a company database.

7.  Explain with example the different Constraints that are violated during UPDATE and DELETEoperations

1.  Consider the following schema & write the SQLqueries. SAILORS (sid, sname, rating,age)

BOATS (bid, bname, color) RESERVES (sid, bid, day)

a.  Retrieve names of sailors who reserved greenboat.

b.  Retrieve the colors of boats reserved by'ramesh'.

c.  Retrieve the names of sailors who have reserved a red or a greenboat.

d.  Retrieve the sid of sailors with age over 20 who have not reserved a redboat.

e.  Retrieve the names of sailors who have reserved all boats called'Interlake'.

2.  List and explain the different data types used inSQL.

3.  Discuss the informal design guidelines for relationalschema.

4.    Draw a state diagram and discuss the typical states during transactionexecution.

5.      Explain the need for concurrencycontrol.


                                                   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 anddatabase

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 andsuperKey        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

duringUPDATEand      DELETEoperations

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 greenboat.

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