Previous: Textbooks
Up: Contents
Next: Schedule
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
B. Whitehead
Univ. of Tennessee Space Institute
2007-07-31