CS 338: Computer Applications in Business: Databases
Winter 2014
[Home] [Schedule & Material] [Assignments] [Resources] [Marking] [Policies] [Staff] [Piazza Q&A]
The recommended textbook for the course is:
The course notes in the following table are complementary to the textbook; they are not meant to replace the textbook. You are expected to know both the material in the textbook (for the assigned sections) and the material in the course notes.
The following represents the intended lecture schedule. It may change as the term progresses.
It would help if you read the relevant material before the lecture; it is highly likely that I will not be covering everything in the book and lectures may go beyond the book.
| Date | Topic(s) | Course Notes | Readings from 6th edition (5th edition) |
|---|---|---|---|
| Jan 7 | Introduction to the Course; Introduction to Database Management | Module 0, Module 1 | Ch. 1 (Ch. 1) |
| Jan 9 | The Relational Data Model | Module 2 | Ch. 3 (Ch. 5) |
| Jan 14 | Integrity Constraints | Module 3 | Ch. 3 (Ch. 5) |
| Jan 16 | Constraints and Updates | Module 3 | Ch. 3 (Ch. 5) |
| Jan 21 | Basic SQL: DDL and Data Types | Module 4 | Sec. 4.1, 4.2 (Sec. 8.1, 8.2) |
| Jan 23 | Basic SQL: Simple Queries | Module 4 | Sec. 4.3 (Sec. 8.4) |
| Jan 28 | The Relational Algebra | Module 5 | Sec. 6.1-6.5 (Sec. 6.1-6.5) |
| Jan 30 | Advanced SQL: Renaming, Self Joins, and Aggregation | Module 6 | Sec. 4.3.2, 5.1.7 (Sec. 8.4.2, 8.5.7) |
| Feb 4 | Advanced SQL: Grouping and Nested Queries | Module 6 | Sec. 5.1.2-5.1.9 (Sec. 8.5.2-8.5.9) |
| Feb 6 | First Midterm Exam (Rooms: if your student id is below 20381800, you write in room RCH110; else you write in RCH307) | ||
| Feb 11 | Advanced SQL: Data and Schema Modifications | Module 7 | Sec. 4.4, 5.2, 5.4 (Sec. 8.3, 8.6-8.7) |
| Feb 13 | Advanced SQL: Null Values and Outer Joins | Module 8 | Sec. 5.1.1, 5.1.6 (Sec. 8.5.1, 8.5.6) |
| Feb 18 | reading week (no class) | ||
| Feb 20 | reading week (no class) | ||
| Feb 25 | Data Independence and Views | Module 9 | Sec. 2.2, 5.3 (Sec. 2.2, 8.8) |
| Feb 27 | Conceptual Modeling: The Entity-Relationship (ER) Model | Module 10 | Ch. 7 (Ch. 3) |
| Mar 4 | Conceptual Modeling: The Extended ER (EER) Model | Module 11 | Ch. 8 (Ch. 4) |
| Mar 6 | Logical Modeling: ER-to-Relational Mapping | Module 12 | Ch. 9 (Ch. 7) |
| Mar 11 | Second Midterm Exam (Rooms: if your student id is below 20381800, you write in room RCH307; else you write in RCH110) | ||
| Mar 13 | Dependencies and Normal Forms | Module 13 | Sec. 15.1-15.2, 15.5 (Sec. 10.1-10.2, 10.5) |
| Mar 18 | Database Security | Module 14 | Ch. 24 (Ch. 23) |
| Mar 20 | Transactions | Module 15 | Ch. 21 (Ch. 17) |
| Mar 25 | Concurrency Control | Module 16 | Sec. 21.5, 22.1 (Sec. 17.5, 18.1) |
| Mar 27 | Query Processing | Module 17 | Ch. 19 (Ch. 15) |
| Apr 1 | no class | ||
| Apr 3 | Distributed Databases | Module 18 | Ch. 25 (Ch. 25) |
| Apr 8 | Final Exam (12:30-3:00 pm in PAC 11,12) | ||