CS 499-A: Database Design and Implementation I
Week Day DoW Date Ch Topic Homework ---- --- --- ---- -- ---------------------- ----------- 11 21 Mon 6/8 Test 10 20 Wed 6/3 Finishing up Test Review 10 19 Mon 5/25 SQL-8 Stored Procedures 9 18 Th 5/21 SQL-8 Triggers 9 17 Wed 5/20 SQL-8 Triggers and Stores Procedures SQL-7 T-SQL Programming Constructs 8 16 Tue 5/19 SQL-7 T-SQL Programming Constructs SQL-6 Creating and Altering Database Objects (University Center at 3:00pm) 8 15 Mon 5/18 SQL-6 Creating and Altering Database Objects SQL-5 Transact-SQL Datatypes (University Center at 6:00pm) 7 14 Th 5/14 SQL-4 meeting in the lab (Univ. Center at 3:00pm) 7 13 Tue 5/12 SQL-4 Introduction to Transact-SQL 6 12 Mon 5/11 7 SQL-A Relational Database Language 6 11 Wed 5/6 12 Design Guidelines, ERWin Assignment Functional Dependencies, and Normalization 5 10 Mon 5/4 12 Design Guidelines, Functional Dependencies, and Normalization Going over the test 5 9 Wed 4/29 Test 4 8 Mon 4/27 6 The Relational Model and Exercise #1 Relational Algebra 4 7 Wed 4/22 6 The Relational Model and Assignment#1 Relational Algebra 3 6 Mon 4/20 ERWin Data Modeling 4 Blocks, Buffers, and File Organizations 3 5 Wed 4/15 Accounts verifications 4 Storage Devices 2 4 Mon 4/13 3 Data Modeling using the ER Model 2 3 Wed 4/8 2 Database System Concepts and Architecture 1 2 Mon 4/6 1 Databases and Database Users Read Chapters 1&2 1 1 Wed 4/1 Class Introduction Syllabus
Last update May 21, 1998.