This page provides a guide to some of the Webpages used to support the I-School course, Database-Management Principles and Applications, as I taught it prior to retiring from UT-Austin.
The currently available materials are:
Course Description (for a typical long semester)
Assignments for Studying the Cassel and Palmer Text
Course Schedule (for a typical long semester)
Introduction to Database Integrity Concepts
Introduction to Table 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*.
Meeting
14: Designing Distributed Databases (DDBs)*.
Notes on SQL (Structured Query Language)
Relational-Algebraic Operations on Database Tables
Supplemental Information for LIS 384K.11
Variable-Length Record Structures
* Lecture Materials marked with an asterisk are in the form of Microsoft PowerPoint files
**The Study Materials files are Portable Document Format (".pdf") files. To read them, you need to have Adobe Acrobat Reader as a plug-in for your browser. If you do not already have Acrobat Reader associated with your browser, you can download a free copy from the Adobe Acrobat Reader Webpage.
Go to Wyllys Webpage
Last revised 2004 Feb 23