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

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

Phase P1: Conceptual Model (ERD)

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

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

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

Phase P3: Application Scenarios for DB Access (SQL)

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

Phase P4: First Application Prototype

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

Milestone M1: First Prototype Public presentation

• Present the initial version of an application prototype. See: InstructionsM1

• Deadline: January 2026

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

Phase P5: Normalization

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

Phase P6: Complex DB Reports (SQL, Stored Procedures)

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

Phase P7: Advanced Database Development (SQL DDL)

Implement data constraints, triggers, stored procedures and functions, views. See: InstructionsP7

Phase P8: Advanced Application Development

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

Phase P9: Other developments

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

Milestone M2: Presentation of the final version of the project

• Present the finished project and documentation. See: InstructionsM2

• 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.