Sanjay Goel, School of Business, UAlbany

PH: (518) 442-4925
FX: (518) 442-4975
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".

MSI 520: Database Design and Application Development

Download syllabus: msi520syllabus.pdf

Instructor Information

Sanjay Goel

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

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	BA 233
3	10/24	Microsoft Access	Design (Exercise 1-2)	BA 222
4	10/27	Database Normalization	Chapt. 7	233
5	10/29	Database Normalization	Chapt. 7	233
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	BA 233
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