CSE 670: INTRODUCTION TO DATABASE SYSTEMS

Database models; database organization, database design, integrity and security; database systems and their utilization. preq: 222 or 230 or 314 or 502; Math 366 (OSU Bulletin, CSE Description, OSU Schedule)

TEXT

Ramez Elmasri and Shamkant Navathe, Fundamentals of Database Systems, Addison-Wesley, 4th (2003, ISBN 0-321-12226-7) or 5th (2007, ISBN 0-321-36957-2) edition

• Basic Concepts (ch 1–4)
• Relational Model, Languages, and Systems (ch 5–9)
• Database Design Theory and Methodology (ch 10–11, 26 4th ed/27 5th ed)

lecture notes -- sample midterm exam -- sample final exam -- midterm exam -- final exam -- grades -- accounts -- software -- course availability -- osu map -- osu calendar (exams) -- emails -- posting web pages

GRADING POLICY

• 30% Homework (9 assignments)
• 20% Project
• 20% Midterm exam (Mo, Feb 9)
• 30% Final exam (Mo, Mar 16, 3:30 - 5:18;5:30 - 7:18)

Notes:

1. The exams will be with open notes and open books.
2. Assignments #3, #4, #8 should be submitted by midnight on due date. The other assignments are due in class or through the submit program, before class starts. Don’t turn assignments in my office, my mailbox, or through email. Also, keep all your graded works until you receive the final grade for the course.
3. Exceptions to the above dates of exams must be arranged with the instructor during the first week of the quarter.
4. A 25% grade penalty will be applied to students delivering a project alone instead of as a part of a team.

TIME/ROOM MW; 03:30-04:48, DL 317; 05:30-06:48, DL 317

INSTRUCTOR Eitan Gurari, Dreese 495, 292-3083; email: gurari@cse.ohio-state.edu; office hours: MW, 2:50–3:25, 4:50–5:25 and by appointment

GRADER Michael Williams, williams.2694@osu.edu; Office hour: MW 12:30-1:18, and by appointment, CL 420

NEWSGROUP cse.course.cse670 (reachable only from a cse account)

http://www.cse.ohio-state.edu/~gurari/course/cse670/cse670.xht, html

Note. MSIE might need the MathPlayer plugin to access some of the web pages.