Relational Database Management System

<p>Book contain Database Concepts: A Relational approach: Database - Relationships - DBMS - Relational Data Model - Integrity Rules - Theoretical Relational Languages. Database Design: Data Modeling and Normalization: Data Modeling - Dependency - Database Design - Normal forms - Dependency Diagrams - De -normalization - Another Example of Normalization. Oracle9i: Overview: Personal Databases - Client/Server Databases - Oracle9i an introduction - SQL *Plus Environment - SQL - Logging into SQL *Plus - SQL *Plus Commands - Errors and Help - Alternate Text Editors - SQL *Plus Worksheet - iSQL *Plus. Oracle Tables: DDL: Naming Rules and conventions - Data Types - Constraints - Creating Oracle Table - Displaying Table Information - Altering an Existing Table - Dropping Renaming Truncating Table - Table Types - Spooling - Error codes. Working with Table: Data Management and Retrieval: DML - adding a new Row/Record - Customized Prompts - Updating and Deleting an Existing Rows/Records - retrieving Data from Table - Arithmetic Operations - restricting Data with WHERE clause - Sorting - Revisiting Substitution Variables - DEFINE command - CASE structure. Functions and Grouping: Built-in functions -Grouping Data. Multiple Tables: Joins and Set operations: Join - Set operations. </p>