VTU Previous question papers – Fifth Sem BE- Degree Examination,DBMS Dec 2010

VTU Previous question paper

Fifth  Semester B.E. Degree Examination, December 2010

Database Management Systems

 

 

Q1 a. Discuss the main characteristics of the database approach. How does it differ from the traditional file systems?

b.What is the difference between logical data independence and physical data independence?

c.Discuss the conventions for display an ER schemes as an ER diagram.

Q 2 a. Discuss the entity integrity and referential integrity constraints. Why is each considered important?

b. Explain how the different update operations deal with constraint violations.

Q3 a. List the operations of relational algebra and the purpose of each.

b. Consider the following relations for a database of the company:

Employee (name, ENo, sex, salary, super No, DNo.)

Department (Dname, Dnumber, Mgr No)

Dept locations (Dnumber, Dlocations)

Project (Pname, Pnumber. Plocations, Dnumber)

Works ON (EENa, PNa, Hours)

Dependent (EENa, Dependent name, sex)

Specify the following queries in relational algebra :

i) Retrieve the name and address of all the employees who work for the design department

ii) Find the names of employees who work on all the projects controlled by department  No.3

iii) Retrieve the names of employees who have no dependents.

 

Q 4 a.Discuss the correspondences between the ER model constructs and the relational model

constructs. Show how each ER model construct can be mapped to the relational model.

 

b.Describe the six clauses in the syntax of an SQL query and show what types of constructs

can be specified in each of the six clauses? Which of the six clauses are required and which are optional?

 

Q5 a.Considering database schema of problem of Q3(b) above, specify the following queries in SQL;

i) Show the resulting salaries if every employees working on the product X project is 5 given a ten percent raise.

ii) For every project located in Chennai, list the project number, the controlling g department number and the department manager’s last name and address.

iii) Retrieve the names of employees who have no dependents.

b.Discuss insertion, deletion and modification anomalies. Why are they considered bad? Illustrate with an example.

 

Q6a. Define and explain the first second and third normal forms.

b.What is the lossless (or non additive) join property of decomposition? Why is it important?

 

Q7.aDefine the fourth normal forms. When is it violated? Why is it useful?

b.What is the difference between discretionary and mandatory access control?

c.List the types of privileges available in SQL.

Q8 a.Discuss the ACID properties of a database transaction.

b.Discuss the problems of deadlock and starvation and the different approaches to dealing with these problems.

c.Describe the three phases of the ARIES recovery model.

 

Leave a Comment