Changes between Initial Version and Version 1 of ProjectPhases

Timestamp:

11/04/25 12:37:54 (27 hours ago)

Author:

vangel.ajanovski

Comment:

--

ProjectPhases

@@ +1 @@
+= 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.
+