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.