Required

• Elmasri & Navathe. Fundamentals of Database Systems. Reading, Massachusetts: Addison-Wesley.

Recommended

(Good SQL help - great for CSIS 314 too)
• Ben Forta, Sams Teach Yourself SQL in 10 Minutes Indianapolis, IN: Sams Publishing.

• When, why, and how to use a database management system.
• Fundamental relational theory.
• Basics of the SQL query language.
• How to use a high-level data modeling technique, such as Entity-Relationship diagrams, for database design.
• How a DBMS functions including:
• File and index structures
• Query processing
• Transaction mechanisms
• Recovery mechanisms
• Security

Through a group-oriented hands-on project students will:

• Gain practical experience with a client-server DBMS
• Design and document (using ER diagrams) a relational database
• Acquire SQL query skills

Reading assignments should be completed before the lecture covering the material. Not all reading material will be covered in the lectures, but you will be responsible for the material on homework and exams. Quizes over the assigned reading may be given at any time.

If you have specific physical, psychiatric, or learning disabilities and require accommodations, please contact the Disability Services Office as early as possible so that your learning needs may be appropriately met. You will need to provide current documentation of your disability to the Disability Services Office. For more information, go to ds.georgefox.edu or contact Rick Muthiah, Dean of the Center for Teaching and Learning (ext. 2314)

The final grade will be based on:

• 35% Homework Assignments
• 20% Database Project
• 5% Reading Quizes
• 20% Midterm
• 20% Final