This site uses cookies to deliver our services and to ensure you get the best experience. By continuing to use this site, you consent to our use of cookies and acknowledge that you have read and understand our Privacy Policy, Cookie Policy, and Terms
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*.