A study of designing and using a database management system (DBMS) and of developing
theory, techniques for supporting ACID properties, and frontiers in database research.
As part of a large team, students design and develop a system using both Web and mobile
front ends that interacts with a DBMS using SQL.
Upon completing this course, you will know how to:
- model and capture database design, queries, and entity relationships in SQL
- design and construct a well-designed Mobile application, using Android
- utilize a web framework to access a backend database
- describe the basic theory and algorithms underlying implementation of database management systems
It is the policy of Hendrix College to accommodate students with disabilities, pursuant
to federal and state law. Students should contact Julie Brown in the Office of Academic
Success (505.2954; email@example.com) to begin the accommodation process. Any student
seeking accommodation in relation to a recognized disability should inform the instructor
at the beginning of the course.
Please refer to the
CSCI Academic Integrity Policy.
Extensions and rescheduling for labs, projects, exams and quizzes are only given when
circumstances beyond your control (e.g. being sick, academic, choir or sports travel, etc)
prevent you from completing a project on time. You must notify me either by
email or phone of your circumstances well in advance of the due date.
You are expected to attend class and participate in discussions every day,
answering questions, asking questions,
presenting material, etc.
Active participation will
comprise 5% of your final grade. Repeated absences will have a significant impact on
your participation grade.
I have planned out a
TENTATIVE schedule for the course.
We will be using no textbook but instead supplemental material such as
relevant web-pages for the course.
Readings will be assigned before material will be covered in class. You are expected
to review the material and come to class prepared. As readings are assigned,
they will be posted here.
- Use Cases and User Stories
- Entity Relationship Modeling
Some of your experience with databases in this course will be through semi-weekly labs,
which will comprise 15% of your final grade.
- Lab 1: Who are you?
- Lab 2: ER Diagrams - Due Jan 26
- Lab 3: HTML and CSS - Due Feb 5
- Lab 4: SQL Schema and Queries - Due Feb 16
- Lab 6: Android Acronym Lookup with ListView - Due March 16
- Lab 7: Database Implementations - Due April 2
You will be assigned teams of three or four students and will be giving two presentations to the class as
described below. These presentations will account for 15% of your final grade.
For the bulk of this semester, you will be participating in teams of five or six to
develop a database, web application and/or mobile application
in coordination with a local non-profit organization.
Your final grade for this course will be based on the Labs, Presentations, Project, and
Participation described above.