543 CS Computer Information Systems Design Spring 2008
Instructor: Office: Office Hours: Phone: Email: Text: Dr. Huanjing Wang TCCW 112 MWF 8:00-9:00, 10:10-11:30, other times by e_mail appointment 270-745-2672 [e-mail] Database Management Systems (third edition) by Raghu Ramakrishnan and Johannes Gehrke, ISBN: 0-07-246563-8 http://www.wku.edu/~huanjing.wang/cs543 This course will focus on application development, indexing, transaction management, parallel and distributed databases, data warehousing and decision support. CS443, CS443G or equivalent
Course Website: Course Description:
Pre-requests:
Grade Computation: Homework Midterm Exam (2) Final Exam Programming Assignment Attendance Grading Policy:
30% 30% 20% 15% 5% B: 80-89 C: 70-79 D: 60-69 F: <60
A: 90-100
Attendance Policies: Class attendance counts for 5% of the grade, according to the following chart. #of absences attendance grade 1 5 2 4 3 3 4 1 5 or more 0 Two latenesss will be considered as one absence Homework Policies: Each student should work on the homework assignment independently, and submitted on time. No late homework will be accepted. Exam Policies: There will be two midterm exams and one final comprehensive exam. 1
To prepare for each exam, review the class notes, homework problems and solutions, and read the corresponding chapters of the book. All exams will be closed book, closed notes and no calculators. Cheating will not be tolerated. For exams, you should use only the information in your own brain. The use of any other information (e.g., reading the paper of the person next to you, accessing information stored in your electronic telephone directory wristwatch) is considered cheating. If one cheats on an exam, ones grade for that exam is zero. Other disciplinary action also may be taken. There will be no make-up examinations. A missed exam earns a score of 0. If an emergency arises on the day of exam, and the instructor deems that the absence is excused, then the weight of other exams may be increased to replace it.
Programming Assignment Policies: Every program must be turned in to pass the class. The success of a turn-in will be determined the by instructor. Examples of unsuccessful program turn-ins include programs that do not compile, programs that do not implement the assignments function (such as turning in program 4 as if it were program 5), or programs that segmentation fault every time they execute. All assignments are due at the date assigned during class. More than enough time is given to complete assignments, and therefore exceptions will not be made for any reason, including lab down-time or assignments due in other classes on the same due date. No late programming assignment will be accepted. Cheating Policies: Academic dishonesty will not be tolerated. All programming assignments will be checked for plagiarism using the MOSS system. MOSS information is available at http://www.cs.berkeley.edu/~aiken/moss.html. Copying from the internet and any other sources (such as senior students or classmates, etc.) is cheating Plagiarism and cheating will result in a zero for the course and appropriate actions will be taken. Office Etiquette: If the instructors office door is open (even just a crack), that means that the instructor is willing to take questions and help students. If the instructors door is closed, that means the instructor is busy. Do not knock on a close door unless you have an appointment. You can make an appointment with the instructor, at her direction that is outside her office hours. Do not use office hours or appointment as an opportunity to demo your assignment, which is akin to asking your instructor to grade your assignment twice. Course Topics: Database foundations Chapter 8: Overview of storage and indexing 2
Chapter 9: Storing data: disks and files Chapter 10: Tree-structured indexing Chapter 11: Hash-based indexing Chapter 16: Overview of transaction management Chapter 17: Concurrency control Chapter 18: Crash recovery Chapter 6: Database application development Chapter 7: Internet applications Chapter 22: Parallel and distributed databases Chapter 25: Data warehousing and decision support
Student with disabilities should contact the office for Student Disability Services, during the first week of the semester for special assistance.
3