MIS 150 - Database Management Systems for Business

MIS 150Dr. Tsai

Fall 2007Dr. Tsai

CALIFORNIASTATEUNIVERSITY, SACRAMENTO

College of Business Administration

MIS 150 - Database Management Systems for Business

COURSE OUTLINE

INSTRUCTOR:Dr. Nancy Tsai

OFFICE:TAH-2090

OFFICE PHONE:(916) 278-7121

OFFICE HOURS:Tuesday and Thursday, 2:45 – 4:00 p.m.; or by appointment

FAX:(916) 278-6489

E-MAIL:

WEB:

REQUIRED TEXTS

(C)Connolly, T. and C. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, 4th edition, Addison Wesley, 2005.

(M)Morrison, J., M. Morrison and R. Conrad, Guide to Oracle10g, Course Technology, 2006.

COURSE OBJECTIVES

The course is designed to provide the student with the essential knowledge needed to analyze, evaluate, design, implement, and administer the business database. The topics include:

1. The terminology and fundamental concepts associated with the relational and object-oriented database processing;
2. The design and implementation of a relational database; and
3. The application of SQL using ORACLE.

COURSE METHODOLOGY

Lecture will be presented to supplement the subject matter covered in the text. The student will be expected to complete the reading assignments prior to the class in order to have a better understanding of the important concepts and materials covered in each chapter. Unannounced quizzes will be given to the student during the semester.

In order to enable the student to gain a greater experience for the current database processing, each student will be required to participate in a group project that includes the design of a relational database system and generating SQL reports using ORACLE.

The student will be allowed to form his/her own project group of a maximum four students per group. The group roster (group leader, group member name, phone number, and e-mail address) is due on Tuesday (September 18, 2007). Group leader should send an email with a title of MIS 150-1 or MIS 150 to or the future class message communication. Every student in the group has an equal responsibility to complete the entire project.

COURSE GRADE

The course grade will be based upon the following components weighted as indicated:

1. Three exams (25% each)75%

2.Group project15%

3.Individual homework assignments 5%

4.Quizzes 5%

The student will be expected to take the exam when scheduled. The student missing an exam will receive a zero (0) for that exam unless a valid reason for missing the exam can be verified. The homework assignments and project are due at the beginning of the class period of the due date.

It is expected that all work for this course will be presented in a very neat and professional manner. The style, spelling, grammar, and presentation are components of all grading. The student will be expected to turn in each homework assignment and project on time. No late, handwritten, e-mailed, or faxed homework assignment and project will be accepted!!

There will be a group member evaluation within each group at the end of the semester. Every group member will have the opportunity to evaluate the contribution of his/her group members using a 0% to 100% scale. The average group member evaluation score will be the weight to determine the score of each member's final points on the group project for the semester.

The final grade can only be changed if a posting or calculating error has occurred. No extra credit assignment will be made available at the end of the semester to bolster a grade for any student.

The incomplete grade “I”, unauthorized withdrawal grade “U”, and failing grade “F” will be issued in accordance to the College of Business Administration policy.

CLASSROOM REGULATIONS

The student must observe the following classroom regulations to have a proper learning environment for the entire class.

1. Turning off the cellular phone and pager

2. No chatting during the lecture

3. Absolutely quiet, no sleeping, no eating and drinking during the lecture

A student violates any of the above regulations will be asked to leave the classroom voluntarily to respect the right of other classmates.

ACADEMIC HONESTY

Except for the group project, all examinations and assignments in this class are to be done individually. Any violation or perceived violation of this policy will result in zero (0) credit for the examination and assignment for each of the parties involved. Prosecution of any such violation will be rigorously pursued through the appropriate channels (e.g., Associate Dean of Student Affairs).

READING ASSIGNMENTS

TENTATIVE READING ASSIGNMENTS

The course schedule and others may change at any time. Announcement will be made in the class about any change, and it is the responsibility of the student to keep up with and to know about any such changes.

1