CS 317: Syllabus

"Due-dates in syllabus are closer than they appear"

General Info
Assignments

Where are we?: week 5

Changed: 4/30/2002

Here is the syllabus for the course. This is a repository for assignments, lecture notes, reading assignments, and the broad topics for each week. Note: this syllabus is approximate and is liable to change repeatedly.

The Worlds of Database Systems; (Apr 4)

  • (Apr 4) Lecture: What should I expect in this class? Introduction to databases. (Chapter 1)
  • (Apr 4) Assignment #1: Fun with Amazon. Due April 11th.

The Entity/Relationship Data Model; (Apr 9 and 11)

  • (Apr 9) Lecture: Elements of the entity-relationship data model and design principles. (Sections 2.1 and 2.2)
  • (Apr 11) Lecture: E/R design principles and modeling constraints. (Sections 2.2 and 2.3)
  • (Apr 11) Assignment #2: Manipulating E/R models. Due April 18th.

The Entity/Relationship Data Model; The Relational Data Model; (Apr 16 and 18)

  • (Apr 16) Lecture: Modeling constraints and Weak entity sets. (Sections 2.3 and 2.4)
  • (Apr 18) Lecture: Basics of the relational data model. (Sections 3.1 and 3.2)
  • (Apr 18) Assignment #3: Converting E/R models to relational models. Due April 25th.

The Relational Data Model; (Apr 23 and 25)

  • (Apr 23) Lecture: Functional Dependencies (Sections 3.3 through 3.5)
  • (Apr 25) Lecture: Normal Forms (Section 3.6)

Normal Forms (Apr 30 and May 2)

  • (Apr 23) Lecture: BCNF and 3NF (Section 3.6)
  • (Apr 25) Lecture: Multivalued Dependencies and 4NF (Section 3.7)

Relational Algebra; Midterm (May 7 and May 9)

  • (May 7) Lecture: Relational Algebra (Sections 5 through 5.2.6)
  • (May 9) Midterm

Relational Algebra and SQL (May 14 and May 16)

Other Data Models; SQL (May 21 and May 23)

The Project; SQL (May 28 and May 30)

The Project; SQL (Jun 5 and Jun 7)

Final Project is Due