CPS 314 Syllabus

CPS 314—Database Management

Fall 2009

Dr. Close

ASSIGNMENTS

Rev. 10-Nov-2009

Instructions: This document is tentative. Students are responsible for checking my Web site for updates. Complete all assignments shown prior to that day’s lecture. Students are responsible for checking the Moodle for updates to this hand-out.

Lecture

Date

Topics

Readings and Assignments

Lecture 1

Aug. 24

Database History and Background

· N/A

Lecture 2

Aug. 26

Basic Database Concepts

· Read Pratt and Adamski (PA), Ch. 1 (“Introduction to Database Management”). Learn Key Terms.

Lecture 3

Aug. 28

Basic Database Concepts; Intro to DBMS software (MS Access 2007)

· PA, Ch. 1 continued. Do Review Questions, odds.

· Access 2007 Self-Guided Tutorial: Read and do Shelly, Cashman, Pratt, and Last (SCPL), Chapter 1 (“Creating and Using a Database”), JSP Recruiters

Lecture 4

Aug. 31

Basic Database Concepts; Intro to Access 2007 QBE

· PA, Ch. 1 continued.

· Access 2007 Self-Guided Tutorial: Do SCPL, In the Lab #2 (“Creating the Hockey Fan Zone Database”).

Lecture 5

Sept. 2

Basic Database Concepts; Access 2007 QBE

· PA, Ch. 1 continued. Do Review Questions, evens.

· Access 2007 Self-Guided Tutorial: Read and do SCPL, Chapter 2 (“Querying a Database”).

Lecture 6

Sept. 4

Basic Database Concepts

· PA, Ch. 1 continued.

Lecture 7

Sept. 9

Basic Database Concepts; Access 2007

· Access 2007 Self-Guided Tutorial: Do SCPL, In the Lab #2 (“Querying the Hockey Fan Zone Database”).

Lecture 8

Sept. 11

Access 2007 Maintenance

· Access 2007 Self-Guided Tutorial: Read and do SCPL, Chapter 3 (“Maintaining a Database”).

· Problem #1 Due: SCPL, Chapter 2, In the Lab #2 (“Querying the Hockey Fan Zone Database”). Further specifications will be presented in lecture.

Lecture 9

Sept. 14

Relational DBMS Model; Set Operations

· Read PA, Ch. 2 (“The Relational Model 1: Introduction, QBE, and Relational Algebra”). Learn Key Terms, do Review Questions, odds.

Lecture 10

Sept. 16

Relational DBMS Model; Set Operations

· PA, Ch. 2 continued. Do Review Questions, evens.

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 3, In the Lab #2 (“Maintaining the Hockey Fan Zone Database”).

Lecture 11

Sept. 18

Relational DBMS Model; Set Operations; Intro to SQL

· Access 2007 Self-Guided Tutorial: Do SCPL, SQL Feature (“SQL Feature: Using SQL”), p. AC 425 ff.

· Graded Homework #1 Due: Do PA Henry Books Case, pp. 66-67, #9, 11, 15, and 20. Your work must be typed.

Lecture 12

Sept. 21

SQL

· Read PA, Ch. 3 (“The Relational Model 2: SQL”). Learn Key Terms.

Lecture 13

Sept. 23

SQL

· PA, Ch. 3, continued. Do Review Questions, odds.

Lecture 14

Sept. 25

SQL

· PA, Ch. 3, continued.

· Access 2007 Self-Guided Tutorial: Do SCPL, Integration Feature (“Sharing Data among Applications”).

· Graded Homework #2 Due: PA, Ch. 3, p. 113, Review Questions 6 and 10. Explain in two or three sentences and illustrate your answer with a SQL example. Your work must be typed.

Lecture 15

Sept. 28

SQL

· PA, Ch. 3, continued. Do Review Questions, evens.

· Quiz 1

Lecture 16

Sept. 30

SQL; Views; Indexes

· Read PA, Ch. 4 (“The Relational Model 3: Advanced Topics”). Learn Key Terms.

Lecture 17

Oct. 2

Integrity Rules

· PA, Ch. 4, continued. Do Review Questions, odds.

· Problem #2 Due: PA Premiere Products Exercises, p. 113, Questions 5-7 and 13-15. All answers must be in syntactically correct ANSI SQL. Your work must be typed.

Lecture 18

Oct. 5

System Catalog; Triggers; Introduction to Normalization

· PA, Ch. 4, continued

· Read PA, Ch. 5 (“Database Design 1: Normalization”), pp. 150-167. Do Review Questions 1-7, p. 173.

Lecture 19

Oct. 7

Functional Dependence

· Read PA, Ch. 5, pp. 167-173. Do Review Questions 8-12, pp. 173-174.

Lecture 20

Oct. 9

Introduction to Normal Forms

· PA, Ch. 5 continued. Learn Key Terms.

· Graded Homework #3 Due: Do PA Premiere Products Exercises, p. 174, #2.

Lecture 21

Oct. 12

Normalization

· PA, Ch. 5 continued.

· Homework: Do PA Premiere Products Exercises, p. 174, #1; PA Alexamara Marina Group Case, p. 175, #2;.

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 4 (“Creating Reports and Forms”)

Lecture 22

Oct. 14

Normalization

· PA, Ch. 5 continued.

· Homework: Do PA Henry Books Case, p. 175, #2 and #4.

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 4, In the Lab #2 (“Presenting Data in the Hockey Fan Zone Database”).

Lecture 23

Oct. 16

Normalization

Introduction to Logical Design

· PA, Ch. 5 continued; Homework: Do PA Henry Books Case, p. 175, #1 and #3.

Lecture 24

Oct. 21

Logical Design Modeling, DBDL, IDEF1X E-R Diagrams

· Read PA, Ch. 6 (“Database Design 2: Design Method”), pp. 178-220. Learn Key Terms.

Lecture 25

Oct. 23

M-M Decomposition;

User Views and Physical Design

· PA, Ch. 6, continued

· Problem #3 Due: See hand-out for details.

Lecture 26

Oct. 26

Advanced Design;

Introduction to Personal Database Project

· PA, Ch. 6 continued. Do Review Questions, pp. 220-221, odds 1-17.

· Graded Homework #4 Due: p. 221, #14

Lecture 27

Oct. 28

Advanced Design

· PA, Ch. 6 continued. Do Review Questions, pp. 220-221, evens 2-18.

· Problem #4 Due: Do PA Henry Books Case, pp. 222, #1 and #2. Provide table abstracts and keys using the DBDL style presented in lecture and in the text. Work must be typed.

Lecture 28

Oct. 30

Advanced Design

· PA, Ch. 6 continued.

· Quiz 2

Lecture 29

Nov. 2

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 5 (“Multi-Table Forms”)

Lecture 30

Nov. 4

· Read PA, Ch. 7 (“DBMS Functions”), pp. 225-237.

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 5, In the Lab #2 (“Adding Fields and Creating Multi-Table Forms in the Hockey Fan Zone Database”).

Lecture 31

Nov. 6

· LECTURE CANCELLED FOR INAUGURATION

· PA, Ch. 7, pp. 237-244.

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 6 (“Using Macros, Switchboards, PivotTables, and PivotCharts”)

Lecture 32

Nov. 9

· PA, Ch. 7, pp. 244-257.

· Problem #5 Due: Do SCPL, Chapter 6, In the Lab #2 (“Creating Macros and a Switchboard for the Hockey Fan Zone Database”). POSTPONED to Nov. 11

· Access 2007 Self-Guided Tutorial: Do SCPL, Web Feature (“Sharing Access Data”), pp. AC 673 ff.

Lecture 33

Nov. 11

· PA, Ch. 7 continued.

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 7 (“Advanced Report and Form Techniques”)

· Graded Homework #5 Due: Submit typed table abstracts for your personal database project. Briefly describe at least two reports (other than straight table views) that you plan to produce. POSTPONED to Nov. 13

Lecture 34

Nov. 13

· PA, Ch. 7 continued.

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 7, In the Lab #2 (“Creating Reports for the Hockey Fan Zone Database”).

Lecture 35

Nov. 16

· PA, Ch. 7 continued.

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 8 (“Using Visual Basic for Applications (VBA) and Creating Multi-Page Forms”)

Lecture 36

Nov. 18

· PA, Ch. 7 continued; Read PA, Ch. 8 (“Database Administration”)

· Problem #6 Due: Do SCPL, Chapter 8, In the Lab #2 (“Applying Advanced Form Techniques to the Hockey Fan Zone Database”).

Lecture 37

Nov. 20

· PA, Ch. 8 continued.

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 9 (“Administering a Database System”)

· Quiz 3

Lecture 38

Nov. 23

· PA, Ch. 8 continued; Read PA, Ch. 9 (“Database Management Approaches”)

· Access 2007 Self-Guided Tutorial: Do SCPL, Chapter 9, In the Lab #2 (“Administering the Hockey Fan Zone Database”).

Lecture 39

Nov. 30

· PA, Ch. 9 continued.

Lecture 40

Dec. 2

· Final exam review.

· Personal Database Project Due. See hand-out for specifications.