CS 338: Computer Applications in Business: Databases

Fall 2013

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	Relevant Course Notes	Readings from 6th edition (5th edition)
Sept. 10	Introduction to the course, Introduction to database management	Module 0 & Module 1	Ch. 1 (Ch.1)
12	Relational Data Model	Module 2	Ch. 3 (Ch. 5)
17	Constraints and Updates	Module 3	Ch. 3 (Ch. 5)
19	SQL: DDL, Basics and Set Operations	Module 4	Sec. 4.1-4.3 (Sec. 8.1, 8.2, 8.4)
24	Relational Algebra	Module 5	Sec. 6.1-6.5 (Sec. 6.1-6.5)
26	Advanced SQL: Aggregate and Group Queries	Module 6	Sec. 5.1.4-5.1.5, 5.1.7-5.1.9 (Secs. 8.5.4-8.5.5, 8.5.7-8.5.9)
Oct. 1	Advanced SQL: Nested Queries	Module 6	Sec. 5.1.2-5.1.3 (Sec. 8.5.2-8.5.3)
3	Catchup
8	Midterm Exam -- in DC 1351
10	Advanced SQL: Data and schema modifications	Module 7	Sec. 4.4, 5.2, 5.4 (Sec. 8.3, 8.6-8.7)
15	Advanced SQL: Null values	Module 8	Sec. 5.1.1, 5.1.6 (Sec. 8.5.1, 8.5.6)
17	Views	Module 9	Sec. 5.3 (Sec. 8.8)
22	Conceptual modeling: Entity-Relationship (ER) model	Module 10	Ch. 7 (Ch. 3)
24	Conceptual modeling: Extended ER (EER) model	Module 11	Ch. 8 (Ch. 4)
29	Logical modeling: ER-to-relational mapping	Module 12	Ch. 9 (Ch. 7)
31	Dependencies	Module 13	Sec. 15.1-15.2, 15.5 (Sec. 10.1-10.2, 10.5)
Nov. 5	Catchup
7	DBMS Architecture	Module 14	Ch. 2 (Ch. 2)
12	Transaction support in SQL	Module 15	Ch. 21 (Ch. 17)
14	Midterm Exam -- in DC 1351
19	Concurrency & Recovery	Module 16	Ch. 22.1, 23 (Ch. 18.1, 19)
21	Query Processing	Module 17	Ch. 19 (Ch. 15)
26	Query Processing	Module 17	Ch. 19 (Ch. 15)
28	Database security and privacy	Module 19	Ch. 24 (Ch. 23)
Dec 12	Final Exam (9:00-11:30AM) in DC 1350