GATE 2011 DATABASE MANAGEMENT SYSTEM TUTORIALS
Posted by PRINCE KUMAR Saturday, February 27, 2010 , , , , ,

GATE 2011 DATABASE MANAGEMENT SYSTEM TUTORIALS

Module-1
Basic Of DBMS
  1. What Is DBMS?
  2. Data Abstraction
  3. Instance And Schema
  4. Attribute,Degree,Cardinality Of A Relation
  5. Key And Their Types
  6. Entity Integrity Constraints
  7. Referential Integrity Constraints
  8. Functional Dependency
  9. Fully Functional Dependency
  10. Partial Functional Dependency
  11. Trival Functional Dependency
  12. Non Trival Functional Dependency
  13. Irreducible Set of Functional Dependency
  14. Closure Of Attributes
  15. Decompositions
  16. Lossy and Lossless Join Decompositions
  17. Dependency Preservation

Module -2
Normalization
  1. 1 Normal Form
  2. 2 Normal Form
  3. 3 Normal Form
  4. BCNF Normal Form
  5. 5 Normal Form

Module 3
Relational Algebra
  1. Union Compatible
  2. Unary Operations
  3. Select
  4. Project
  5. Rename
  6. Binary Operations
  7. Set Difference
  8. Set Union
  9. Cartesian Product
  10. Derived Operations
  11. Intersection
  12. Join
  13. Division
  14. Assignment


Module -4
SQL
  1. Basic OF SQL
  2. DDL Commands
  3. DML Commands
  4. DCL Commands

Module 5
Transactions
  1. Basic Of Transaction
  2. ACID Property
  3. Schedule
  4. Serial Schedule
  5. Non Serial Schedule
  6. Conflict Operations
  7. Schedule Equivalent
  8. Result Equivalent
  9. Conflict Equivalent
  10. Serializablity Test
  11. View Serializablity
Module -6
E-R Diagrams
  1. Basic Of ER Diagrams
  2. Types Of Attributes
  3. Entity Sets
  4. Relationship Sets
  5. Mapping Cardinality
  6. Features Of ER Diagram

0 comments

Post a Comment

Popular Posts

Followers

SUBSCRIBE

Enter your email address:

Delivered by FeedBurner

Powered by FeedBurner

I heart FeedBurner