MCAD Unit 1

MCADChapter1 Material by rutvi sheth on Scribd

ADBMS Assignments

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

Difference Between Linear Layout and Relative Layout in Android

Relative Layout:

A relative layout displays its views relative to one another or relative to parent , so order is not that important. You can define the top most view at the end of the layout and provide details to show it on top left. The following attributes are used to define relative layouts:

1. Position relative to Parent: You can align a view relative to parent using alignParentTop, centerHorizontal etc.
2. Position relative to other views: You can align a view relative to another view using above, below, toLeftOf etc.
3. Margins: You can provide margins using marginTop, marginLeft etc.

Linear Layout:

A linear layout displays its views next to each other either vertically or horizontally. So, if you define views in a row, they will be displayed one after the other. You need to specify orientation to define whether layout is vertical or horizontal. The following attributes are used to define linear layouts:

1. Weight: It specifies how much space each view spans relative to others. For example, in an e-mail application, you can give less weight to ‘To’ and ‘Subject’, and more weight to ‘Message’.
2. Gravity: It defines placement of a view’s contents. You can decide whether it should be displayed on top, center or bottom.
3. Layout Gravity: It defines the placement of the view itself.