MGT230 COURSE SYLLABUS
Summer, 2004

Instructor: Dr. Robert Chi

Course Name: Database for Management
Course Number: MGT230
Classroom:    ANDHL 118

Office:
Telephone: 
Email: rchi@csulb.edu
Office Hours:  M, W 6:00pm -7:00pm

Course Objective and Format:

This course is about the principles and abstractions of data management that underlie organizations and institutions in the post-Industrial “Information Age.” This is NOT a course about the impacts of information technologies on the evolution of organizations and institutions. There are excellent courses in AGSM for that. Except peripherally, this is NOT a course about how to implement database mechanisms. Try the excellent database program in CS.

This course focuses on the abstractions and principles used in managing and maintaining data. In particular, we will ask how to organize and manage your available information assets to address specific strategic objectives. This includes conceptual modeling (UML/ER), normalization, queries and DB administration. We also cover some of the cutting-edge technologies surrounding database systems to keep abreast of the changing industry. Upon completion of the course, students should

Ÿ Be knowledgeable with the fundamentals and application issues of database systems

Ÿ Be skillful with conceptual database modeling, database normalization and querying using SQL

Ÿ Be able to build management databases for Windows using Microsoft Access

Ÿ Get to know the state-of-the-art technologies surrounding databases systems

Text Book:

Database Management Systems

Designing and Building Business Applications

3rd Edition

Gerald V. Post

Irwin McGraw Hill Publishers, 2005

ISBN 0072919191

Exam/Grading Policy:

Individual HW 1                        10%
Individual HW 2                                        10%
Individual HW 3                                        10%

Participation 10%
Final Exam         20%
Group Final Project                              40%
===================================
Total                                        100%

Attendance policy. It is extremely important to attend all classes. Participation is essential.

Class Site

Much of the class information can be found at my web site www.csulb.edu/~rchi which includes the class schedule, assignments, the lecture slides and class news.

Homework

There will be three homework throughout the course. All homework and answers will be posted on the website. Individual homework must be completed individually. Final group assignment should be done in a group of no more than 4 members. Do submit your homework on time. Since the work is assigned well ahead, no excuses will be accepted. However, I ill accept late homework, with a late penalty of 10% per day until answers are posted.

Term Project

The term project is the “cap-stone” for the course. The database you will design should be viewed as a prototype database application. As such you are not expected to develop a fully functional system that can be installed “as is” at some business, company or organization. However, it is intended to provide you with valuable hands on experience in designing and implementing a real world DBMS application, and as such, your project should apply most of the issues and concepts covered during the quarter. The projects can be done individually or in groups of 2.

Class Schedule

Date	Day	Topic	Assignments
07/26	M	Course overview, Chapter 1	HW1 assigned
07/28	W	Chapter 2
08/2	M	Chapter 3	HW1 due, HW2 assigned
08/4	W	Chapter 4
08/9	M	Chapter 5	HW2 due, HW3 assigned
08/11	W	Chapter 6
08/16	M	Chapter 7	HW3 due
08/18	W	Chapter 8
08/23	M	Final Exam
08/25	W	Final project presentation