MSI 520: Database Design and Application Development

Fall 2002 Syllabus

Instructor Information

Sanjay Goel picture

Sanjay Goel

Office: BA 310b
Hours: Mon. 1-2:30PM & by appt.
PH: (518) 442-4925
FX (518) 442-2568
Email: [email protected]

Class Information

Time (4754): MWF 10:10-11:05pm
Time (4753): MWF 11:15-12:10pm
Location: BA 233/BA222
Dates: October 14 - December 5
Available Lab(s): MIS Lab, HRIS Lab

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. Theory classes will be in BA233 and the Access will be in BA222 which is a computer lab.

Text & Reference Books

Text: Mannino, Database: Application Development & Design (with Access 2002 CD)

Reference: Steven Roman, Access Database: Design & Programming, 2nd Edition

Grading

Homework: 25%

Project: 25%

Exam: 50%

Course Schedule

Lec. Date Topics Readings Room
1 10/14 Introduction to Databases Chapt. 1 BA 227
2 10/16 Relational Database Design Chapt. 2
3 10/21 Data Modeling: ER Diagrams Chapt. 7
4 10/23 Database Normalization Chapt. 8
5 10/28
6 10/30 SQL - Data Definition Language Chapt. 3
7 11/4 Introduction to Access - Create Database Notes BA 232/234
8 11/6 SQL - Data Manipulation Language Chapt. 3 BA 227
9 11/11 MS Access - QBE Notes BA 232/234
10 11/13 SQL - Advanced Queries Chapt. 4 BA 227
11 11/18 MS Access - Forms and Reports Notes BA 232/234
12 11/20 Database Admininstration Chapt. 12 BA 227
13 11/25 Data Warehousing - Denormalization Chapt. 14
14 12/2 Semi-Structured Data (XML) Notes
15 12/4 Exam All

Download syllabus: msi520syllabus.pdf