CSIS 340 Database Systems

Course Description

A study of the organization of database systems for information storage, retrieval, performance, and security. Examples of relational and non-relational systems are presented.


Instructor

Brian R. Snider
Office hours: Wood-Mar 223 (see schedule)


Texts

required
recommended


Resources

Objectives

Students will be exposed to theoretical and practical aspects of database systems. Specifically, students will understand:

Students may also be exposed to additional selected topics, such as NOSQL databases, information retrieval, data mining, or data warehousing.

Course Organization

The course will include regular homework and/or programming assignments. There will be no credit given for late assignments (without an excused absence)—turn in as much as you can. Unless otherwise specified, no handwritten work will be accepted.

Reading should be completed before the lecture covering the material per the provided schedule. 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.


Collaboration and Academic Integrity

See the GFU CS/IS/Cyber policies for collaboration and discussion of collaboration and academic integrity. See also the university's policy on the use of generative AI and related tools in an academic setting. Most students would be surprised at how easy it is to detect collaboration or other academic integrity violations such as plagiarism in programming—please do not test us! Remember: you always have willing and legal collaborators in the faculty. We encourage you to ask questions in class, ask for help in the CS lab, use the class mailing list, and visit office hours for assistance.

Unless otherwise specified (e.g., for a group assignment or project), you are expected to do your own work. This also applies to the use of online resources (e.g., solution guides), help forums (e.g., StackOverflow), and generative models (e.g., ChatGPT). Put simply: if you are representing someone (or something) else's work as your own, you are being dishonest. Any suspected incidents of academic integrity violations will be investigated and reported to the Academic Affairs Office as they arise.

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, and you'll find that collaboration is a valuable skill in the working world. While some of you may be tempted to collaborate too much, others will collaborate too little. When appropriate, it's a good idea to make use of others—the purpose here is to learn. Be sure to make the most of this opportunity but do it earnestly and with integrity.


University Resources

Accessibility and Disability

If you have specific physical, psychiatric, or learning disabilities and require accommodations, please contact Disability & Accessibility Services (DAS) as early as possible so that your learning needs can be appropriately met. For more information, go to georgefox.edu/das or contact das@georgefox.edu.

My desire as a professor is for this course to be welcoming to, accessible to, and usable by everyone, including students who are English-language learners, have a variety of learning styles, have disabilities, or are new to online learning systems. Be sure to let me know immediately if you encounter a required element or resource in the course that is not accessible to you. Also, let me know of changes I can make to the course so that it is more welcoming to, accessible to, or usable by students who take this course in the future.

Academic Resource Center

The Academic Resource Center (ARC) on the Newberg campus provides all undergraduate students with free writing consultation, academic coaching, and learning strategy review (e.g., techniques to improve reading, note-taking, study, time management). The ARC offers in-person appointments; if necessary, Zoom appointments can be arranged by request. The ARC, located on the first floor of the Murdock Library, is open during the academic year from 1:00–9:00 p.m., Monday through Thursday, and 12:00–4:00 p.m. on Friday. To schedule an appointment, click on the TracCloud icon on the Canvas dashboard, go to traccloud.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.

Student Support Network

George Fox University uses a robust referral and support system, Fox360, to learn about students who are experiencing various student success concerns. Students who are referred by a professor, other employee, or fellow student will be contacted by a member of our Student Support Network to explore the student's situation, develop a plan, and connect with relevant campus resources. GFU community members who have a concern about a student's well-being can submit an alert by going to fox360.georgefox.edu. Our goal is to provide 360° care for students as they navigate their college experience. For more information see ssn.georgefox.edu or contact Rick Muthiah, Director of Learning Support Services.


Health and Safety Considerations

Please review the entirety of the university's official COVID-19 web page for the most up-to-date community guidance.

Grading

Grading Scale

The final course grade will be based on:

Graded course activities will be posted to Canvas. Take care to read the specifications carefully and proceed as directed. Failure to pay attention to detail will often result in few to zero points being awarded on a given activity.

Grades will be updated as often as possible; you are encouraged to use the "What-If" functionality to calculate your total grade by entering hypothetical scores for various items.

Note that some graded activities in this course will be submitted via GitLab.

Tentative Schedule

Week 1 · 8/30

Introduction

Reading: Ch. 1.1–1.2

Week 1 · 9/1

Database Systems

Reading: Ch. 1.3–1.9

Week 2 · 9/6

Database System Concepts

Reading: Ch. 2.1–2.3

Week 2 · 9/8

Database System Architecture

Reading: Ch. 2.4–2.7

Week 3 · 9/13

E–R Models: Entities

Reading: Ch. 3.1–3.3

Week 3 · 9/15

E–R Models: Relationships

Reading: Ch. 3.4–3.6

Week 4 · 9/20

E–R Diagrams

Reading: Ch. 3.7–3.9; 4.1–4.3

Week 4 · 9/22

E–R Case Studies

Reading: Ch. 3.10–3.11

Week 5 · 9/27

Relational Model

Reading: Ch. 5.1–5.4

Week 5 · 9/29

Relational Algebra

Reading: Ch. 8.1–8.5

Week 6 · 10/4

E–R-to-Relational Mapping

Reading: Ch. 9.1

Week 6 · 10/6

SQL: Data Definition

Reading: Ch. 6.1–6.2

Week 7 · 10/11

SQL: Data Manipulation

Reading: Ch. 6.3–6.6

Week 7 · 10/13

Midterm exam

Reading: Ch. 1–6; 8–9

Week 8 · 10/18

SQL: Complex Queries

Reading: Ch. 7.1

Week 8 · 10/20

SQL: Triggers, Views, and Schema Changes

Reading: Ch. 7.2–7.5

Week 9 · 10/25

Database Security

Reading: Ch. 30.1–30.2

Week 9 · 10/27

Course Project

Week 10 · 11/1

Functional Dependencies

Reading: Ch. 14.1–14.2

Week 10 · 11/3

Normal Forms

Reading: Ch. 14.3–14.5

Week 11 · 11/8

Disk Storage and File Structures

Reading: Ch. 16.1–16.7; 16.10

Week 11 · 11/10

Indexing

Reading: Ch. 17.1; 17.6.1–17.6.3

Week 12 · 11/15

Query Processing

Reading: Ch. 18.1–18.3

Week 12 · 11/17

Query Optimization

Reading: Ch. 19.1–19.2

Week 13 · 11/22

Transaction Processing

Reading: Ch. 20.1–20.3

Week 13 · 11/24

Thanksgiving break—no classes

Week 14 · 11/29

Transaction Logging; Disaster Recovery

Reading: Ch. 22.1–22.3; 22.7

Week 14 · 12/1

Distributed Databases

Reading: Ch. 23.1–23.4

Week 15 · 12/6

Selected Topics

Week 15 · 12/8

Selected Topics

Week 16 · TBD

Final exam

Reading: *
  1. GFU
  2. CSIS
  3. BRS
  4. CSIS 340

This page was last modified on 2022-07-18 at 19:20:13.

Copyright © 2015–2025 George Fox University. All rights reserved.