CIS543 Database Systems

 

Instructor: Dr. M. Wang

Office: ST #609

Office Phone: (323) 343-2983

Direct Phone: (323) 343-2958 (Use for office hours)

Office Hours:  MW 4:30 - 6:00 p.m.

E-mail: ming.wang@calstatela.edu

Course Web site: http://webct6.calstatela.edu/

Home Page: http://www.calstatela.edu/faculty/mwang3/

 

Course Description:
The course is designed for database design and implementation, comparison of relational database and object-relational data modeling, and database administration using Oracle technology. The course also introduces data warehousing and data mining using ERP technology. The course project reflects the real-world database problem-solving.

Software Tools: Oracle Server Software, Access/Oracle Development Suite, SAP and Visio.

Textbook:

Title: Modern Database Management, 9/E

Authors: Jeffrey A. Hoffer, Mary Prescott and Heikki Topi

Publisher: Prentice Hall

ISBN: 0-13-600430-X

 

Textbook Web Site: http://wps.prenhall.com/bp_hoffer_mdm_9/85/21941/5616992.cw/index.html

 

Objectives:
After successful completion of this course the student should be able to:

    Design and develop relational database systems.

    Query relational databases using Oracle SQL

    Conduct normalization and de-normalization

    Design and develop object-relational database systems using UML

    Compare relational database and object-relational database

    Develop database applications (forms and reports)

    Understand data and database administration

    Understand data warehouse and data mining

 

Instructional Procedures:
Classroom activities will consist of lecture, example demonstration and in-class exercises with valuable hands-on experience. The contents taught in class will be followed by homework assignment, projects and exams.

 

Assessment of Academic Achievement:
Assignments (24%)
Mid-terms (28%)
Project Part I: Database Design and Implementation (6%)
Project Part II: Database Application Programming (6%)
Final Exam (36%)

The final grade will be determined on the above performance.
Grading scale: A 90-100%, B 80-89%, C 70-79%, D 60-69%, F 0-59%

Class Policies:

Projects and Assignments: Students are expected to accomplish their projects and assignments individually and independently. Students are encouraged to discuss any questions in class, in office hours or via emails. Requests for debugging your program via email will not be responded. Students are expected to use the equipment of computer labs at CSULA for assignments and projects.

To receive full credit, a project or an assignment must be completed on time on the date due. Work load and other course load will not be excused. Late penalties will be assessed as follows:

Up to 24 hours after time due --- 25% penalty
Over 24 hours after time due --- 100% penalty

Tests: Exams are cumulative in nature for this technical course. Absence from an exam is excused only in a personal medical emergency.

Responsibility: Class attendance is required. Important work will be done in class. Regular attendance will improve your performance. Students will be responsible for all course assignments, lecture notes, handouts and announcements via postings to the class web site. If class is missed, it is the student's responsibility to drop the assignment due at the IS Department's office with the time stamped. Make sure you receive a receipt acknowledgement if you have to e-mail a softcopy assignment to the instructor in a specially permitted situation.

 

Honor code:  California State University, Los Angeles is committed to intellectual integrity and considers academic dishonesty a very serious offense. Cheating (i.e. substantial help given or received by a student on a homework assignment or test, regardless who is at fault) will be punished and may result in an automatic F.

 

Class conduct:  Common courtesy and respect of all people and property expected. Punctual arrival of the class required. NO cell phones or beepers in class.