Mumbai University Sample Paper CSE 4th Sem DBMS

Mumbai University Sample Paper CSE 4th Sem DBMS

1) Question NO.1 is compulsory.

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

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 10
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” 4
and earn more than Rs. 20,000.
(ii) Find the names of all employees having “i” as the second letter in 3
their names.
(iii) Display the annual salary of all employees. 3
(b) Discussthe differentsecurityandauthorizationmechanismsin databasemanagement 10
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? 10
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