R. C. Technical Institute, Ahmedabad
Computer Engineering Department
Sub: ADBMS (3340701)
Assignment-1
Unit-1 ADVANCE SQL
1. What is transaction? Explain TCL commands.
2. What is DCL? Differentiate GRANT and REVOKE.
3. Difference between TCL V/S
DCL.
4. What is LOCK? Explain types and levels of locks.
5. Differentiate : IMPLICIT LOCK
V/S EXPLICIT LOCK
6. What is sequence? How it can be created?
7. What is View? How to create View? Write advantage of view.
8. Differentiate between simple index and composite index.
Assignment-2
Unit-2 PL/ SQL AND TRIGGEERS
1. Write difference between SQL and PL/SQL. What
is cursor? Explain types of Cursor with attributes.
2. What is Exception? Explain handling of
user-defined exception with example.
3. Differentiate between Procedure and Function.
4. Explain structure of a Package.
5.
Write short note on types of triggers.
6.
Write
a PL\SQL code block that calculate the marks of three subjects and display
total by firing database trigger while inserting the marks of three subjects.
So total should automatically calculate at the time of inserting marks of three
subjects.
Table: Student (no, name, sub1, sub2, sub3)
Assignment-3
Unit-3 FUNCTIONAL DEPENDANCY ANDDECOMPOSITION
1.
What is Function
Dependency? Explain Armstrong’s axiom for functional dependency.
2. What is decomposition? Explain Lossy Decomposition and Lossless
Decomposition with example.
3. Write algorithm to find redundant functional dependency.
4. Write a step determining X+, the closure of X under F.
5. Compute closure of the following set F of functional dependencies
for relation R=(A,B,C,D,E)
i.
F={A -> BC, CD ->E , B-> D,E->A}
6. Remove any redundant FDs from the following sets of FDs.
i.
F={A -> B, B ->C, AD-> C}
ii.
F={XY->V, ZW->V,VX->Y,W->Y,Z->X }
Assignment-4
Unit-4 NORMALIZATION
1. What is normalisation? Explain 1NF and 2NF with example.
2. Explain importance of functional dependency in database design.
3. Write short note on: 3NF
4. Differentiate :FD V/S MVD
Assignment-5
Unit-5 TRANSACTION PROCESSING
1. Explain Transaction property.
2. What is concurrency control? Explain problems of concurrency
control.
3. Write short note on: Timestamp method
4. Write short note on: Optimistic method
