INLS 523_002 Spring 2009 Schedule

Schedule

Introduction to Database INLS 523-002, Spring 2009

Introduction / Semantic Modeling / Relational Model /
SQL / Normalization and Data Quality

Notes:
This tentative schedule lists the assignments and readings for each of the topics we'll cover. Other readings or assignments may be assigned as appropriate.

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, see Off-Campus Access for more information.

INTRODUCTION

Tuesday, 1/13/09: Introduction - business

Assign Start-up Instructions

SEMANTIC MODELING

Thursday, 1/15/09: Entity-relationship model basics 1

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
Slides: Entity Relationship Models
Company ER
Assign ER-Visio Tutorials, complete before Thursday, 1/22/09

Tuesday 1/20/09: 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
Assign Access Tutorials, complete before Thursday, 1/29/09

Thursday, 1/22/09: ER basics 3: DB1 ER Workshop

Start DB1 ER in class, due Thursday, 1/29/09
Bring your computers

Tuesday, 1/27/09: ER basics 4

Assign ER Model assignment, due Thursday, 2/5/09
New dates! Assigned Thursday 1/27/09, due Tuesday 2/17/09

Thursday, 1/29/09: DB1 DB Workshop

Start DB1 DB in class, due Thursday, 2/12/09.
Bring your computers
DB1 ER due.
Assign ER Model assignment, due Tuesday, 2/17/09. New dates!

Tuesday, 2/3/09: Continue ER diagrams; DB Basics

Elmasri & Navathe, Ch. 1, Databases and Database Users
Elmasri & Navathe, Ch. 12.1, The Role of Information Systems in Organizations
Elmasri & Navathe, Ch. 2, Database System Concepts and Architecture
ACME tour ER
Slides: ER Relationships
Slides: DB Concepts

RELATIONAL MODEL

Thursday, 2/5/09: Relational model basics 1

Elmasri & Navathe, Ch. 5, The Relational Data Model and Relational Database Constraints
Radio show ER
Slides: Relational Model Basics

Tuesday, 2/10/09: Relational model basics 2

Thursday, 2/12/09: ER to DB mapping 1

Elmasri & Navathe, Ch. 7.1, Relational Database Design Using ER-to-Relational Mapping
Slides: ER-DB Mapping
Slides: ACME tour ER
Slides: ACME schema
DB1 DB due.
Assign Database 2, Part 1, due Thursday, 2/26/09

Tuesday, 2/17/09: ER to DB mapping 2

ER assignment due.

New date!

Radio Show ER

Thursday, 2/19/09: Extended ER basics

Elmasri & Navathe, Ch. 4, Enhanced Entity-Relationship and UML Modeling
Slides: Ternary relationships
Slides: EER
Assign Capstone project Part 1, due Thursday,3/19/09.

Tuesday, 2/24/09: EER to DB mapping

Elmasri & Navathe, Ch. 7.2 & 7.3, Mapping EER Model Constructs to Relations; Summary
Slides: EER-DB Mapping
ER assignment solution
Radio Show EER
Radio Show EER schema
Assign Schema assignment, due Thursday, 3/5/09.

RELATIONAL ALGEBRA AND SQL

Thursday, 2/26/09: 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
Slides: Relational algebra
Database 2, Part 1 not due. New due date Tuesday 3/3/09.
Assign Database 2, Part 2, due Thursday, 3/26/09.

Tuesday, 3/3/09: Relational Algebra 2

Database 2, Part 1 due. ( New date!)

Thursday, 3/5/09: Relational Algebra 3

Schema assignment due.
Assign SQL-RA assignment, due Thursday, 4/9/09.
ACME relational algebra exercises
Radio show puzzle relational algebra exercises

Tuesday, 3/10/09 & Thursday, 3/12/09: Spring Break, no class

Tuesday, 3/17/09: 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
Museum schemas
Company DDL

Thursday, 3/19/09: SQL DML 1

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
Slides: SQL DML
Capstone Project Part 1 due.
Assign Capstone Project Part 2, which should be completed by Friday, 4/3/09.
Assign Capstone Project Part 3, due Friday, 5/1/09, 5:00 p.m.

Tuesday, 3/24/09: SQL DML 2

Thursday, 3/26/09: SQL DML 3

Database 2, Part 2 due.

Tuesday, 3/31/09: SQL DML 4

NORMALIZATION AND DATA QUALITY

Thursday, 4/2/09: Good Design, Functional Dependencies

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
Slides: Design and Functional Dependencies
Bad ACME tour

Tuesday, 4/7/09: 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 alpha 1
Normalization exercise 1 solution

Thursday, 4/9/09: Normalization 2

Normalization exercise 2, alpha 2
Normalization exercise part 3, order example
SQL-RA assignment due.

Tuesday, 4/14/09: Normalization 3

Assign Normalization Assignment, due Thursday, 4/23/09.
Normalization exercise part 4

Thursday, 4/16/09: 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]
Slides: Data quality
Slides: Reverse Engineering
TSC exercise

Tuesday, 4/21/09: Reverse engineering 2

Thursday, 4/23/09: Wrap-up

Normalization assignment due.

Friday, 5/1/09, 5:00 p.m. Capstone Project Part 3 due.

This page was last modified on January 10, 2009 by Stephanie W. Haas. Address questions and comments about this page to Stephanie W. Haas at shaas at email dot unc dot edu
© Stephanie W. Haas, All rights reserved.