Project Phases

Project work is done in phases and iterations. Each phase/iteration has to be presented to the teacher during consultations and has to be approved before continuation with the following phases/iterations. If a phase/iteration is not done to a satisfactory level, the team will be instructed to improve their work and present once again for approval.

Each project phase, iteration and milestone lists the names of the pages that document the respective types of activities in each phase. Create wiki pages in your project site that correspond to these names. As an Example: to document the activity ProjectVision, create a wiki page named ProjectVision.

Phase P0: Project Definition - InstructionsP0

Describe the project vision and initial data requirements as part of usage scenarios.

Phase P1: Conceptual Model (ERD) - InstructionsP1

Create a detailed model of the data requirements as an Entity-Relationship Model with extensive documentation.

Phase P2: Logical and Physical Design, DB Creation (DDL) - InstructionsP2

Implement the database structure from P1 as a relational database schema in a faculty assigned PostgreSQL database, using SQL DDL and DML scripts.

Phase P3: Application Scenarios for DB Access (SQL) - InstructionsP3

Increase the level of detail in the usage scenarios with specific database access queries.

Phase P4: First Application Prototype - InstructionsP5

Create a prototype application that demonstrates how can some of the usage scenarios be implemented, using programming language and technology of your choice.

Milestone M1: First Prototype Public presentation

• Deadline: January 2026

Present the build prototype to your peers, and discuss possible improvements.

Phase P5: Normalization - InstructionsP5

Check the database model using formal methods and improve the model to fix typical problems of un-normalized designs.

Phase P6: Complex DB Reports (SQL) - InstructionsP6

Implement more complex analytical, trend and aggregate data reports using pure SQL and/or store procedures/functions.

Phase P7: Advanced Database Development - InstructionsP7

Implement data constraints, triggers, stored procedures and functions, views.

Phase P8: Advanced Application Development - InstructionsP8

Implement transactions in the application prototype for usage scenarios that would require transactions.

Phase P9: Other developments - InstructionsP9

Performance analysis of complex queries. Security and protections. Other topics (propose for approval).

Milestone M2: Presentation of the final version of the project

• Deadline: 01.02.2026 to get a grade in January/February exam session.
• Deadline: 15.06.2026 to get a grade in June exam session.
• Deadline: 01.09.2026 to get a grade in August/September exam session.