Database

MIS 3353 Fall 2002


General

Syllabus, Fall 2002

Tentative Schedule, Fall 2002

Homework Due

Please be sure that I have a form and a resume from you.

Due October 31

mdb Classes Database

doc Supplemental Exercises: Unary Relations, Group By and Sub-Class

SQL

Workbook (This is slightly different from the one at Crimson and Cream)

SQL Assignment. Due Thursday, September 12

SQL Tutorial using MS Access

MS Access Database with tables for the tutorial

Solved practice problems

Mini Test 3

Mini Test 4

Mini Test 5

Mini Test 6

Mini Test 7

Mini Test 8

Normalization Exercises

Normalization Exercises - Key

Quiz2 with answers

Introduction

Tuesday, 8/27/02

ppt Introduction

ppt Data Modeling

Thursday, 8/29/02

ppt Chapter 2: The Database Development Process

Two copies of a resume due.

****

Data Modeling

Tuesday, 9/03/02

Thursday, 9/05/02

ppt Data Modeling in context

ppt Classes of ER Models (Enterprise/Conceptual/Relational)

doc NewAge Tax: Enterprise exercise.

ppt UR Moving Company: Enterprise exercise.

****

Tuesday, 9/10/02

ppt The Process of ER Modeling

ppt MIS Banquet Next Wednesday

Thursday, 9/12/02

SQL Exercises due.

****

Tuesday, 9/17/02

Thursday, 9/19/02

****

Tuesday, 9/24/02

Thursday, 9/26/02

Mini 4

Answers to the ER problems from the book are available in Classfiles under MIS 3353 - Schwarzkopf

****

Tuesday, 10/01/02

Thursday, 10/03/02

Quiz 1: SQL, ER modeling and the contents of book chapters 1 - 5.

doc ER Diagram and SQL answers.

****

Tuesday, 10/08/02

Review Quiz

Thursday, 10/10/02

Order Entry Models and Group By SQL statements

****

Tuesday, 10/15/02

Component Part Models, Sub-Class and Alias statements in SQL

Thursday, 10/17/02

Introduction to Normalization

ppt Normalization

****

Tuesday, 10/22/02

mdb Classes Database

doc Supplemental Exercises: Unary Relations, Group By and Sub-Class

Thursday, 10/24/02

Mini 4

****

Tuesday, 10/29/02

Thursday, 10/31/02

Mini 5

****

Tuesday, 11/05/02

ppt File Organization

Thursday, 11/07/02

ppt Physical Design Concepts

Mini 6

****

Tuesday, 11/12/02

Thursday, 11/14/02

Mini 7

ppt Physical Design Review

****

Tuesday, 11/19/02

Thursday, 11/21/02

Quiz 2

****

Tuesday, 11/26/02

Thursday, 11/28/02

THANKSGIVING 4

****

Tuesday, 12/03/02

ppt Functions of a DBMS

Thursday, 12/05/02

Mini 8

****

Tuesday, 12/10/02

Thursday, 12/12/02

Last Day of Class

****

*************Old Schedule*******************

doc MS/SQL Server Login Instructions

doc SQL Instructions (using SQL Server)

doc SQL Query Assignment -- Due Friday, July 6

Tuesday, 7/03/01

Tuesday, 7/09/01

ppt E-R Modeling (7/09) (1st draft)

ppt E-R Modeling (7/09)

doc Data Modeling in context (7/09)

Thursday, 7/12/01

ppt Relational Databases (keys & foreign keys) (7/09)

Tuesday, 7/17/01

Later, 7/??/01

Physical Design

Physical Design

ppt Data Warehouse Design