CS 320: Database Management Systems 2019

Fall 2019

Welcome to Database Management Systems!

All the homework/labs/lectures will be distributed on Moodle.

We meet TR, 2:45-4 pm, RISC 562.

Course Description

Course Description

This course examines the organization, design and implementation of database management systems. Together, we will examine how important database systems are to our everyday activities, how they contribute to society, and how they enrich the emerging field of data science. You will learn to design and build database applications, and leave the class with the skill needed to improve your understanding and use of databases on a continuing basis.


Types of Databases We Will Study
Relational Databases and Online Transaction Processing



No SQL Databases




Instructor Information(back up↑)

  • Instructor: Dr. Joann J. Ordille
  • Email: ordillej at lafaytte.edu
  • Office: 565 RISC
  • Office Phone: (610) 330-5416
  • Office Hours: T 4-5 pm (except 9/24, 10/29,  12/3), TWTh 1-2 pm, Th 4-5 pm.  Please email me if you would like to meet at any other time. Also, if my door is open, feel free to drop in.



Useful Links(back up↑)

Gradiance is our online learning system. Gradiance provides exercises with guidance when you choose an incorrect answer. Create your account using the code I emailed you.

This w3cSchools.com SQL course will guide you through SQL features and let you try them as you go. As with any language, computer or natural, practice is key to internalizing the language. This site also includes tutorials on HTML, CSS, JavaScript, Bootstrap and a wealth of front-end web technologies. lynda.com (see below) also provides a variety of helpful tutorials.

  • lynda.com

lynda.com is available from your my Lafayette page. It provides many helpful tutorials.  You can use lynda to help fill in background you might need for your projects. Your projects will involve building a database application for a customer, and that typically requires a web front-end.

HackerRank.com provides progressively more difficult SQL practice problems. It provides an environment where you can simulate the experience you will have in the lab exam. They have a new tutorial on JavaScript as well.  HackerRank is also a great place to practice various programming skills in preparation for interviews.

  • Papers published in the computer science literature as announced in the syllabus or on Moodle.

We will read several papers together to broaden our perspective on databases. Reading computer science papers is a primary way to keep up with the state of the art once you graduate. You will learn approaches to reading a computer science paper that will increase your understanding of it.

  • Moodle

We will use Moodle extensively. In particular, detailed information for class activities and assignments will be available weekly. Please check Moodle frequently, and whenever you receive an email notification to do so.

Course Information

Course Information(back up↑)

  • Prerequisites:

    Students are required to complete CS 205 (Software Engineering) successfully before registering for this course. Software engineering techniques will be used in your database design and development project. Students are also required to co-register in CS 202 (Analysis of Algorithms). Algorithms studied in CS 202 are used in database systems, and the efficiency of various database algorithms will be discussed in this course.

Course Goals and Outcomes

Course Goals and Outcomes(back up↑)
Course Goals:

The goals of this course are to convey:

  • Understanding of important database design principles with a focus on efficiency and extensibility.
  • Functional understanding of the Structured Query Language (SQL) for the creation and manipulation of databases.
  • Skill in developing a database management system starting from a set of requirements.
  • Experience in developing a substantial database design, constructed as a group working over the majority of the semester.
  • Effectiveness in reading and evaluating papers in computer science.

Course Outcomes: After successfully completing this course, students will be able to:

  • Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions (ABET Outcome 1).
  • Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline (ABET Outcome 2).
  • Function effectively as a member or leader of a team engaged in activities appropriate to the program’s discipline (ABET Outcome 5).
  • Apply computer science theory and software development fundamentals to produce computing-based solutions (ABET Outcome 6).
  • Engage in continuing professional development in database systems and the computer science discipline.

Assignment Types

(back up↑)Assignment Types

Class Attendance: Class attendance is critical to success. In addition to instruction and in-class exercises, we will engage in a variety of software engineering practices, e.g. the scrum of scrums, to assist in the design and development of the group projects. Every effort should be made to arrive on time and remain attentive for the entire class. In addition to unexcused absence, a pattern of late arrival, early departure or inattentiveness will be considered a violation of the attendance requirement. For every unexcused absence, you will lose 0.5 points from your final grade up to a total of 2 points. If you have a dean’s excuse or a coach’s letter for a particular day, you will be excused from class.

Class Participation: Class participation includes asking or answering questions, expressing an opinion about a topic of discussion, meeting with me during office hours, and reporting on activities in a group project, a reading group, or other group activity. All sincere efforts to participate are admired, so don’t worry, just speak up. You are even welcome to express an opinion different than mine. All types of participation count except participation that shows you failed to prepare for class. For example, asking: “Who is Ada Lovelace?” when the assignment was to read the Countess of Lovelace’s biography would not count as class participation. But, it’s always better to ask than to sit there in the dark.

Reading Groups: Before the second class meeting, we will form reading groups of four to five students. Several times during the semester, you will read a paper in the computer science literature, and meet with your reading group to discuss it. I will provide you with a strategy for reading the paper well, and some questions for discussion. Your group will be responsible for submitting a summary of your discussion in writing before the class meets to discuss the paper with me. You may also want to meet with your reading group to study for exams. Your software project group may be different from your reading group.

Quizzes: To encourage you to prepare for class, there will be unannounced quizzes. The quizzes will test whether you completed the assigned reading or other preparation for the class. Other quizzes will test your knowledge of the previous week. The intention here is to encourage you to review the material each week in preparation for the next week’s discussions. Some quizzes may include both kinds of questions.

Homework: Homework assignments will consist of problems and labs in the Gradiance System, and other problems/labs assigned in class. Assignments will be listed in Moodle to help all of us track them. Completing the homework will deepen your understanding, help you build skills necessary for completing the group project, and assist you in preparing for exams. Your homework should be your own work, and not copied or supplied by anyone else. Since we will often discuss homework in class after the due date, late homework will not be accepted. For each Gradiance homework, you can read the assistance and redo the exercise if you make a mistake.

Group Projects: As advanced students in computer science, you are now in a position to accept and evaluate software project requirements from a client. This semester you will have an opportunity to do a project with a client. I will offer some workshops outside of class on programming skills you may find useful in completing your project.

Exams: We will have two midterms. One will be a written exam in class. The second will be a in class lab exam with the use of your computer to test your proficiency in SQL. The written exams will test your ability to answer homework type problems and your conceptual understanding of database systems. We will discuss the types of possible exam questions before each exam. There will also be a final exam.  All work on the exam must be your own. There will be no make-up or early exam sittings without a request from the Dean or a Coach on your behalf. Before any exam begins, you are required to close your course materials, and put them and your phone in the front of the class to avoid the temptation look at them during the exam.

Academic Honesty

(back up↑)Academic Honesty

It is essential that you follow the Lafayette College Code of Conduct with respect to academic honesty and avoidance of plagiarism as described in the Student Handbook. The beginning of the semester is a good time to review the handbook in this regard.

“To maintain the scholarly standards of the College and, equally important, the personal ethical standards of our students, it is essential that written assignments be a student’s own work, just as is expected in examinations and class participation. A student who commits academic dishonesty is subject to a range of penalties, including suspension or expulsion. Finally, the underlying principle is one of intellectual honesty. If a person is to have self-respect and the respect of others, all work must be his/her own.”

The Handbook gives the following examples of intellectual dishonesty:

  1. Submitting someone else’s work as your own.
  2. Incorporating someone else’s ideas or work into your own without attribution.
  3. Paying or arranging for someone else to do your work.
  4. Re-using material from another course without permission of your instructor.
  5. Engaging in unauthorized collaboration including asking for homework or programming assignment answers from an online discussion group.
  6. Obtaining the Instructor’s Answer Guide to the exercises in the book and using it. (This would also constitute theft, since the guide is only licensed to instructors.)

When in doubt about whether an action is considered academic dishonesty, it is best to consult with me before you act. Cases of suspected intellectual dishonesty will be reported to the Dean, and the Dean will investigate and impose penalties.


(back up↑)Grading

Graded Material:
The course grade is based on the materials listed below graded on a 100 point scale, with each item contributing a specified percentage to the overall score. As specified in the student handbook, A will reflect excellent work, B will reflect good work, C will reflect acceptable work, and D will reflect passing work.

Class Attendance 2%
Class Participation 2%
Quizzes and Homework 6%
Group Projects 15%
Mid-Term 24%
Lab Exam 25%
Final Exam 26%

Grading Scale:
Typically, grades are assigned as follows from your final numerical grade:


A: 93-100 B+: 87-89 C+: 77-79 D+: 67-69 F: 0-59
A-: 90-92 B: 83-86 C: 73-76 D: 63-66
B-: 80-82 C-: 70-72 D-: 60-62

Tentative Schedule

(back up↑)Tentative Schedule*


Wk. Dy. Date Topic
Readings (T:Database Systems)
1 T 8/27
Introduction to Databases
T: 1
R 8/29
Relational Model, Relational Algebra
T: 2
2 T 9/3
Semi-Structured Data and the Web, MongoDB
T: 11
R 9/5
Document Object Models
Front End Architectures
3 T 9/10
Ted Codd’s Paper,
Reasoning with Functional Dependencies
T: 3.1-3.2
R 9/12
Boyce-Codd Normal Form
Group Project Discussion
T: 3.3-3.4
4 T 9/17
More Normal Forms
T: 3.5, 9
R 9/19
Relational Algebra with Bags
T: 5.1, 5.2
5 T 9/24
T: 6, W: Introduction,
W: PostgreSQL through Day 1
R 9/26
T: 6
6 T 10/01
T: 6.6, 18.1-18.3
R 10/03
More Transactions, Review
7 T 10/08
Midterm Exam
R 10/10
Database Design with E-R Diagrams
T: 4-4.6
8 T 10/15
Fall Break. No Class.
R 10/17
Constraints, Triggers
T: 7
9 T 10/22
Indices, Materialized Views
T: 8
R 10/24
Project Iteration Presentation
10 T 10/29
R 10/31
Lab Exam
11 T 11/5
SQLite, a shining light
in Software Engineering
Distributed Databases
noSQL Databases
R 11/7
SQLite, a shining light
in Software Engineering
Distributed Databases
noSQL Databases
T: 20-20.4.3, 20.5.2
12 T 11/12
Big Data, Google Search Engine
R 11/14
Google Big Table, HBase
Cap Reading TBD
13 T 11/19
Project Iteration Presentation
R 11/21
14 T 11/26
R 11/28
Happy Thanksgiving! No class.
15 T 12/3
R 12/5
Project Presentations

*Tentative schedule, subject to change. Check Moodle for the most up to date information.

**No travel arrangements should be made until the final exam schedule has been issued


Additional Information

(back up↑)Additional Information

SM&RT (SMART) Advisor: Advisors in the Sexual Misconduct & Resource Training Program, formerly SASH, seek to prevent sexual and gender based violence and harassment. They also provide services to those who have suffered from such violence or harassment. I am an SMART Advisor, and am available through appointment to assist you or your friends if you experience sexual misconduct.

Respect for classmates, colleagues and team members: All students are expected to show respect and courtesy to each other. Mutual respect is a high ideal in academic, business, and personal life. It is central to learning well together. Disagreements over ideas or constructive criticism of someone’s work is in keeping with this ideal. Attacking or disparaging someone is not, and will not be tolerated. In group projects, mutual respect also includes reliably contributing to the project and keeping your commitments to the group.

We follow the College Diversity Statement which says in part:

All members of the College community share a responsibility for creating, maintaining, and developing a learning environment in which difference is valued, equity is sought, and inclusiveness is practiced.

To learn more about how these principles are followed in the computing industry, view the Google video:

Diversity at Google (https://youtu.be/_3RoQRN65AI)

and the eBay video:

Diversity Workshop at eBay, Europe (https://player.vimeo.com/video/159767606)

Privacy: Moodle contains student information that is protected by the Family Educational Right to Privacy Act (FERPA). Disclosure to unauthorized parties violates federal privacy laws. Courses using Moodle will make student information visible to other students in this class. Please remember that this information is protected by these federal privacy laws and must not be shared with anyone outside the class. Questions can be referred to the Registrar’s Office.

Equal Access: In compliance with Lafayette College policy and equal access laws, I am available to discuss appropriate academic accommodations that you may require as a student with a disability. Requests for academic accommodations need to be made during the first two weeks of the semester, except for unusual circumstances, so arrangements can be made. Students must register with the Office of the Dean of the College for disability verification and for determination of reasonable academic accommodations.

Important Dates:

  • Normal Add/Drop deadline: September 6th
  • Last day to Withdraw (WD): November 12th
  • Classes end: December 6th
  • Final Exams: December 10th – 17th

Federal credit hour statement: The student work in this course is in full compliance with the federal definition of a four credit hour course. Please see the Registrars Office Website (http://registrar.lafayette.edu/additional-resources/cep-course-proposal/) for the full policy and practice statement.

Credits: Logos Copyright © PostgreSQL, Apache HBASE, mongoDB, Amazon Dynamo, and Amazon Web Services respectively. Photo of Database Systems: The Complete Book Textbook Copyright © Pearson.