A study of the organization of database systems for information storage, retrieval, and security. Examples of relational and non-relational systems are presented.
Students will be exposed to practical and theoretical aspects of database management. Specifically, students will understand:
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:
The course will include regular homework and/or programming assignments. Unless otherwise specified, assignments are due 5 minutes before midnight 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. Quizzes over the assigned reading may be given at any time.
See the GFU CS/IS/Cyber policies for collaboration and discussion of collaboration and academic integrity. Most students would be surprised at how easy it is to detect collaboration in programming—please do not test us! Remember: you always have willing and legal collaborators in the faculty.
Almost all of life is filled with collaboration (i.e., people working together). Yet in our academic system, we artificially limit collaboration. These limits are designed to force you to learn fundamental principles and build specific skills. It is very artificial but intensional for your own benefit. The only way for you to learn is by doing the work.
To be clear, do not:
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 can be appropriately met. For more information, go to ds.georgefox.edu or contact Rick Muthiah, Director of Learning Support Services (503-554-2314 or rmuthiah@georgefox.edu).
The Academic Resource Center (ARC) on the Newberg campus provides all students with free writing consultation, academic coaching, and learning strategies (e.g., techniques to improve reading, note-taking, study, time management). The ARC, located in the Murdock Learning Resource Center (library), is open from 1:00–10:00 p.m., Monday through Thursday, and 12:00–4:00 p.m. on Friday. To schedule an appointment, go to the online schedule at arcschedule.georgefox.edu, call 503-554-2327, email the_arc@georgefox.edu, or stop by the ARC. Visit arc.georgefox.edu for information about ARC Consultants' areas of study, instructions for scheduling an appointment, learning tips, and a list of other tutoring options on campus.
At any point in the term, you can leave anonymous feedback via this form. If there is something you want or need to tell me about the course feel free to leave a comment.
Besides EYS, I am always available to discuss the Christian faith if you have any questions or doubts. Send me an email, come by my office hours, or talk to my after class, Christ is the reason I am at GFU, I always have time to talk about faith.
The final course grade will be based on:
Week 1Introduction; DB Concepts
Reading: Chp. 1 & 2 |
Week 2Relational Model & SQL
Reading: Chp. 5 & 6 |
Week 3SQL
Reading: Chp. 6 |
Week 4More SQL
Reading: Chp. 6 & 7 |
Week 5Adv. SQL
Reading: Chp. 7 |
Week 6ER Model
Reading: Chp. 3 |
Week 7ER to schema & Relational Algebra
Reading: Chp 4. & 9 |
Midterm exam 10/17
|
Week 8Relational Algebra
Reading: Chp. 9 |
Week 9Relational Algebra & Functional Dependencies
Reading: Chp. 9 & 14 |
Week 10Normal Forms
Reading: Chp. 14 |
Week 11Data Structures
Reading: Chp. 16 |
Week 12Indexes & Query Processing
Reading: Chp. 17 & 18 |
Thanksgiving
|
Week 13Query Optimization
Reading: Chp. 19 |
Week 14Transactions, Concurrency, & Database Recovery
Reading: Chp. 20, 21, & 22 |
Week 15Distributed Databases & NOSQL
Reading: Chp. 23 & 24 |
TBDFinal exam
|
This page was last modified on 2024-01-03 at 09:14:02.
George Fox University · 414 N Meridian St · Newberg, Oregon 97132 · 503-538-8383
Copyright © 2018–2024 George Fox University. All rights reserved.