The Lecture notes covers database architecture, design, administration, and implementation. Evaluation and use of database-management systems for computers, with emphasis on microcomputer-based systems.
Assignments for Studying the Cassel and Palmer Text
Course Description (for a typical long semester)
Course Schedule (for a typical long semester)
Introduction to Database Integrity Concepts
Introduction to Table Concepts
Key Concepts
Lecture Materials for LIS 384K.11
Meetings 1 and 2: Introduction to Database Concepts*. See also "Introduction to Table Concepts" above.
Meeting 3: Tables and Their Components*. See also "Introduction to Database-Integrity Concepts" and "Key Concepts" above, and "Variable-Length Record Structures" below.
Meeting 4: See "Relational-Algebraic Operations on Database Tables" below.
Meeting 5: Structured Query Language (SQL)*. See also "Notes on SQL (Structured Query Language)" below.
Meeting 6: Basic Concepts of Entity-Relationship Analysis*
Meeting 7: See "Overview of Normalization" below.
Meetings 8 and 9: See "Steps in Normalization" below.
Meetings 10 and 11: How to Design and Develop a Database Application*. See also Don Drumtra's presentation on How to Learn from a Failed Database Design Effort*.
Meetings 12 and 13: Transaction Analysis and Management, & Concurrency Control*.