Principles of Database Management Systems CSE 544

4/26/99


Click here to start


Table of Contents

Principles of Database Management Systems CSE 544

Staff

Course Times

Goals of the Course

Grading

Textbook

Other Useful Texts

Prerequisites

Real Prerequisites

Why Use a DBMS?

Functionality of a DBMS

Persistent Storage

Transaction Processing and Recovery

Physical vs. Logical Levels

The Relational Model

Logical Model Issues

Querying a Database

Issues in Query Languages

Query Optimization

Database Industry

Course (Rough) Outline

Course Outline (cont)

PPT Slide

Terminology

More Terminology

More on Tuples

Integrity Constraints

Keys

Foreign Key Constraints

Functional Dependencies

Some Obvious Properties of FDs

Comparing Functional Dependencies

Closure Algorithm

Problems in Designing Schema

Relation Decomposition

Boyce-Codd Normal Form

Author: cse

Email: zives@cs.washington.edu

Home Page: http://www.cs.washington.edu/homes/zives

Download presentation source