Mumbai University Question Papers Database Management System

Mumbai University question papers

 IV Sem CSE

Examination DEC 2009

Database Management System

N.S.: (1) Question NO.1 is compulsory.

(2) Attempt any four questions out of remaining six questions.

1. (a) Define following terms with example :-

(i) Single and composite attributes

(ii) Single valued and multivalued attributes

(iii) Entity Set

(iv) Relationship Set

(v) Aggregation.

(b) What do you mean by Database Management System? Why would you choose a databse system instead of simply storing the data in operating system files?

2. (a) For the given database, write SQL queries :-

employee (eid, employee_name, street, city)

Works (eid, cid, salary)

Company (cid, company_name, city)

Manager (eid, manager_name)

(i) Find the names, street and city of all employees who work for “ABC” and earn more than Rs. 20,000.

(ii) Find the names of all employees having “i” as the second letter in their names.

(iii) Display the annual salary of all employees.

(b) Discussthe differentsecurityandauthorizationmechanismsin databasemanagement system.

3. (a) For the following problem draw an E-R diagram :-

“ABC Company” is a software company, that has several employees working on different types of projects, on different platforms. Projects have different schedules and may be in one of several phases. Each project has a project leader and team member at different levels.

(b) List the ACID properties. Explain the usefulness of each.

4. (a) Explain type of constraints with an example.

(b) Explain 1NF,2NF and 3NF with suitable example.

5. (a) What is Recoverable Schedule? Why recoverability of schedule is desirable?  Are there any circumstances under which it would be desirable to allow non-recoverable schedule? f=xplain.

(b) Expain the insertion of entry in a B+tree. 10

6. (a) Compare shadow page recovery scheme with log based recovery scheme.

(b) Explain following relational algebra operations :-

(i) Generalized Projection

(ii) Set Difference

(iii) Assignment

(iv) Aggregate.

7. Write short notes on the following :-

(a) Timestamp ordering protocol

(b) Triggers

(c) Database administrator

(d) Group by and order by clause in SQL.

 

Leave a Comment