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