CS 4400 - Summer 2018 GTL
- Lecture: 4 days per week from 11:30 - 12:30
Lecture Schedule
Topics link to slides, where available.
- FoDS means Fundamentals of Database Systems, the course textbook.
| Date | Topics | Reading and Resources | Reminders | Week 1 |
|---|---|---|---|
| 2018-05-14 | Dorm Check-in | ||
| 2018-05-15 | Orientations | ||
| 2018-05-16 | Introduction to CS 4400 |
Meet the Teacher |
|
| 2018-05-17 | Introduction to Databases |
FoDS 1 |
|
| 2018-05-18 | Database Concepts |
FoDS 2 |
Week 2 |
| 2018-05-21 | No Class | ||
| 2018-05-22 | Team Formation | ||
| 2018-05-23 | ER Models |
FoDS 3.1-3.7.3 Movie Rental ER Exercise Video: ER Models |
|
| 2018-05-24 | ER Models |
FoDS 3.1-3.7.3 Movie Rental ER Exercise Video: ER Models |
|
| 2018-05-25 | ER Models |
FoDS 3.1-3.7.3 Movie Rental ER Exercise Video: ER Models |
Week 3 |
| 2018-05-28 | EER Models |
FoDS 4.1-4.3 Humane Society EER Exercise |
|
| 2018-05-29 | Review 1 |
cs4400-exam1-practice.pdf cs4400-exam1-practice-answers.pdf |
|
| 2018-05-30 | Exam 1 |
|
|
| 2018-05-31 | Conceptual Design Process |
|
|
| 2018-06-01 | No Class | Week 4 |
|
| 2018-06-04 |
Exam 1 review Project Work Day Finalize team assignments |
||
| 2018-06-05 | Relational Model |
FoDS 5 |
|
| 2018-06-06 | Relational Model |
FoDS 5 |
|
| 2018-06-07 | Relational Algebra |
FoDS 8.1 - 8.3.4, 8.4.4 Relational Algebra Exercises - Answers Relational Algebra Masterclass |
|
| 2018-06-08 | No Class | Week 5 |
|
| 2018-06-11 | Relational Algebra |
FoDS 8.1 - 8.3.4, 8.4.4 Relational Algebra Exercises - Answers Relational Algebra Masterclass |
|
| 2018-06-12 | Relational Algebra |
FoDS 8.1 - 8.3.4, 8.4.4 Relational Algebra Exercises - Answers Relational Algebra Masterclass |
|
| 2018-06-13 | Project Work Day | ||
| 2018-06-14 | Project Work Day | Phase 1 Due | |
| 2018-06-15 | No Class | Week 6 |
|
| 2018-06-18 | Relational Calculus |
FoDS 8.5 |
|
| 2018-06-19 | Review 2 |
cs4400-exam2-practice.pdf cs4400-exam2-practice-answers.pdf |
|
| 2018-06-20 | Exam 2 |
|
|
| 2018-06-21 | ER - Relational Mapping |
FoDS 9 |
|
| 2018-06-22 | ER - Relational Mapping |
FoDS 9 |
Week 7 |
| 2018-06-25 | No Class | ||
| 2018-06-26 | No Class | ||
| 2018-06-27 | No Class | ||
| 2018-06-28 | ER - Relational Mapping |
FoDS 9 |
|
| 2018-06-29 | Basic Relational Design |
FoDS 14.1-14.3 |
Week 8 |
| 2018-07-02 | MySQL Install Fest | ||
| 2018-07-03 | Field Trip | ||
| 2018-07-04 |
SQL DDL SQL CRUD |
FoDS 6 FoDS 6 Exercise: Registration Database |
|
| 2018-07-05 | SQL Queries |
FoDS 6 Exercise: Dorms Queries |
|
| 2018-07-06 | No CS 4400 Lecture | Week 9 |
|
| 2018-07-09 | No Class | ||
| 2018-07-10 | SQL Queries |
FoDS 6 Exercise: Dorms Queries |
|
| 2018-07-11 | Advanced SQL |
FoDS 6,7 Exercise: Sakila Queries |
|
| 2018-07-12 | Relational Design |
FoDS 14.1-14.5 |
|
| 2018-07-13 | No CS 4400 Lecture | Week 10 |
|
| 2018-07-16 | In-class SQL exercises | ||
| 2018-07-17 | Project Work Day | ||
| 2018-07-18 |
Advanced SQL Relational Design |
FoDS 6,7 Exercise: Sakila Queries FoDS 14.1-14.5 |
|
| 2018-07-19 | Relational Design |
FoDS 14.1-14.5 |
|
| 2018-07-20 | No Class | Week 11 |
|
| 2018-07-23 | Relational Design |
FoDS 14.1-14.5 |
Phase 2 Due |
| 2018-07-24 | Advanced Relational Design |
FoDS 15.1-15.3 BCNF Decomposition Exercise |
|
| 2018-07-25 | Exam 3 |
|
|
| 2018-07-26 |
Storage Structures T-Square slides: Ch17_Ed.pdf Indexing Structures |
FoDS 16.1-16.7 FoDS 17 |
Final Instructional Day |
| 2018-07-27 | Reading Day - No Class | Finals Week |
|
| 2018-07-30 | |||
| 2018-07-31 | |||
| 2018-08-01 | Phase 3 Due* | ||
| 2018-08-02 | |||
| 2018-08-03 | Dorm Check-out |