CS 338: Computer Applications in Business: Databases

Textbook

The recommended textbook for the course is:

Fundamentals of Database Systems (5th, 6th, or 7th ed) by R. Elmasri and S. Navathe, Pearson, 2011.

Some copies of the book are on reserve in the DC library (call numbers are UWD 1516, QA76.9 D3E57 2007, and QA76.9 D3E57 2011).

The course notes in the following table are complementary to the lectures; they are not meant to replace the lectures. The textbook provides additional material to the course notes.

Schedule and Course Notes (by week of classes)

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.

09/10:
Introduction to the Course, Introduction to Database Management Ch. 1 (Ch. 1),
09/14-18:
The Relational Data Model: data model, query languages Ch. 3 (Ch. 5) More on the relational model: safe queries and integrity constraints,
09/21-25:
Introduction to SQL
09/28-02:
More on SQL
10/05-09:
SQL with duplicates and NULL values Sec. 4.3.2, 5.1.2-5.1.9 (Sec. 8.4.2, 8.5.2-8.5.9),
10/12-16:
Reading Week
10/19-23:
Application Development and SQL Sec. 5.1.1, 5.1.6 (Sec. 8.5.1, 8.5.6) More
10/26-30:
Introduction to ER Modeling Ch. 8 (Ch. 4)
11/02-06:
ER to Relational Mapping SQL Data Definition, Views, and Security Sec. 15.1-15.2, 15.5 (Sec. 10.1-10.2, 10.5)
Dependencies and Normal Forms Sec. 2.2, 5.3 (Sec. 2.2, 8.8), Ch. 9 (Ch. 7), Ch. 24 (Ch. 23)
11/09-13:
Query/Update Execution Ch. 19 (Ch. 15)
11/16-20:
Concurrent Access to Data and Transactions
11/23-27:
Database Tuning Ch. 21 (Ch. 17)
11/30-04:
Data Integration and Advanced Topics,
12/07-08: