sign in
 
   
 
 
  DBMS - TUTORIALS & LAB EXERCISES  
   
  Introduction to DBMS (PPT)
Posted by Murugan R
 
  DBMS Architecture (PPT)
Posted by Murugan R
 
  Data Models (PPT)
Posted by Murugan R
 
  Database Users (PPT)
Posted by Murugan R
 
  Theory of Normalization (PPT)
Posted by Murugan R
 
  Theory of Normalization-Part II (PPT)
Posted by ..
 
  Structured Query Language - SQL (Tutorial)
Posted by Murugan R
 
     
  Relational Model  
 
  Entity, Attribute and Domain
  Types of Attributes
  Strong and Weak Entity Sets
 
  Structure of Relational Databases  
  Relational Constraints  
 
  Domain Constraints, Key Constraints and Integrity Constraints
  Database Operations and Constraints Violations
 
  Query Languages  
  The Relational Algebra  
 
  Fundamental Operations
 
  Select, Project, Union, Set Difference, Cartesian Product and Rename
  Other Operations
 
  Set Intersection, Natural Join, Division and Assignment
  Extended Operations
 
  Generalized Projection, Aggregate Functions and Outer Joins
 
  The Tuple Relational Calculus  
  The Domain Relational Calculus