Table of Contents

• Chapter 1: The Relational Model
  • Relational Database
  • Integrity Constraints
  • Tabular View of a Relation
  • Sample Databases
  • Relational Algebra
• Chapter 2: Oracle SQL
  • Oracle SQL Plus
  • Creating, Dropping and Altering Tables
  • Inserting Rows
  • Querying the Database
  • Views
  • Modifying the Database
  • Sequences
  • Oracle Data Dictionary
• Chapter 3: Embedded SQL
  • Host Variables
  • Indicator Variables
  • SQL Communications Area
  • Connecting to Oracle
  • Cursors
  • Mail Order Database Application
  • Recursive Queries
  • Error handling
  • Transaction Control
  • Dynamic SQL
• Chapter 4: PL/SQL
  • What is PL/SQL
  • Datatypes and Variables
  • Program Control Statements
  • Program Structure
  • Triggers
  • Database Access using Cursors
  • Records
  • PL/SQL Tables
  • Built-In Packages
  • Error Handling
• Chapter 5: Oracle JDBC
  • What is JDBC
  • A Simple Exercise
  • Developing JDBC Applications
  • Non-Query SQL Statements
  • Executing SQL Queries
  • A Complete Example
  • Database Metadata
  • Errors and Warnings
• Chapter 6: Projects
  • Airline Flight Information Systems
  • Library Database Application
  • University Student Database
  • Video Chain Database
  • Banking Database
  • BibTeX Database
  • Music Store Database