Database application project (period III)
| Year | Semester | Date | Period | Language | In charge |
|---|---|---|---|---|---|
| 2013 | spring | 14.01-22.02. | 3-3 | Finnish | Harri Laine |
Aloitusluento 14.01. MA 16-18 D122.
Non finnish students contact Harri Laine (laine@cs.helsinki.fi).
General
The course is carried out as a personal or duo project
There are no lectures in addition to the starting meeting. Instruction for the project work is available in personal instruction sessions (appointments should be made for about 15 minutes sessions) and in computer classes. Instruction in computer classes is provided at the times defined for the instruction groups. No appointments are required and any group may be attended. There may be also common sessions. One common session is the demo session on which students present their applications to other students.
Students may register for the course only once as a first timer. If she/he does not pass the course he/she may apply right to retry by registering in the queue.
This course is available in all periods.
Completing the course
To pass the course you must do a project work that consists of two parts:
- design and
- implementation.
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 the project work that was started on some previous course affect the grade.
A requirement and design document.should be prepared in the beginning of the 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.
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.
Literature and material
-
Instructions on documents
Intruction are partly in English -
Web application
This material contains some general information about web-applications, web forms and form sequences, server programs and parameter passing to server programs -
Using SQL in application programs
This material describes how databases are used in application programs, especially using jdbc interface. - Lecture notes on database programming in Java
-
Instructions on databases and their user accounts
This material contains technical instruction on the use of databases in our local environment -
Servlet instructions
This material contains information how java servlest are used in implementing server progrms and how they are used in the local environment -
Using ant in controlling the compilations
Short instruction (currently in Finnish but will be translated) and example on the use of ant
Instruction and examples in Finnish
PHP
- Material on PHP may be found for example from the course Tecniques on Digital Media
- PHP pages in CS department's environment
- PHP examples (in Finnish) (old server environment is not valid anymore)
- A gift list example (in Finnish)