Database Application Project
5
Software Systems
Intermediate studies
Kurssilla perehdytään tietokantaohjelmointiin ja yksinkertaisten web-sovellusten rakenteisiin sekä web-sovelluksen toteutukseen. Kurssilla harjoitellaan tietokantasuunnittelua sekä tietokannan pystytystä ja hyväksikäyttöä. Kurssin jälkeen opiskelija tuntee joitakin tietokanta- ja web-ohjelmoinnin tekniikkoja ja osaa laatia yksinkertaisia web-sovelluksia. Kurssin pääosan muodostaa harjoitustyö. Esitiedot: Tietokantojen perusteet ja Ohjelmistotekniikan menetelmät (Ohjelmistojen mallintaminen).
Lectures
| Time | Room | Lecturer | Date |
|---|---|---|---|
| Tue 16-18 | B222 | Harri Laine | 07.09.2010-07.09.2010 |
Exercise groups
| Time | Room | Instructor | Date | Observe |
|---|---|---|---|---|
| Mon 14-18 | A318 | Sami Saada | 06.09.2010—15.10.2010 |
| Time | Room | Instructor | Date | Observe |
|---|---|---|---|---|
| Fri 16-20 | A318 | Sami Saada | 06.09.2010—15.10.2010 |
Aloitusluento (7.9.) on pakollinen!
Non finnish students contact Henning Lübbers (lubbers@cs.helsinki.fi) and Harri Laine (laine@cs.helsinki.fi).
General
This course consists of a project work: a small database application with a web user interface. The course has self-study material on database programming, usability, and web applications. The project work is instructed in weekly personal instruction sessions (15-20 min). The project work may be done in English.
Courses Introduction to Databases, Software Modelling, and Introduction to Programming or corresponding courses are required as prerequisites for this course.
Students that have interrupted the course before must register on the waiting list/ interrupters' queue when they want to retake the course. Note also that those who have registered for the course but have not cancelled their registration before the starting lecture will later be considered to have interrupted the course.
This course will in schedule in each period.
This course has a starting lecture in Finnish. Fon Finnish students should contact Henning Lübbers (lubbers@cs.helsinki.fi) and/or Harri Laine (laine@cs.helsinki.fi) before the start date.
Completing the course
To pass the course the student must do a project work that consists of two parts: design and implementation of a small web based data base application
Assessment of the project work is based on
- the functionality and usability of the implemented application, and
- the quality of the implementation and documentation.
Factors that lead to a low grade are, among other things,
- incomplete or incorrect functionalities (e.g., error checking is missing),
- shortcomings in usability,
- shortcomings in the database solution,
- shortcomings and inconsistencies in documentation,
- problems in the implementation, and
- low quality of the program code.
Continuing of an interrupted project work that you have started on some previous course is also a factor that leads to a lower grade.
During the first part of the course you will write a requirement and design document. It is a part of the whole documention of the project. You will get feedback about it, but it will not be graded separately, but together with the final document. Therefore, you have a possibility to make corrections to it based on the comments of your instructor and resubmit it together with the final documentation that also includes the technical document of the system.
The project includes presenting your work to the other members of your group, and attending the presentations of the other group members.
Literature and material
Web material:
- About web-applications> Database instructions
- Lecture notes on database programming in Java
- Using SQL in application programs
- Servlet instructions
Text book material
- Ramakrishnan & Gehrke: Database Management Systems (text book in Introduction to Databases course) has chapters on database programming (Chapter 6) and web applications (Chapter 7).