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.
Course Web site: http://webct6.calstatela.edu/
Home Page: http://www.calstatela.edu/faculty/mwang3/
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.
Title: Modern Database Management, 9/E
Authors: Jeffrey A. Hoffer, Mary Prescott and Heikki Topi
Publisher: Prentice Hall
Textbook Web Site: http://wps.prenhall.com/bp_hoffer_mdm_9/85/21941/5616992.cw/index.html
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
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.
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%
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.