All readings are from the textbook, (Elmasri, R & Navathe, S. (2004). Fundamentals of Database Systems. Addison-Wesley) or are e-journals available through the UNC-CH library [e-journal], [ACM DL]. [e-journal] readings may be reached through the UNC-CH library e-journal list. If you want to access an e-journal from off campus, you may need to add the proxy prefix to the URL: see Off-Campus Access for more information.

A brief list of topics and thought questions is given in the Class Outlines. I will update entries as we come to each section.

INTRODUCTION

• Elmasri & Navathe, Ch. 1, Databases and Database Users

• Outline: DB Basics
• Assign ER-Visio Tutorial, Due Thursday, 8/30/07

Tuesday, 8/28/07: Database basics 2, DB Concepts

• Elmasri & Navathe, Ch. 12.1, The Role of Information Systems in Organizations
• Elmasri & Navathe, Ch. 2, Database System Concepts and Architecture

• Slides: DB Concepts
• Assign Database-Access Tutorial, Part 1, due Thursday, 9/6/07

SEMANTIC MODELING

• Elmasri & Navathe, Ch. 3.1 - 3.4, Using High-Level Conceptual Data Models for Database Design; An Example Database Application; Entity Types, Entity Sets, Attributes, and Keys; Relationship Types, Relationship Sets, Roles, and Structural Constraints

• Outline: ER Basics
• Slides: Entity Relationship Models
• ER-Visio Tutorial due.

Tuesday 9/4/07: ER basics 2

• Elmasri & Navathe, Ch. 3.5-3.9, Weak Entity Types; Refining the ER Design for the Company Database; ER Diagrams, Naming Conventions, and Design Issues; Notation for UML Class Diagrams; Summary

• Acme Tours ER
• Company ER

Thursday, 9/6/07: ER basics 3

• DB Access Tutorial Part 1 due
• Assign DB Access Tutorial Part 2, due Tuesday, 9/18/07

Tuesday, 9/11/07: ER basics 4

• Assign ER Model assignment, due Tuesday, 9/25/07
• Example solution to ACME DB tutorial.
• Radio Show ER

RELATIONAL MODEL

• Elmasri & Navathe, Ch. 5, The Relational Data Model and Relational Database Constraints

• Outline: Relational Model
• Slides: Relational Model Basics

Tuesday, 9/18/07: Relational model basics 2

• DB Access Tutorial Part 2 due.

Thursday, 9/20/07: ER to DB mapping 1

• Elmasri & Navathe, Ch. 7.1, Relational Database Design Using ER-to-Relational Mapping

• Outline: ER-DB Mapping
• Slides: ER-DB Mapping
• Slides: ACME tour ER
• Slides: ACME schema
• Slides: ACME tour -- wrong
• Assign Database 2, Part 1, due Tuesday, 10/9/07

Tuesday, 9/25/07: ER to DB mapping 2

• Radio Show Schema
• ER assignment due.

Thursday, 9/27/07: Extended ER basics

• Elmasri & Navathe, Ch. 4, Enhanced Entity-Relationship and UML Modeling

• Review Part 4, Generalization and Specialization of the ER-Visio tutorial
• Outline: EER
• Slides: Ternary relationships
• Slides: EER

Tuesday, 10/2/07: EER to DB mapping

• Elmasri & Navathe, Ch. 7.2 & 7.3, Mapping EER Model Constructs to Relations; Summary

• Slides: EER-DB Mapping
• Radio Show EER schema
• Assign Schema assignment, due Tuesday, 10/16/07.

SQL AND RELATIONAL ALGEBRA

• Elmasri & Navathe, Ch. 8.4-8.7, Basic Queries in SQL; More Complex SQL Queries; Insert, Delete, and Update Statements in SQL; Additional Features of SQL

• Outline: SQL DML
• Slides: SQL DML
• ER assignment solution
• Assign ER makeup assignment, due no later than Thursday, 10/25/07.

Tuesday, 10/9/07: SQL DML 2

• Database 2 Part 1 due.
• Assign Capstone Project Part 1, due Thursday, 11/1/07.

Thursday, 10/11/07: SQL DML 3

• Assign Database 2 Part 2, due Thursday, 11/8/07.
• Assign SQL-RA assignment, due Tuesday, 11/13/07.
• ACME tour SQL exercise
• Radio show ER

Tuesday, 10/16/07: SQL DML 4

• Schema assignment due.
• Radio puzzle SQL examples
• Company SQL examples

Thursday, 10/18/07: Fall Break, no class

Tuesday, 10/23/07 & Thursday, 10/25/07: ASIST Conference, no class

Tuesday, 10/30/07: SQL DDL

• Elmasri & Navathe, Ch. 8.1 - 8.3, SQL Data Definition and Data Types, Specifying Basic Constraints in SQL, Schema Change Statements in SQL

• Slides: SQL DDL
• Company DDL
• DDL exercise
• Schema makeup assignment. Due no later than Thursday 11/15/07.

Thursday, 11/1/07: Relational Algebra 1

• Elmasri & Navathe, Ch. 6.1 - 6.5 Unary Relational Operations: Select and project; Relational Algebra Operations from Set Theory; Binary Relational Operations: Join and Division; Additional Relational Operations; Examples of Queries in Relational Algebra

• Outline: Relational algebra

• Slides: Relational algebra
• Relational algebra exercises and answers
• Radio show relational algebra
• Capstone project Part 1 due.

Tuesday, 11/6/07: Relational Algebra 2

• Capstone Project Part 2 should be completed sometime between Monday, 11/5/07 and Friday, 11/16/07.

NORMALIZATION AND DATA QUALITY

• Elmasri & Navathe, Ch. 12.2, The Database Design and Implementation Process
• Elmasri & Navathe, Ch. 10.1 & 10.2, Informal Design Guidelines for Relation Schemas; Functional Dependencies

• Outline: Functional dependencies and normalization
• Slides: Design and Functional Dependencies
• DB2 Part 2 due.

Tuesday, 11/13/07: Normalization 1

• Elmasri & Navathe, Ch. 10.3 - 10.6, Normal Forms Based on Primary Keys; General Definitions of Second and Third Normal Forms

• Slides: Normal forms
• Normalization exercise 1 solution
• SQL-RA assignment due.

Thursday, 11/15/07: Normalization 2

• Normalization exercise 2
• Normalization exercise part 3
• Assign Normalization Assignment, due Thursday, 11/29/07.
• Schema makeup assignment due.

Tuesday, 11/20/07: Normalization 3

Thursday, 11/22/07: Thanksgiving, no class

Tuesday, 11/27/07: Data Quality, Reverse Engineering 1

• Orr, K. (1998). Data quality and systems theory, Communications of the ACM, 41(2), 66-71. [e-journal, ACM DL]
• Redman, T. (1998). The impact of poor data quality on the typical enterprise Communications of the ACM, 41(2), 79082. [e-journal, ACM DL]
• Premerlani, W. & Blaha, M. (1994). An approach for reverse engineering of relational databases Communications of the ACM, 37(5), 42-49. [e-journal, ACM DL]

• Outline: Reverse engineering
• Slides: Data quality

Thursday, 11/29/07:Reverse engineering 2

• Normalization assignment due.
• Slides: Reverse engineering

Tuesday, 12/4/07: Reverse engineering 3; Wrap-up

Tuesday, 12/11/07, 9:30 a.m.: Capstone Project Part 3 due.