Wednesday, August 8, 2007

DBMS UNIT - 3

Form of Basic SQL Query - Examples of Basic SQL Queries - Introduction to Nested Queries - Correlated Nested Queries set - Comparision Operators - Aggregative Operators - NULL values - Comparision Using Null values - Logical connectivities - AND, OR and NOT - Joins - VIEWS

nalamalan.googlepages.com/dbmsunit-3

DBMS Assignment - 1

http://nalamalan.googlepages.com/dbmsassignment-1

Monday, August 6, 2007

DBMS UNIT - 2

Relational Model : Introduction to the Relational Model – Integrity Constraint Over relations – Enforcing Integrity constraints – Querying relational data – Logical data base Design – Introduction to Views – Destroying /altering Tables and Views.
Relational Algebra and Calculus : Relational Algebra – Selection and projection set operations –
renaming – Joins – Division – Examples of Algebra overviews – Relational calculus – Tuple relational Calculus – Domain relational calculus – Expressive Power of Algebra and calculus.

http://nalamalan.googlepages.com/dbms-unit-2