MSI 520: Database Design and Application Development

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 17 - November 24
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/20 Introduction / Relational DB Design Chapt. 1 BA 233
2 10/22 Data Modeling: ER Diagrams Chapt. 2
3 10/24 Microsoft Access Design (Exercise 1-2) BA 222
4 10/27 Database Normalization Chapt. 7 233
5 10/29
6 10/31 Microsoft Access Forms (Exercise 4 & 5) BA 222
7 11/3 SQL - Data Definition Language Chapt. 3 BA 233
11/5 No Class
8 11/7 Microsoft Access SQL Queries BA 222
9 11/10 SQL - Data Manipulation Language Chapt. 3 BA 233
10 11/12 SQL - Advanced Queries Chapt. 4
11 11/14 MS Access Reports (Exercise 6) BA 222
12 11/17 Data Warehousing/Mining Chapt. 16 BA 233
13 11/19 Database Admin. / XML Chapt. 14
14 11/21 Open
15 11/24 Exam BA 233/222

Download syllabus: msi520syllabus.pdf