Database System Architecture - Basic Concepts: Data System, Operational Data, Data Independence, Architecture for a Database System, Distributed Databases, Storage Structures: Representation of Data. Data Structures and Corresponding Operators: Introduction, Relation Approach, Hierarchical Approach, Network Approach  

Structure of relational databases – the relational algebra - the tuple relational calculus - the domain relational calculus. Relational Database Design: Pitfalls in relational-database design – decomposition – normalization.

DDL - DML– Data Types – Constraints – Creating Oracle Table – Displaying Table Information – Altering an Existing Table – Dropping, Renaming, Truncating Table.

Introduction to scripting –operators: logical-Increment and decrementoperators –Control structures-Loop Statements- Functions: Definition-scope rules-recursion.

Declaring arrays-passing arrays to functions-sorting arrays-object: Math object-stringObject-Date object-Boolean object and Number object