A study of the organization of database systems for information
storage, retrieval, and security. Examples of relational
and non-relational systems are presented.
Instructor
Texts
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.
Students will be exposed to practical and theoretical aspects of
database management. Specifically, students will understand:
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
Students may also be exposed to advanced topics including
object-oriented and extended-relational data models, data warehousing,
distributed database management, etc.
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
The course will include regular homework assignments and a
group-oriented database design & implementation
project
(please see my
comments on collaboration. Assignments are
due before 11:59pm on the due date; there will be
NO CREDIT given for late assignments (without
an excused absence) - turn in as much as you can.
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.
The Vision Statement of the Computer Science and Information Systems
majors states that our students are distinctive by:
"Bringing a Christ-centered worldview to our increasingly technological
world."
As one step towards the fulfillment of this objective, each
semester, we will identify an influential Christian writing to be read
and reflected upon by students in our classes throughout the term.
This will be treated as an official component of every course and will
be uniquely integrated and assessed at our discretion, generally
as a component of the quiz grade.
See the semester's reading schedule.
In addition, regular meetings will be scheduled throughout the semester
that can be attended for Chapel credit.
It is my hope that students will not view this as one more task to
complete, but as a catalyst for continued discussion ultimately leading
to a deeper walk with Christ.
The chief end of man is to glorify God, and enjoy Him
forever. (Westminster Confession)
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)