Sanjay Goel, School of Business, UAlbany

PH: (518) 442-4925
FX: (518) 442-2568
Email: goel@albany.edu

Business Administration 310b
1400 Washington Ave.
Albany, NY 12222

Warning! The navigation menu needs JavaScript to work.

On IE, click on the yellow bar and select "Allow Blocked Content". And then, select Tools --> Internet Options, click the Advanced tab, and check "Allow active content to run in files on my computer" under Security.

For Mozilla Firefox, click on Tools --> Options --> Content --> and check the enable JavaScript box.

If using the NoScript add-on, click on the icon at the bottom of the browser and select "Allow albany.edu".

ITM 520: Database Management

Download Fall 2004 syllabus: msi520syllabus.pdf

Instructor Information

Sanjay Goel

Office: BA 310b
Hours: Mon. 12:30-2PM & by appt.
PH: (518) 442-4925
FX (518) 442-2568
Email: goel@albany.edu

Class Information

Time: 9:00-10:20am / 10:30-11:50pm
Location: BA 227
Dates: October 6 - November 22, 2004
Credit(s): 1
Call #: 4407 / 4408
Available Lab(s): BA222

Course Overview

This is an introductory course in database modeling, design and implementation of business applications. It teaches the basic principles of relational database theory and use of query languages. The students learn to write queries in SQL and design a database using Microsoft Access. The role of database systems in the management of information and procedures for modeling the data resource to support managerial/executive needs are presented in the course.

Assignments

Assignment given in any week is due at the beginning of the class in the next week. There will be a penalty of 10% per day for late assignments unless there is a very pressing reason for the delay. Please work individually on all assignments. Stop by my office if you have difficulty in understanding the assignment or the course material related to the assignment.

Project

Students will get one database project that they need to complete by the end of the class.

Text & Reference Books

Text: David M. Kroenke, Database Concepts, 2nd edition ISBN: 0131451413

Grading

Homework: 25%

Project: 35%

Exam: 50%

Course Schedule

No.	Date	Topics
1	October 6	Introduction / Relational DB Design
2	October 11	Data Modeling: ER Diagrams
3	October 13	Microsoft Access
4	October 18	Database Normalization
5	October 20	Database Normalization cont'd.
6	October 25	SQL - Data Definition Language
7	October 27	Microsoft Access
8	November 1	SQL - Data Manipulation Language
9	November 3	Microsoft Access
10	November 8	SQL - Advanced Queries
11	November 10	MS Access
12	November 15	Guest Lecture / Data Warehousing (not on exam)
13	November 17	Guest Lecture / Data Mining (not on exam)
14	November 22	Exam