Topics

• Database Architecture

  External, Conceptual, and Internal Levels

• The Relational Database Model

  Domains and Attributes

  Tables and Relations

  Predicates and Queries

  Primary Keys and their Entity Integrity Rules

  Foreign Keys and their Referential Integrity Rules

• SQL (Database Definition, Manipulation & Query Language)

  The use of ISO/ANSI-standard SQL for vendor-independence and portability.

• Database Design

  Functional Dependencies

  Data Normalization (1st, 2nd, 3rd, & Boyce-Codd Normal Forms)

  Choosing Primary Keys and Foreign Keys

  Specifying Integrity Constraints

  Specifying User Views

  Implementing the Design in SQL

• Transaction Management

  Transactions

  Concurrency

  Recovery

• Entities, Relationships, and Objects

  Entity-Relationship Modeling

  Object/Relational Mapping