C SC 330

Syllabus:

Click here to view the course syllabus

Class Overheads:

Each file will open in a separate window.

• Chapter 1: Introduction
• Chapter 2: Database Concepts
• Chapter 13: Disk Storage
• Chapter 14: Indexing
• Chapter 3: ER Models
• Chapter 4: EER Models
• Chapter 5: The Relational Data Model
• Chapter 6: Relational Algebra
• Chapter 7: Relational Design using ER and EER Diagrams
• Chapter 8: SQL
• Chapter 9: Advanced SQL
• Chapter 10: Normalization
• Chapter 11: Relational Design Algorithms
• Chapter 19: Database Recovery
• Chapter 23: Database Security
• Chapter 30: Emerging Applications
• Chapter 28: Data Mining

Assignments:

• Assignment 1: Disk Storage (due: 9/15/08)
• Assignment 2: ER Models (due: 9/29/08)
• Assignment 3: EER Models (due: 10/3/08)
• Assignment 4: Relational Data Model (due: 10/10/08)
• Assignment 5: Relational Algebra (due: 10/29/08)
• Assignment 6: ER to Relational Mapping (due: 10/31/08)
• Assignment 7: SQL (due: 11/7/08)
• Assignment 8: SQL Implementation (due: 11/10/08)
• Assignment 9: Normalization (due: 11/21/08)
• Assignment 10: Relational Design Algorithms (due: 12/1/08)