Changes between Version 5 and Version 6 of ProjectPhases
- Timestamp:
- 11/08/25 17:43:16 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ProjectPhases
v5 v6 9 9 == Phase P0: Project Definition 10 10 11 Describe the project vision and initial data requirements as part of usage scenarios. See: [[InstructionsP0]] 11 Describe the project vision and initial data requirements as part of usage scenarios. 12 13 See: [[InstructionsP0]] 12 14 13 15 == Phase P1: Conceptual Model (ERD) 14 16 15 Create a detailed model of the data requirements as an Entity-Relationship Model with extensive documentation. See: [[InstructionsP1]] 17 Create a detailed model of the data requirements as an Entity-Relationship Model with extensive documentation. 18 19 See: [[InstructionsP1]] 16 20 17 21 == Phase P2: Logical and Physical Design, DB Creation (DDL) 18 22 19 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 23 Implement the database structure from P1 as a relational database schema in a faculty assigned PostgreSQL database, using SQL DDL and DML scripts. 24 25 See: InstructionsP2 20 26 21 27 == Phase P3: Application Scenarios for DB Access (SQL) 22 28 23 Increase the level of detail in the usage scenarios with specific database access queries. See: InstructionsP3 29 Increase the level of detail in the usage scenarios with specific database access queries. 30 31 See: InstructionsP3 24 32 25 33 == Phase P4: First Application Prototype 26 34 27 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 35 Create a prototype application that demonstrates how can some of the usage scenarios be implemented, using programming language and technology of your choice. 36 37 See: InstructionsP4 28 38 29 39 == Milestone M1: First Prototype Public presentation 30 40 31 * Present the initial version of an application prototype. See: InstructionsM1 32 41 * Present the initial version of an application prototype. 33 42 * Deadline: January 2026 34 43 35 44 Present the build prototype to your peers, and discuss possible improvements. 36 45 46 See: InstructionsM1 47 37 48 == Phase P5: Normalization 38 49 39 Check the database model using formal methods and improve the model to fix typical problems of un-normalized designs. See: InstructionsP5 50 Check the database model using formal methods and improve the model to fix typical problems of un-normalized designs. 51 52 See: InstructionsP5 40 53 41 54 == Phase P6: Complex DB Reports (SQL, Stored Procedures) 42 55 43 Implement more complex analytical, trend and aggregate data reports using pure SQL and/or store procedures/functions. See: InstructionsP6 56 Implement more complex analytical, trend and aggregate data reports using pure SQL and/or store procedures/functions. 57 58 See: InstructionsP6 44 59 45 60 == Phase P7: Advanced Database Development (SQL DDL) 46 61 47 Implement data constraints, triggers, stored procedures and functions, views. See: InstructionsP7 62 Implement data constraints, triggers, stored procedures and functions, views. 63 64 See: InstructionsP7 48 65 49 66 == Phase P8: Advanced Application Development 50 67 51 Implement transactions in the application prototype for usage scenarios that would require transactions. See: InstructionsP8 68 Implement transactions in the application prototype for usage scenarios that would require transactions. 69 70 See: InstructionsP8 52 71 53 72 == Phase P9: Other developments 54 73 55 Performance analysis of complex queries. Security and protections. Other topics (propose for approval). See: InstructionsP9 74 Performance analysis of complex queries. Security and protections. Other topics (propose for approval). 75 76 See: InstructionsP9 56 77 57 78 == Milestone M2: Presentation of the final version of the project 58 79 59 * Present the finished project and documentation. See: InstructionsM2 80 * Present the finished project and documentation. 81 * Deadlines: 82 * Deadline: 01.02.2026 to get a grade in January/February exam session. 83 * Deadline: 15.06.2026 to get a grade in June exam session. 84 * Deadline: 01.09.2026 to get a grade in August/September exam session. 60 85 61 * Deadline: 01.02.2026 to get a grade in January/February exam session.62 * Deadline: 15.06.2026 to get a grade in June exam session.63 * Deadline: 01.09.2026 to get a grade in August/September exam session.64
