Changes between Version 12 and Version 13 of ProjectPhases


Ignore:
Timestamp:
11/11/26 15:17:12 (8 days ago)
Author:
vangel.ajanovski
Comment:

—

Legend:

Unmodified
Added
Removed
Modified
  • ProjectPhases

    v12 v13  
    11= Project Phases
    22
    3 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.
     3== Method of work (in short)
     4
     5* **Project work is done in phases.**
     6* **Each phase has to be presented during consultations and has to be approved before continuation with the following phases.**
     7 * **You must document all the work within the phase** at your assigned project website, **before presenting the phase**. Failing to document will postpone the approval.
     8 * **Project phases are approved only during consultations.** Approval does not mean the work is finished nor that is correct, it means that your work is to a level that you are allowed to continue with the next phase.
     9 * **If a phase is not done to a satisfactory level,** the team will be instructed to improve their work and present once again for approval.
     10
     11== Starting a project
     12
     13See: [wiki:StartingProjects]
     14
     15== Documenting the work on your projects
     16
     17**Phase descriptions and requirements listed below and linked on the respective links are from the last year projects and will be revised with the latest requirements until November 22.**
    418
    519Each 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**.
    … …  
    923**Project phases P0-P4 are mandatory** and must be developed in the same order. **Project phases P5-P9 are elective** -- some of them can be skipped and you can work on them in any order, but it is recommended that you work on  P5 first. All phases contribute to your final points and grade. Phases P0-P4 alone are not sufficient to get a passing grade.
    1024
    11 == Phase P0: Project Definition
     25=== Phase P0: Project Definition
    1226
    1327Describe the project vision and initial data requirements as part of usage scenarios.
    … …  
    1529See: [[InstructionsP0]]
    1630
    17 == Phase P1: Conceptual Model (ERD)
     31=== Phase P1: Conceptual Model (ERD)
    1832
    1933Create a detailed model of the data requirements as an Entity-Relationship Model with extensive documentation.
    … …  
    2135See: [[InstructionsP1]]
    2236
    23 == Phase P2: Logical and Physical Design, DB Creation (DDL)
     37=== Phase P2: Logical and Physical Design, DB Creation (DDL)
    2438
    2539Implement the database structure from P1 as a relational database schema in a faculty assigned PostgreSQL database, using SQL DDL and DML scripts.
    … …  
    2741See: [[InstructionsP2]]
    2842
    29 == Phase P3: Application Scenarios for DB Access (SQL)
     43=== Phase P3: Application Scenarios for DB Access (SQL)
    3044
    3145Increase the level of detail in the usage scenarios with specific database access queries.
    … …  
    3347See: [[InstructionsP3]]
    3448
    35 == Phase P4: First Application Prototype
     49=== Phase P4: First Application Prototype
    3650
    3751Create a prototype application that demonstrates how can some of the usage scenarios be implemented, using programming language and technology of your choice.
    … …  
    3953See: [[InstructionsP4]]
    4054
    41 == Milestone M1: First Prototype Public presentation
     55=== Milestone M1: First Prototype Public presentation
    4256
    4357* Present the initial version of an application prototype.
    … …  
    4862Details on the presentations will be announced via course and personal announcements after the end of the lectures in January 2026.
    4963
    50 == Phase P5: Normalization
     64=== Phase P5: Normalization
    5165
    5266Check the database model using formal methods and improve the model to fix typical problems of un-normalized designs.
    … …  
    5468See: [[InstructionsP5]]
    5569
    56 == Phase P6: Complex DB Reports (SQL, Stored Procedures, Relational Algebra)
     70=== Phase P6: Complex DB Reports (SQL, Stored Procedures, Relational Algebra)
    5771
    5872Implement more complex analytical, trend and aggregate data reports using pure SQL and/or store procedures/functions.
    … …  
    6074See: [[InstructionsP6]]
    6175
    62 == Phase P7: Advanced Database Development (SQL DDL)
     76=== Phase P7: Advanced Database Development (SQL DDL)
    6377
    6478Implement data constraints, triggers, stored procedures and functions, views.
    … …  
    6680See: [[InstructionsP7]]
    6781
    68 == Phase P8: Advanced Application Development (Transactions, Pooling)
     82=== Phase P8: Advanced Application Development (Transactions, Pooling)
    6983
    7084* Implement transactions in the application prototype for usage scenarios that would require transactions.
    … …  
    7387See: [[InstructionsP8]]
    7488
    75 == Phase P9: Other topics (Performance, Security, ...)
     89=== Phase P9: Other topics (Performance, Security, ...)
    7690
    7791* Performance analysis of complex queries, indexes.
    … …  
    8195See: [[InstructionsP9]]
    8296
    83 == Milestone M2: Presentation of the final version of the project
     97=== Milestone M2: Presentation of the final version of the project
    8498
    8599* Present the finished project and documentation.