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.
Eliz Hall 214, 386-740-2519
Office hours: Mon/Wed 12-2:30
You will not need a textbook.
- Attendance on work/demo days (usually Fridays): 5%
- Demos (2 required, 5 min each): 10%
- Homeworks (12 of them): 40%
- Quizzes (in class, on Wednesdays): 15%
- Group project: 30%
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:
- attended at least 75% of work days: 3 pts
- attended at least 50% of work days: 2 pts
- attended at least 25% of work days: 1 pt
- attended fewer than 25% of work days: 0 pts
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:
- all tests pass (if tests are available) or solution meets all stated requirements: 3 pts
- at least 75% of tests pass or stated requirements are met: 2 pts
- at least 25% of tests pass or stated requirements are met: 1 pt
- no tests pass, no requirements met, or no submission: 0 pts
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:
- tool/technique is practical or interesting: +1 pt
- tool/technique is clearly presented: +1 pt
- tool/technique is novel: +1 pt
“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:
- 4 or 5 questions solved correctly: 3 pts
- 2 or 3 questions solved correctly: 2 pts
- 1 question solved correctly: 1 pt
- 0 questions sovled correctly or absent (did not take quiz): 0 pts
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:
- 80% of group project grade: how successfully your group met its goals
- 20% of group project grade: average of your group member’s individual private ratings of your performance
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.
- Week 1: SQL queries for creating, reading, updating, deleting data
- Week 2: graphical tools for accessing databases
- Week 3: Database table design, normalization
- Week 4: Joins
- Week 5: Indexes, performance analysis
- Week 6: Aggregation
- Week 7: Constraints, transactions
- Week 8: Views, triggers
- Week 9: Data import and export
- Week 10: Security, password storage
- Week 11: NoSQL databases
- Week 12: NoSQL databases
- Week 13: Group projects
- Week 14: Group projects
- Week 15: Group projects
- Week 16: Group projects (presentations)
Homework due dates:
- A01: NFL Play-by-play, due Aug 31, 11:59pm
- A02: Billboard Top 10, due Sep 7, 11:59pm
- A03: DeLand weather, due Sep 12, 11:59pm
- A04: Enron emails, due Sep 19, 11:59pm
- A05: Pokédex, due Sep 26, 11:59pm
- A06: IMDB indexes, due Oct 3, 11:59pm
- A07: Student loans, due Oct 17, 11:59pm
- A08: Registrar, due Oct 27, 11:59pm
- A09: Lahman's baseball db, due Nov 3, 11:59pm
- A10: Social network, due Nov 14, 11:59pm
- A12: Product reviews, due Nov 21, 11:59pm
- Demo days, due
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 firstname.lastname@example.org.