Database-An Introduction-Relationships-Database Management System-The Relational Database4 Model-Integrity Rules-Theoretical Relational Languages-Relational Algebra-Relational calculus. Database Design: Data Modeling and Normalization: Data Modeling-Dependency-Database Design-Normal Forms-Dependency Diagrams-De-normalization.
Personal Databases-Client Server Databases – Oracle 9i : An Introduction-The SQL * Plus Environment – Structures Query Language- Logging into SQL * Plus- SQL * Plus Commands-Oracle Error and Online Help. Oracle Tables: Data Definition Language(DDL): Naming Rules and Conventions-Data types-Constraints-Creating Oracle Table-Displaying Table Information-Altering An Existing Table –Dropping ,Renaming and Truncating Table.
Data Manipulation Language-Adding a new Row/record-Customized Prompts-Updating and Deleting Existing Row/record-Retrieving Data from a Table-Restricting Data with Where clause. Built-In Functions- Grouping Data. Multiple Tables: Join and Set Operators.
A Brief History of PL/SQL-Fundamentals of PL/SQL-PL/SQL block Structure-Comments-Data Types-Other Data Types-Variable Declaration-Anchored Declaration-Assignment Operation-Bind Variables-Substitution Variables in PL/SQL.
Control Structures- Nested Blocks- SQL in PL/SQL-Data Manipulation in PL/SQL- Transaction Control Statements.
Reference Book:
1. Database Management Systems – Arun Majumdar & Pritimoy Bhattacharya, 2007, Tmh. 2. Database Management Systems – Gerald V. Post, 3rd Edition, Tmh.
Text Book:
Nilesh Shah, “Database Systems Using Oracle”, Second Edition, PHI, 2008
