CS377: Database Design

[ Course Info | Course Objectives and Goals | Resources | Instructors | Textbooks | Schedule | Grading | Course Policies | Course Details ]

DVD Rental Query
MediaWiki 1.28.0 database schema
Example Record-Based Database Schema
Welcome to CS377!

Course Info

  • Course Number and Title: CS377 - Database Design
    • Section A
  • Credit Hours: 4 Semester Hours
    • Credit Hours include "contact time" in the classroom and outside course work. It is expected that the sum of classroom time and outside course work time should add up to three times the listed credit hours per week.
  • Course Webpage: https://BillJr99.github.io/Ursinus-CS377-Fall2021

  • LMS (Canvas): Canvas

  • Course Calendar: Import the course calendar into your favorite calendar app with this link!

  • Class Notebook: Access our class notebook here! If you are unable to access the notebook, please let me know and I will share the document with your account.

  • Help Room on Microsoft Teams: Click Here to Go to the Teams Help Room Channel on Microsoft Teams.

  • Academic Term: Fall 2021-22

  • Term Start and End: through

  • Course Prerequisites: CS275

  • Class Meeting Locations and Times:
    • Section A:
      • s from 11:00 AM to 11:50 AM in IDC 116
      • s from 11:00 AM to 11:50 AM in IDC 116
      • s from 11:00 AM to 11:50 AM in IDC 116
  • Final Exam:
    • Section A: 2021/12/13 from 9:00 AM to 12:00 PM in TBD
  • Course Description: The concepts involved in designing and using a database management system. Logical and physical database design. Entity-Relational Modeling. Various types of database structures, manipulations of a database structure through applications, query techniques, and programming in a database language. Prerequisite: CS-275. Offered in the fall of odd years. Three hours per week.

Course Learning Objectives and Learning Goals

Learning Objectives

  1. To select appropriately between data models including relational and non-relational databases
  2. To scale databases to high-performance data models for real-time cloud deployments
  3. To define and apply the tradeoffs between consistency, scale, and performance
  4. To implement database solutions that are robust and secure
  5. To implement front-end interfaces to explore backend databases

Learning Goals

  1. To harnass the informative potential of data through organization and scale

The Questions

Throughout the course, we will be thematically guided by the Ursinus Questions:
  • What should matter to me?
  • How should we live together?
  • How can we understand the world?
  • What will I do?

Resources

Accommodations

Ursinus College and your instructor are committed to ensuring equal access and providing reasonable accommodations for all students. If you have, or think you have, a disability in any area such as, mental health, attention, learning, chronic health, sensory, or physical, please contact the Director of Disability Services.

Ursinus College is committed to ensuring equal access and providing reasonable accommodations for students with disabilities. The Institute for Student Success works with students who have any kind of disability, whether apparent or non-apparent, learning, emotional, physical, or cognitive, and need accommodations to increase their access to this learning environment. I encourage you to reach out to the Director of Disability Services, Dr. Dolly Singley to discuss about supports and accommodations you may need. Dolly’s office is located in the Institute for Student Success in Lower Wismer. You can schedule a meeting with Dolly by using this link: https://dsingley.youcanbook.me/, by emailing her at dsingley@ursinus.edu or by calling her at 1-484-762-4329. Students can also review accessibility and disabilities services on the ISS website.

Religious and Spiritual Life Observance Policy

Per the Religious and Spiritual Life Observance Policy, students who expect to miss classes, examinations, or other assignments due to religious observance may notify me two weeks prior to the observance. I will be happy to discuss reasonable alternatives with you.

Wellness Center

Let's Talk Poster
The Wellness Center has a virtual drop-in crisis hour at 2-3 pm each weekday, which is available for students in crisis who need to be seen immediately by a clinician. Their resources are confidential and free to all students. Please consult the Wellness Center website for more information and the link to the virtual crisis hour. As a student, you may experience a range of issues that can cause barriers to learning or reduce your ability to participate in daily activities. These might include strained relationships, anxiety, high levels of stress, alcohol/drug problems, feeling down, health concerns, or unwanted sexual experiences. The Wellness Center provides free short-term individual counseling, group therapy, and referral services that are confidential and are not a part of your educational record. Call Wellness at 610-409-3100 between 9:00-5:00, M-F. If you or someone you know is experiencing a crisis after hours, call Campus Safety at 610-409-3333. For a local resource, Montgomery County Mobile Crisis is available for 24/7 telephone support at (855) 634-HOPE (4673). The National Suicide Prevention Hotline also offers 24/7 support at 800-273-8255. As a student you may experience a range of issues that can cause barriers to learning, such as strained relationships, increased anxiety, alcohol/drug problems, feeling down, difficulty concentrating and/or lack of motivation. These mental health concerns or stressful events may lead to diminished academic performance or reduce a student’s ability to participate in daily activities. Ursinus College Wellness Center offers services to assist you with addressing these and other concerns you may be experiencing. If you or someone you know are suffering from any of the aforementioned conditions, you can learn more about the broad range of confidential mental health services available on campus via the Wellness Center by emailing wellness@ursinus.edu or calling 610-409-3100. If you are interested in more academic support, please contact the Institute for Student Success at instituteforstudentsuccess@ursinus.edu or 610-409-3400. If you find yourself struggling with your mental or physical health this semester, please let me know. I am one of many people here at Ursinus who care about you and your welfare. For example, the Wellness Center provides numerous health and counseling services, including free short-term individual counseling, group therapy, and referral services that are confidential and are not a part of your educational record. Contact the Wellness Center by emailing wellness@ursinus.edu or calling 610-409-3100.

Peer Coaching

The Institute for Student Success offers Peer Coaching that you can sign up for anytime. The Institute for Student Success connects students to the resources, activities, services, and programs that can help students be successful, thrive, and persist to graduation. They offer academic skills workshops, one-on-one coaching, tutoring, and more. Contact them at instituteforstudentsuccess@ursinus.edu or 610-409-3400.

Center for Writing and Speaking

The Center for Writing and Speaking is available for one-on-one and group appointments to advise you as you revise your writing projects and presentations. They will even support your personal projects and extracurricular activities! Please feel free and encouraged to review any and all writing and speaking work from this class with them.

Bear2Bear

The college recognizes that temporary financial hardships can impact students' access to course materials, as well as their access to opportunities on campus. Please be aware of the Bear2Bear fund, which has been established by donors to the college and provides special grants for students who have exhausted other sources of funding.

Help Room

The Math Help Room (Pfahler 102) is a great place to go if you are struggling and is managed by the Institute for Student Success. Students who have previously taken the course will be there to help you with the assignments.

Course Instructors and Drop-In / Office Hours

Role Name and Contact Information Drop-In / Office Hours
Professor William Mongan
Picture of Professor William Mongan

Phone: 610-409-3410
E-Mail: wmongan@ursinus.edu
Office: Pfahler Hall 101L
  • s from 12:00 PM to 2:00 PM in Pfahler Hall 101L
  • s from 11:00 AM to 2:00 PM in Pfahler Hall 101L
  • s from 12:00 PM to 2:00 PM in Pfahler Hall 101L
  • s from 12:00 PM to 2:00 PM in Pfahler Hall 101L
Drop-In / office hours are certainly available for asking questions about the course, about your assignments, and other academic questions you may have. You do not need an appointment to come to drop-in hours, and you do not even need to have an agenda or set questions! You can come and just have a general chat about things with us. If you cannot make it to drop-in hours, you can contact us for an appointment as well. Drop-In hours are also for non-instructional topics of conversation: you can talk with me about your adjustments to college life, your long-term goals, advice about your academic journey, and most other things. If I don't know the answer to something or if I don't feel I am the best person to offer you advice about it, I will be happy to help connect you with the right people. In other words, don't be afraid to ask me things that you think are "off topic" - I love teaching because I love to be a resource for you on your journey. I'll be happy to see you there.

Textbooks

Required? Title Author Edition ISBN Freely Available?
Required
Picture of the cover of the book entitled Database Design

Database Design
Adrienne Watt and Nelson Eng 2nd Edition Online Version
Required The Little MongoDB Book Karl Seguin Version 2.6 Edition Online Version
Please Note: The cost of the book may be prohibitive for some students, so please note that renting the book is much cheaper. Please communicate as early as possible if you are having trouble obtaining the book, rather than keeping this to yourself, so that we can work on a solution together. If you are experiencing a financial hardship, please consider the Bear2Bear Emergency Fund for temporary relief applications.

Course Schedule

Week Date Title Readings Deliverables Handed Out Deliverables Due
Week 1 Course Overview: What is a Database, and Why Use Them?
Week 1 Course Overview: What is a Database, and Why Use Them?
Week 1 Managing Data: Text and Files
  • DD Ch. 1
Week 2 File I/O Primer
Week 2 Organizing Data: Fields, Records, and Keys
  • DD Ch. 2
Week 2 Relational Database Systems (RDS)
Week 3 Relational Database Systems (RDS)
Week 3 Processing and Aggregating Data Records
Week 3 Processing and Aggregating Data Records
Week 4 Processing and Aggregating Data Records
Week 4 Data Modeling and Schemas
  • DD Ch. 4-5
Week 4 Data Modeling and Schemas
Week 5 Data Modeling and Schemas
Week 5 The Relational Database Model and Database Programming Primer
Week 5 The Relational Database Model and Database Programming Primer
Week 6 The Relational Database Model and Database Programming Primer
Week 6 The Entity-Relational (ER) Model
  • DD Ch. 8
Week 6 The Structured Query Language (SQL)
Week 7 The Structured Query Language (SQL)
Week 7 The Structured Query Language (SQL)
Week 7 Data Integrity
  • DD Ch. 9
Week 8 Facilitating Integrity with Modeling and the SQL Join
Week 8 Facilitating Integrity with Modeling and the SQL Join
Week 9 Facilitating Integrity with Modeling and the SQL Join
Week 9 Facilitating Integrity with Modeling and the SQL Join
Week 9 ER Modeling and Normalization
  • DD Ch. 11-12
Week 10 ER Modeling and Normalization
Week 10 ER Modeling and Normalization
Week 10 A Non-Relational Database Model: NoSQL
  • M Ch. 4, 8 (1, 5)
Week 11 A Non-Relational Database Model: NoSQL
Week 11 CRUD with NoSQL
Week 11 CRUD with NoSQL
Week 12 RESTful Web Services with Databases
Week 12 RESTful Web Services with Databases
Week 12 NoSQL Data Processing and Aggregation
  • M Ch. 6, 9 (3, 6)
Week 13 NoSQL Data Models: Key-Value, Document, Columnar, and Graph
Week 14 Indexing a Denormalized NoSQL Datastore
  • M Ch. 7 (4)
Week 14 Workshop: Toward Scaled Managed Cloud Databases
  • M Ch. 10 (7)
Week 14 Workshop: Toward Scaled Managed Cloud Databases
Week 15 Workshop: Toward Scaled Managed Cloud Databases
Week 15 Review
Week 15 Review
Please note the following holidays this term:
Please note the following key calendar dates:
  • Add Deadline:
  • Drop with a W Deadline:
  • Reading Day:

Grade Breakdown

Letter grades will be assigned on the scale below at the end of the course. "Grade grubbing" is not conducive to professional practice; every assignment has or will have very precise expectations and point breakdowns, and I will evaluate submitted work carefully according to these standards. I will also return assignments in a timely manner, and the running weighted grades will be updated frequently. Therefore, I expect a commensurate level of respect from you. In sum, you should know where you stand at all times, there will be plenty of opportunities to improve your standing, and there should be no surprises at the end of the course.

Grading Table

Item Weight
Programming Assignments 40%
Labs 25%
Exercises 15%
Final Project 20%

Letter Grades

Letter Grade Range
A+ 96.9-100
A 93-96.89
A- 89.5-92.99
B+ 87-89.49
B 83-86.99
B- 79.5-82.99
C+ 77-79.49
C 73-76.99
C- 69.5-72.99
D+ 67-69.49
D 63-66.99
D- 59.5-62.99
F 0-59.49

Course Policies

Netiquette in Online Discussion Boards infographic
Courtesy of the Online Education Blog of Touro College.

Classroom Environment and Inclusivity Standards

My goal is to foster a environment in which students across all axes of diversity feel welcome and valued, both by me and by their peers. Axes of diversity include, but are not limited to, age, background, beliefs, race, ethnicity, gender/gender identity/gender expression (please feel free to tell me in person or over e-mail which pronouns I should use), national origin, religious affiliation, and sexual orientation. Discrimination of any form will not be tolerated. Furthermore, I want all students to feel comfortable expressing their opinions or confusion at any point in the course, as long as they do so respectfully. As I will stress over and over, being confused is an important part of the process of learning computer science. Therefore, I will not tolerate any form of put-downs by one student towards another about their confusion or progress in the class. Learning computer science and struggling to grow is not always comfortable, but I want it to feel safe. Much of this material is probably new to everyone, and those with some prior experience likely recall a time when it was new to them, too. Remember that this is not a competition: helping others to grow is itself a richly rewarding professional development opportunity. In order to allow for equitable access to class for students who may be attend and participating remotely, I may record our class sessions. These recordings will only be available on our Canvas site. I will announce that we are recording in the beginning of any classes of this kind; out of respect and privacy for me and all class members, please do not download, copy, or redistribute class recordings.

Online Communication Policy

Since this is a class-wide communication, the following rules apply to message groups and electronic communications:
  1. Students are expected to be respectful and mindful of the classroom environment and inclusivity standards.
  2. They are equally applicable to a virtual environment as they are in class.
  3. Students are not permitted to share direct answers or questions which might completely give away answers to any homework problems or labs publicly on Microsoft Teams. When in doubt, please send me a direct message there.
  4. I will attempt to answer questions real time during my virtual drop-in / office hours. Otherwise, I will make every attempt to respond within 24 hours. Of course, students can and should still respond to each other outside of these intervals, when appropriate!
  5. Students may ask anonymous questions.

Course Management Systems: Canvas, Microsoft OneNote, and Microsoft Teams

We will be using Canvas to post all of the grades. For the most part, we will submit work using Canvas as well. For class activities and notes, we will be using OneNote, and for other discussions and announcements for the course, including messaging me directly with questions, we will use Microsoft Teams. OneNote and Teams are linked to your Office suite through Ursinus, so you are automatically enrolled. There you can ask and answer questions about the lecture content and assignments.

Since it is likely that students will have similar questions, it is much more efficient for me to answer them there so the whole class can see the answer, so it is possible that I will ask you to re-send a question publicly that I get in an e-mail. If you'd prefer, I could anonymize the question as well, but I'd like you to have the opportunity to post it so that you are credited with having such a good question!

Collaboration Policy and Academic Integrity Policy

Communication between students is allowed (and encouraged!), but it is expected that every student's code or writeups will be completely distinct! Please do not copy code off of the Internet (repurposing code from the Internet will probably make it harder anyway because the assignments are so specialized). Please cite any sources in addition to materials linked from the course website that you used to help in crafting your code and completing the assignment.

See the Course Management page in the Faculty Handbook for an explanation of college policies on plagiarism and other academic honesty violations.

To encourage collaboration, students will be allowed to choose one "buddy" to work "near" during the assignment. Students are still expected to submit their own solutions, but they are allowed to provide substantial help to their designated buddy, and even to look at the buddy's code during the process. Students must indicate their buddies in the README upon assignment submission. Please let me know if you would like a buddy but are having trouble finding one.

Below is a table spelling out in more detail when and how you are allowed to share code with people (table style cribbed from Princeton CS 126).

Please Note: The terms "exposing" and "viewing" exclude sending or ingesting electronically, which would be considered copying. Exposing and viewing are normally done in the context of in-person working or in the help room. In addition, "Other People" includes internet sources!
Your Buddy Course Staff Course Grads Classmates Others
Discuss Concepts With OK OK OK OK OK
Acknowledge Collaboration With OK OK OK OK OK
Expose Your Code/Solutions To ALL EXCEPT
Assignments
OK OK NO NO
View the Code/Solutions Of ALL EXCEPT
Assignments
OK NO NO NO
Copy Code/Solutions From NO NO NO NO NO

If the work you submit appears to be copied from previous work or the collaboration policy has been violated in any way (including working with more collaborators or "buddies" than the course deliverable specifies) according to the College Academic Honesty policy, regardless of intent, then it may be an academic dishonesty case, and it will be referred to the Associate Dean for Academic Affairs. I am required to make this report in every occurrence, so it is best to speak with me first if there are any questions about the policy or expectations. You should feel free to have these conversations with me anytime prior to making your submission without fear of penalty. Finally, aside from the collaboration policy here, it is expected that your work is your original work. You must cite any collaborations or references that you use. You may have a friend or relative with computing experience, but they should not do your assignments, labs, etc., for you.

Flexible Submission Policy

In the absence of accommodations arranged in advance with the instructor or college, all assignments are due at 10:59PM Eastern Time on the date(s) stated on the schedule. Assignments will be accepted without prior permission following this time with a points deduction of 5% per day if submitted before 10:59 PM Eastern Time on the day submitted. This policy does not apply to extra credit opportunities: extra credit will not be awarded for assignments submitted under the flexible submission policy. Late work cannot be accepted after the final class meeting, nor during final exams week, nor after the exam.

Incomplete Policy

A grade of I may only be granted by permission of the Office of the Dean. A petition to the Office of the Dean will only be made upon written request by the student, including all information requested by the Office of the Dean. Requests for a grade of I will only be made in situations where such a request is warranted. Specifically, the student's grade must be passing at the time the request is made.

Title IX

Title IX is a federal law, under which it is prohibited to discriminate, harass, or commit misconduct on the basis of gender or sex. The Title IX Coordinator is available to receive inquiries and to investigate allegations in this regard.

Inclement Weather and Class Cancellation Policy

In the event that the College closes due to inclement weather or other circumstances, our in-person class sessions, drop-in / office hours, labs, or other meetings will not be held. I will contact you regarding our plan with regard to rescheduling the class or the material, any assignments that are outstanding, and how we can move forward with the material (for example, any readings or remote discussions that we can apply). If necessary, I may schedule online virtual sessions in lieu of class sessions, and will contact you with information about how to participate in those. I will communicate this plan to the department so that it can be posted on my office door if it is feasible to do so. This policy and procedure will also apply in the event that the College remains open but travel conditions are hazardous or not otherwise conducive to holding class as normal. Should another exigent circumstance arise (for example, illness), I will follow this policy and procedure as well.

Student Perception of Teaching Questionnaire (SPTQ)

I will be soliciting student feedback through the SPTQ and possibly through other forms of commentary. This feedback greatly assists me and the department as we develop our courses and overall curriculum for this program. This course has benefitted from the feedback of those students who took the course before you, and your feedback will help maintain and improve the course for those to follow. I strongly encourage you to participate in this important and valuable process.

Syllabus Subject to Change

I will do my best to provide all relevant information about the course on this syllabus. Sometimes, exigent circumstances, the pace of the class, or other circumstances will warrant minor revisions to the syllabus. For example, inclement weather or other campus closure might affect the course schedule and assignment deadlines; in addition, I may find that the class benefits from spending more time on a particular topic, and adjust accordingly. Although I try to avoid rescheduling drop-in / office hours, it may become necessary from time to time to accommodate other events in the College. Should any revisions be necessary, I commit to making any revisions in my estimation of the best interests of the class, and commit to communicating those changes to you as soon as I make them.

Course Details

Overview

Welcome to CS377: Database Design! In this course, we will explore models for storing, organizing, indexing, searching, transmitting, and scaling data to make it useful for humans and computers to extract efficiently and effectively.

Homework

Labs

Approximately every week, we will have a lab session where students get a chance to practice concepts we just learned in a safe and collaborative environment. Tasks will be given that serve as warm-ups for the larger assignments, and you will have a chance to refine your submissions as you practice.

Assignments

The bulk of the grade in the course will be earned by completing individual programming assignments. Be sure to start them early! Note that collaboration and sharing rules differ slightly for labs and assignments.

Classroom Participation

Group Work [1]

In addition to ordinary participation that follows the natural rhythm of a lecture, most days there will be at least one followup problem, which is a question that follows on the heels of newly presented material. Students will split into groups of 2 and try to write some code to address a particular problem. When a group of students believe they have figured out the answer, they raise their hand. The other students can continue to work while I verify that the answer is correct. If the answer is correct, the students present the answer to the class. If the group is not correct upon my checking, then the groups continue this process until one gets it correct.

Other ways to help your fellow classmates in class are as follows:

  • Helping to teach a student a topic during office hours.
  • Certain calls for participation in class
  • Particularly helpful or insightful messages on Microsoft Teams
  • Finding mistakes in the book or on the assigned homework and labs

Class Participation and Classroom Etiquette [1]

For classroom attendance, the following rules apply:

  • Please be attentive during class. There will be class exercises that involve coding, but class time should be used for learning computer science. It is imperative that technology be used for this purpose during our class time together. Alternatively, please try to think of this as a safe space away from social media. We could all use a break, and we are fortunate to have a good excuse to make that space.
  • Please follow common courtesy. For instance, you can bring food and drink as long as it’s not distracting, but please clean up after yourself if you do. Our janitorial staff deserves the utmost respect and help with their job.
  • In-class exercises and “low stakes” activities will take place individually and in groups to assess our progress together. These exercises will be given both synchronously (for example, in-class activities, pair programming exercises) and asynchronously (for example, pre-lab exercises, peer code reviews, book surveys) and will be graded on a participation basis. These are given equal weight and form the basis of the class participation score.
  • If a class session is remote, please feel free to make choices that make you most comfortable. For example, I will record these sessions for students who cannot make the session or for those who would benefit from a review of the material. I’d encourage you to enable your video feed if it is available, but if you need leave your video off, you feel free to do so; however, if you find that this becomes necessary on a prolonged basis, please see me to discuss. Please keep your microphone on mute to avoid background noises while others are speaking; however, please do not feel “mic fright” about unmuting to speak up and participate anytime. If, however, you would prefer to communicate via the chat interface (either exclusively or in combination with your audio/video), you should feel free to do that. Whether in-person or remote, all I ask is that you engage as best you can; the material is challenging but fun, and we’re all here to learn new things together.
  1. This introduction is adapted from Dr. Tralie’s CS173 Course Syllabus 2