TR 0600 - 0725 pm (KOM 323)
Tentative Schedule
| Date | Lecture Topic | Labs | |
| Week 1 | Aug. 26 | Chap. 1: Databases and Database Users | |
| Aug. 28 | Chap. 2: Database System Concepts and Architecture | Lab 1 | |
| Week 2 | Sep. 2 | Chap. 3: Entity-Relationship Model (Entity, Attribute, Key, and Relationship) | |
| Sep. 4 | Chap. 3: Entity-Relationship Model (Relationship type, Weak Entity, The COMPANY database example) | ||
| Week 3 | Sep. 9 | Chap. 3: Entity-Relationship Model (Conceptual Model Design Guidelines) | Lab 2 |
| Sep. 11 | Chap. 4: Enhanced Entity-Relationship Model (Enhanced Entity-Relationship) | ||
| Week 4 | Sep. 16 | Chap. 4: Enhanced Entity-Relationship Model (University database, Relational model concepts) | Lab 3 |
| Sep. 18 | Chap. 5: Relational Data Model and Constraints (Constraints) | ||
| Week 5 | Sep. 23 | First Exam | |
| Sep. 25 | Chap. 6: Relational Algebra (exam discussion) | ||
| Week 6 | Sep. 30 | Chap. 6: Relational Algebra (Relational algebra: select, project, rename) | Lab 4 (programming contest) |
| Oct. 2 | Chap. 6: Relational Algebra (Relational algebra: union, intersection, minus, cartesian product, join, equijoin) | ||
| Week 7 | Oct. 7 | Programming contest | |
| Oct. 9 | Chap. 6: Relational Algebra (University closed due to creditable threat) | ||
| Week 8 | Oct. 14 | Fall break. No class. | |
| Oct. 16 | Chap. 6: Relational Algebra (natural join, division, outerjoin, generalized project, aggregate function) | Lab 5 | |
| Week 9 | Oct. 21 | Chap. 7: Converting ER & EER to Relational Model (Mapping ER to RM) | |
| Oct. 23 | Chap. 8: SQL (CREATE TABLE statement) sqlplus_guide | ||
| Week 10 | Oct. 28 | Second Exam | |
| Oct. 30 |
Chap. 8: SQL (Create, Drop, Alter, Insert, Delete,
Update) CompanySchema.sql
UniversitySchema.sql
|
SQL-99 BNF Grammar |
|
| Week 11 | Nov. 4 | Chap. 8: SQL (Single table query including operators like LIKE, IN, EXISTS, BETWEEN) | |
| Nov. 6 | Chap. 8: SQL (Single table query, combine multiple queries, and multi-table query) |
Lab 6 Lab6 Instruction |
|
| Week 12 | Nov. 11 | Chap. 8: SQL (Multi-table query) | |
| Nov. 13 | Chap. 9: SQL Programming: (Embedded SQL, OCCI) OcciExample.zip | ||
| Week 13 | Nov. 18 | Third Exam | |
| Nov. 20 | Chap. 9: SQL Programming (Exam discussion, JDBC, PHP) JdbcExample.zip | Lab 7 | |
| Week 14 | Nov. 25 | Chap. 10: Function Dependencies (Database design guideline, functional dependencies) | |
| Nov. 27 | Thanksgiving Holidays. No class. | ||
| Week 15 | Dec. 2 | Chap. 11: Normalization (Normal Forms and Normalization) | |
| Dec. 4 | Study day. No class | ||
| Week 16 | Dec. 9 | Final Exam: 6:00 - 8:00 pm, KOM 323 | |
Notes:
Class Resources
| Syllabus | Please take your time to go through the syllabus carefully and with patience. |
| $PUB | All class examples, assignments, and source codes are available in this directory. |
| Important Dates | Sep. 7: Last day for a 75%
refund/reduction in fees Sep. 7: Last day to drop or withdraw WITHOUT a grade Sep. 20: Last day for a 25% refund/reduction in fees Oct. 20: Last day to drop or withdraw with a grade of "W" Nov. 26: Last day to withdraw from the University |