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 222 (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. 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 visit office hours, ask questions in class, and use the class mailing list 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., StackOverflow). Put simply: if you are representing someone 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

If you have specific physical, psychiatric, or learning disabilities and require accommodations, please contact Disability & Accessibility Services 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 preferences, 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.

The Academic Resource Center (ARC) on the Newberg campus provides all students with free writing consultation, academic coaching, and learning strategy review (e.g., techniques to improve reading, note-taking, study, time management). During the 2022 fall semester, the ARC is offering in-person appointments as well as virtual appointments over Zoom as needed. The ARC, located on the first floor of the Murdock 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.


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: *


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

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