CS 462/562: Database Systems I

Syllabus for Spring, 2009

Call Numbers: 01389/01399
Professor: Cindy Marling
Office: Stocker 321D, Phone: 593-1246, Email: marling@ohio.edu
Office Hours: Tuesdays and Thursdays, from 9:00 to 11:00 AM; or by appointment
Class Time: Mondays, Tuesdays, Thursdays and Fridays, from 1:10 to 2:00 PM, in Stocker 102
Prerequisite: CS 361/561N Data Structures
Textbooks: Fundamentals of Database Systems, fifth edition
Ramez Elmasri and Shamkant Navathe, Addison-Wesley, 2006
Oracle 10g Programming: A Primer
Rajshekhar Sunderraman, Addison-Wesley, 2007
Home Page: The home page for CS 462/562 on the World Wide Web is:
http://ace.cs.ohiou.edu/~marling/cs462_562/cs462_562.html
Be sure to check here for important course information on a regular basis.
Overview: This course presents an introduction to the theory and practice of database systems. A database system consists of a collection of interrelated data (the database) and a set of programs to access that data. Database systems are used extensively for scientific, engineering, industrial, governmental, financial, and educational applications. In this course, we will study fundamental database concepts, relational database design, query languages, and database system implementation. While most topics are independent of specific implementation tools, students will use Oracle, SQL, and JDBC for CS 462/562 implementations.
Outcomes: Each student will: learn the mathematical and theoretical underpinnings of database systems; apply this knowledge to the design and implementation of a working database system; use appropriate techniques, skills, and tools for this design and implementation; communicate effectively in describing, documenting, and demonstrating this system; and be exposed to contemporary issues in database systems research.
Grading for
CS 462:
Assignments (20%), Project (30%)
Midterm Exam (20%), Final Exam (30%)
Grading for
CS 562:
Assignments (20%), Advanced Assignment (10%), Project (20%)
Midterm Exam (20%), Final Exam (30%)
Attendance
Policy:
Attendance will not be taken. It is assumed that students will miss class only for good cause. Students are responsible for all material presented in class.
Academic
Dishonesty
Policy:
All work must be the student's own. All external references used in reports must be properly cited. No credit will be given for duplicate or plagiarized work. Stronger measures, within the guidelines of the Student Handbook, may be taken when conditions warrant. The OU Student Code of Conduct Policy is available online at http://www.ohio.edu/judiciaries/conduct.cfm.
Other Policies: Be sure to notify the professor of any midterm exam conflicts or other extenuating circumstances in advance. No late assignments will be accepted without prior approval. No missed exams will be made up without prior approval.
Final Exam: Thursday, June 11, from 12:20 to 2:20 PM