ITM 520: Database Management
Instructor Information
 |
Sanjay GoelOffice: BA 310bHours: Mon. 12:30-2PM & by appt. PH: (518) 442-4925 FX (518) 442-2568 Email: [email protected] |
Class Information
Time: 9:00-10:20am / 10:30-11:50pmLocation: 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 | Readings | Practice Problems |
|---|---|---|---|---|
| 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 |
Download Fall 2004 syllabus: msi520syllabus.pdf