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

Sunday, July 22, 2007

DBMS UNIT - 1

Data base System Applications, data base System VS file System – View of Data – Data Abstraction –Instances and Schemas – data Models – the ER Model – Relational Model – Other Models – Database Languages – DDL – DML – database Access for applications Programs – data base Users and Administrator– Transaction Management – data base System Structure – Storage Manager – the Query Processor –History of Data base Systems.Data base design and ER diagrams – Beyond ER Design Entities, Attributes and Entity sets – Relationships and Relationship sets – Additional features of ER Model – Concept Design with the ER Model – Conceptual Design for Large enterprises.
http://nalamalan.googlepages.com/home

Friday, July 13, 2007

C Language stuff

Introduction

C Tokens

Loops

Arrays

Pointers

Sturctures

Unions

Datastructures

http://nalamalan.googlepages.com/cprogramming