VTU Previous Year Question Papers BE CS Fifth Semester Database Management Systems June 2010

VTU CSE 5th Semester Database Management Systems Question Paper June 2010

VTU CSE 5th Semester Database Management Systems June 2010: To secure better marks in the exam, you should practice as many question papers as possible. It will give you information about the important chapters and concepts to be covered in all chapters.

Here we are providing you the complete guide on VTU CSE 5th Semester Database Management Systems June 2010.

VTU CSE 5th Semester Database Management Systems June 2010

You must have Object Database Management Systems Question Paper along with the latest Computer Science 5th sem Syllabus to enhance your semester exam preparation.

Here you can check the VTU CSE 5th Semester Database Management Systems June 2010

PART-A

1 a. Briefly discuss the advantages of using the DBMS.)

b. Explain the component modules of DBMS and their interaction, with the help of a diagram.

2 a. Define an entity and an attribute; Explain the different types of attributes that occur in an ER model, with an sample.

b. Define the following with an example:

i) Weak entity type

ii) Participation constraints

iii) Cardinality ratio

iv) Ternary relationship

v) Recursive relationship.

3 a. Discuss the characteristics of a relation, with examples.

b. Briefly discuss the different types of update operations on relational database. Show an example of a violation of the referential integrity in each of the update operation.

c.   What is a valid state and an invalid state, with respect to a database?

4 a. Consider the following two tables Ti and T2. Show the results of the following operations:

b. Explain with mi example, the basic constraints that can be specified, when you create a table in SQL.

PART-B

5 a. Explain the syntax of a SELECT statement in SQL. Write the SQL query for the following relation algebra expression.  Bdate, Address (oFname =” John’ AND Minit = B’ AND Lname =’ Smith’ (EMPLOYEE))

b.  Explain DROP command with an example.

c.   Consider the following tables:

WORKS (Pname, Cname, Salary)

LIVES (Pname, Street, City)

LOCATED-IN (Cname, City)

MANAGER (Pname, mgmame)

Write the SQL query for the following:

i)    Find the names of all persons who live in the city ‘Mumbai5.

ii)   Retrieve the names of all person of ‘Infosis’ whose salary is between Rs.30,000 and Rs.50,000.

iii)  Find the names of all persons who live and work in the same city.

iv) List the names of the people who work for ‘ Wipro’ along with the cities they live in.

v)     Find the average salary of all Infosians.

6 a. What is a functional dependency? Write an algorithm to find a minimal cover for a set of functional dependencies.

b.  What is the need for normalization? Explain second normal form. Consider the relation EMP-PROJ = {SSn,, Pnumber, Hours, Ename, Pname, Plocation}. Assume {SSn, Pnumber} as primary key. The dependencies are

SSn Pnumber —» {Hours}

SSn {Ename}

Pnumber -» {Pname, Plocation}.

Normalize the above relation into 2NF.

7 a. Explain multivalued dependency and fourth normal form, with an example.

b.  Let R – {SSn, Ename, Pnumber, Pname, Plocation, Hours} and D = }Ri, R2, R3}, where Ri – EMP = {SSn, Ename)

R2 = PROJ = {Pnumber, Pname, Plocation}

R3 – WORK-ON – {SSn, Pnumber, Hours}.

The following functional dependencies hold on relation R.

F = {SSn Ename ; Pnumber -» {Pname, Plocation};

{SSn, Pnumber} —» Hours}.

Prove that the above decomposition of relation R has the lossless join property.

8 a. Explain the problems that can occur when concurrent transactions are executed. Give examples.

b.  Briefly discuss the two phase locking protocol used in concurrency control.

We have covered VTU CSE 5th Semester Database Management Systems June 2010. Feel free to ask us any questions in the comment section below.

Leave a Comment