College of Saint Rose
CIS 321 Database Management

 

Instructor : 

John Avitabile

Office : 

Albertus Hall 400-4

Phone : 

458-5317

e-mail : 

avitabij@strose.edu

class site: 

http://academic2.strose.edu/Math_And_Science/avitabij/cis321fall09/index.htm

Office hours : 

Tuesday 1-2:30 pm;  Thursday 1-2:30 pm; or by arrangement

Text : 

(optional) Database Design, Application Development, and Administration; Mannino; 4th Edition; CafeScribe; 2008

(required) New Perspectives on Microsoft Office Access 2007 Comprehensive; Adamski and Finnegan; Thompson; 2008

Course Description:

In this course we will study database management systems. We will learn how to create sound relational databases. We will also look at the network and hierarchical database models. We will examine XML. We will study the query languages SQL and QBE. We will implement databases using Access - we will create, query, modify and write applications for Access databases. We will program using macros. We will study issues in database management systems, including security, database administration, physical design, object-oriented and distributed databases. We will learn how to create XML files; verify XML files; and query XML files.

There will be some written assignments and some assignments using Access, ER Assistant, and XML Spy. On average, plan on spending at least 8 hours per week on these assignments. There may be some class time when you can work on assignments.

Access 2007 is in the computer labs, and that’s what we’ll use. You can get a free copy of it from me.

A note on the optional  Mannino textbook: It’s an ebook that costs $40. You can buy it at http://www.cafescribe.com/. You can also buy a 3rd edition copy used if you like.

Grading Policy:

Exam 1                  25%
Exam 2                  25%
Exam 3                  25%
Homework           25%
 

Homework assignments must be turned in on time to receive full credit. Assignments that are no more than 1 week late get a 10% grade deduction. Assignments more than one week late get a 50% grade deduction.

All assignments must be handed in by the last class.

If you must miss an exam for any reason, you must notify me by phone or e-mail before the next class meeting. Otherwise, you'll get a 0 on the exam.

I will follow the College’s policies on Plagiarism as described in the Catalog.

Week of

 

August 31

Introduction to Database Management (Chapter 1)
Introduction to Database Development (Chapter 2)

September 7

Relational Data Model (Chapter 3)
Tutorial 1

September 14

Tutorial 2
SQL (Chapter 4)

September 21

SQL (Chapter 4)

September 28

SQL (Chapter 4)
Tutorial 3

October 5

Understanding Entity Relationship Diagrams (Chapter 5)
ER Assistant
Tutorial 4

October 12

Understanding Entity Relationship Diagrams (Chapter 5)
Exam 1 - Thursday, October 15

October 19

Developing Data Models (Chapter 6)
Tutorial 5

October 26

Normalization (Chapter 7)
Tutorial 6

November 2

Advanced Query Formation (Chapter 9)
Tutorial 7

November 9

Exam 2 - Thursday, November 12

November 16

Tutorial 9, 10
XML Introduction

November 23

XML Validation

November 30

XML Validation

December 7

XML Queries

December 14

Exam 3 – Tuesday, December 15