DBMS IMP

 Credit [5]   from book technical publications

  Click here for DBMS G-drive.

ch.1 D. S. A.  <[5%]>

� database system not imp

� data abstraction

�  dbs architecture mimp

�   data independence

� DDL  DML

Ch. 2 data models <[12%]>

�2. 1 , 2.2...(example 2.2.2.)

E-R Diagrams mimp

� keys.. SK.. CK... PK... FK.

Ch. 3  R. Q. L. <[8%]>

� RElation Algebra mimp

�  selection, projection, cartesian product.

� union

� join 1 and 2 { mimp}

 Outer join... Left... Right.. Full... Mimp

� tuple relational calculus not imp

� Domain relation calculus not imp

�DDL DML

� MYSQL

� ORACLE not imp

  Ch. 4 R. D. D. <[10%]>

� Functional dependency mimp

� Armstrong's axioms

�Example 4.2.2  [ one time solve all example]

� N. F

 1 NF, 2NF, (4-24) 3NF (4-31) BCNF {..all.. MIMP} (4-39) 4NF

�concept of join dependencies mimp

�(4-43) Q. 1 and ,Q. 2

 Ch. 5  Q. P. O <[10%]>

� Basica of Query Processing mimp

�Measuring Cost   

�Query Optimization Algorithms

Ch:-6  <[7%]>

�indices

�B-tree with example

�hashing with example

Ch:- 7 transaction processing imp chapter<[15%]>

�acid property mmmmmimp

�serializability of scheduling

�conflict serializability

�view serializability

�need for concurrency (any one problem)

�two phase locking

�problem in two phase locking

�time stamp based scheduler

�deadlock

�failure classification

�undo/redo

 Ch:-8  <[7%]>

�DAC AND MAC

     AND difference dac vs Mac

Ch:-9  <[18%]>

�DDL, DML, DCL structure mmmmmimp

� Aggregate Function

� Group By and Having

�Example (9.2.6) (9.2.7)

[ one time solve all example]

�Commit.... Rollback.... Savepoint

Ch:-10  <[8%]>

�cursor

�stored procedures

�data triggers

Click here for DBMS G-drive.