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.

INTRODUCTION

• Elmasri & Navathe, Ch. 1

• Outline for 1/16/07 - 1/23/07
• DB Concepts diagrams

Thursday, 1/18/07: Database basics 2

• Elmasri & Navathe, Ch. 12.1

Tuesday 1/23/07: Database concepts

• Elmasri & Navathe, Ch. 2

SEMANTIC MODELING

• Elmasri & Navathe, Ch. 3.1 - 3.4

• Outline for 1/25/07 - 2/6/07.
• Slides for ER

Tuesday 1/30/07: Entity-relationship model basics 2

• Elmasri & Navathe, Ch. 3.5-3.9

Thursday, 2/1/07: ER and Visio exercise

• Bring your laptop to class
• ER-Visio Exercise

Tuesday, 2/6/07: Entity-relationship basics 3

• Assign A-ER, due Thursday, 2/15/07.
• Solution for Acme Tours exercise.

Thursday, 2/8/07: Start Database 1 in class

• Read Database 1 specifications and review the ER diagram before class.
• Bring your laptop to class.

• Assign Database 1, due Thursday, 2/22/07.

RELATIONAL MODEL

• Elmasri & Navathe, Ch. 5

• Outline for 2/13/07 - 2/27/07
• Slides for relational model

Thursday, 2/15/07: Relational model basics 2

• A-ER due.

Tuesday, 2/20/07: No class today
Please attend A Legacy of Sharing Knowledge events instead.

Thursday, 2/22/07: ER to DB mapping 1

• Elmasri & Navathe, Ch. 7.1

• A-ER solution
• DB 1 due.
• ER Makeup Assignment, due Thursday, 3/8/07

Tuesday, 2/27/07: ER to DB mapping 2

• ER solution
• Schema solution
• Assign Database 2, due Thursday 3/22/07.

Thursday, 3/1/07: Extended ER basics

• Elmasri & Navathe, Ch. 4

• Outline for 3/1/07 - 3/8/07.
• Slides for EER
• Assign A-SCHEMA, due Tuesday, 3/20/07.

Tuesday, 3/6/07: EER to DB mapping

• Elmasri & Navathe, Ch. 7.2 & 7.3

• More slides for EERs.

Thursday, 3/8/07: Mapping summary

• Solution for puzzle EER.
• Schema for puzzle EER

Tuesday, 3/13/07 & Thursday 3/15/07: Spring Break, no class

Tuesday, 3/20/07: Relational Algebra 1

• Elmasri & Navathe, Ch. 6.1 - 6.5

• A-SCHEMA due.
• Assign Capstone Project. Specifications and ER due Tuesday, 4/3/07. Database due Tuesday, 5/1/07, 4:00 p.m.

• Outline for 3/20/07 & 3/22/07.
• Slides for relational algebra.

Thursday, 3/22/07: Relational Algebra 2

• Database 2 due.
• Assign A-RASQL, due Tuesday, 4/10/07.
• Assign Database 3, due Thursday, 4/5/07.
• More RA exercises and answers (puzzle)

SQL

• Elmasri & Navathe, Ch. 8.1 - 8.3

• Outline for 3/27/07 - 4/3/07.
• Slides for SQL
• Company DDL
• DDL exercise

Thursday, 3/29/07: SQL DML 1

• Elmasri & Navathe, Ch. 8.4-8.7

Tuesday, 4/3/07: SQL DML 2

• Project ER and specifications due.
• DML exercise
• More SQL DML exercises (puzzle)

NORMALIZATION AND DATA QUALITY

• Elmasri & Navathe, Ch. 12.2
• Elmasri & Navathe, Ch. 10.1 & 10.2

• Database 3 due.
• Outline for 4/5/07 - 4/12/07.
• Slides for today and next Thursday.

Tuesday, 4/10/07: Normalization 1

• REMINDER No class meeting today.
  I suggest you listen to/view the slides and narration in groups, so you can discuss the exercises.
• ANOTHER REMINDER You may turn in A-RASQL today, or on Thursday, 4/12/07.

• Elmasri & Navathe, Ch. 10.3 - 10.6

• A-RASQL due today.

Thursday, 4/12/07: Normalization 2

• Assign A-NORM, due Tuesday, 4/24/07
• Normalization exercise 1 slides
• Normalization exercise 2 slides

Tuesday, 4/17/07: Data quality

• 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]

• Outline for 4/17/07 - 4/24/07
• Slides for data quality and reverse engineering.

Thursday, 4/19/07: Reverse engineering 1

• 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]

Tuesday, 4/24/07:Reverse engineering 2

• A-NORM due.

EMERGING TECHNOLOGIES

• Elmasri & Navathe, Ch. 27.1
• Elmasri & Navathe, Ch. 28.1 - 28.2

Tuesday, 5/1/07, 4:00 p.m: Capstone Project due.