Next:
Contents
Contents
California State University - Hayward
Department of Math and Computer Science
CS 4660 DATABASE ARCHITECTURE
CS 6660 DATABASE SYSTEMS
Instructor: Ted Billard
Copyright 2001
Contents
Relational Databases
Introduction
Relational Model
Relational Operators
SQL Select
Query-By-Example (QBE)
Example Queries: Part A
Example Queries: Part B
Example Queries: Part C
Data Dictionary
SQL Features
Relational Calculus
Tuple Relational Calculus
Domain Relational Calculus
Tableau
Design
Normal Forms
Functional Dependencies
Covers
Algorithm to Decompose R into 3NF
Functional Dependency Preservation
Algorithm to Decompose R into BCNF
Index Mechanisms
Optimization
Database Concurrency
Appendix: Advanced Queries
About this document ...
Ted Billard 2001-10-31
