CINF 201 - 01, Fall 2016 — Database Systems

MWF 2:30-3:20p Eliz Hall 205 — Pre-reqs: CSCI 111Q or 142 or 261.

This course introduces relational SQL databases and so-called NoSQL databases, with an emphasis on the former. Students will learn how to create, read, update, and delete data with SQL queries and how to design databases so that they are efficient and secure. Our focus will be on practical techniques that can be immediately applied outside of the classroom.

About me


You will not need a textbook.


Late homework is penalized 20% for each day that it is late. Submissions more than 3 days late receive no credit. Quizzes cannot be made up unless a doctor’s note is provided.


The plan is that every Friday will be a demo/work day. We will start with demonstrations (you are required to give two demos during the semester) and then proceed to work on the current homework or group project. Attendance is required for these days to ensure that every student is engaged with the material and making progress on assignments.

The grading rubric for attendance is as follows, out of 3 points:


Homework is assigned weekly until the group project starts. Most assignments have a corresponding test script that you can use to check your solution and I use to assist my grading.

The grading rubric for homework is as follows, out of 3 points:


You are required to give a 5 minute presentation on two separate occassions about some new, interesting tool or technique relevant the class as a whole. Your demos will be added to the cookbooks that are available from this site.

The grading rubric for demos is as follows, out of 3 points:

“Novel” means creative and new. A not-novel demo includes simple variations of prior demos. Note, however, that presenting the same tool/technique as someone else will receive no credit.


During some, but not all, weeks during the semester, an online quiz will be given. The quiz will always take place on a Wednesday. The quiz will occur in class but must be taken on Blackboard during the class time. The quizzes will be short, requiring approximately 5-10 minutes to complete. They will always have 5 questions.

The grading rubric for quizzes is as follows, out of 3 points:

Group project

In the last four weeks of the course, every student will be working on a group project. Groups will have 2-5 people, mostly grouped by interests. You will (as a group) decide your project goals. Your goals must include building a database, with a graphical user interface, to meet the needs of some real or imagined client.

Exact requirements for group projects will be determined when the projects begin, and may depend somewhat on the goals of each project. Grades for the group project will be determined primarily on whether or not your group meets its goals by Finals Week. 20% of your group project grade will be determined by an average of your team members’ and your own ratings of your performance. These ratings will be private and anonymous. Your grade will be decided according to the following general scheme:

Group projects are due at the time of the final exam (there is no final exam): Thur Dec 15, 9-11am. Your attendance on that day is required so we can all view each other’s group projects.


Homework due dates:

Honor code

I am strongly in agreement with the Stetson University Honor Code. Any form of cheating is not acceptable, will not be tolerated, and could lead to dismissal from the University.

Academic success center

If a student anticipates barriers related to the format or requirements of a course, she or he should meet with the course instructor to discuss ways to ensure full participation. If disability-related accommodations are necessary, please register with the Academic Success Center (822-7127; www.stetson.edu/asc) and notify the course instructor of your eligibility for reasonable accommodations. The student, course instructor, and the Academic Success Center will plan how best to coordinate accommodations. The Academic Success Center is located at 209 E Bert Fish Drive, and can be contacted using the email address asc@stetson.edu.

CINF 201 material by Joshua Eckroth is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License. Source code for this website available at GitHub.