Changes between Version 6 and Version 7 of ProjectPhases
- Timestamp:
- 12/03/25 10:57:59 (4 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ProjectPhases
v6 v7 23 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 24 25 See: InstructionsP225 See: [[InstructionsP2]] 26 26 27 27 == Phase P3: Application Scenarios for DB Access (SQL) … … 29 29 Increase the level of detail in the usage scenarios with specific database access queries. 30 30 31 See: InstructionsP331 See: [[InstructionsP3]] 32 32 33 33 == Phase P4: First Application Prototype … … 35 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 36 37 See: InstructionsP437 See: [[InstructionsP4]] 38 38 39 39 == Milestone M1: First Prototype Public presentation … … 44 44 Present the build prototype to your peers, and discuss possible improvements. 45 45 46 See: InstructionsM146 See: [[InstructionsM1]] 47 47 48 48 == Phase P5: Normalization … … 50 50 Check the database model using formal methods and improve the model to fix typical problems of un-normalized designs. 51 51 52 See: InstructionsP552 See: [[InstructionsP5]] 53 53 54 == Phase P6: Complex DB Reports (SQL, Stored Procedures)54 == Phase P6: Complex DB Queries (SQL, Stored Procedures) 55 55 56 56 Implement more complex analytical, trend and aggregate data reports using pure SQL and/or store procedures/functions. 57 57 58 See: InstructionsP658 See: [[InstructionsP6]] 59 59 60 60 == Phase P7: Advanced Database Development (SQL DDL) 61 61 62 Implement data constraints, triggers, stored procedures and functions, views. 62 Implement data constraints, triggers, stored procedures and functions, views. 63 63 64 See: InstructionsP764 See: [[InstructionsP7]] 65 65 66 == Phase P8: Advanced Application Development 66 == Phase P8: Advanced Application Development (Transactions) 67 67 68 Implement transactions in the application prototype for usage scenarios that would require transactions. 68 * Implement transactions in the application prototype for usage scenarios that would require transactions. 69 * Implement database connection pooling 69 70 70 See: InstructionsP871 See: [[InstructionsP8]] 71 72 72 == Phase P9: Other developments73 == Phase P9: Other topics 73 74 74 Performance analysis of complex queries. Security and protections. Other topics (propose for approval). 75 * Performance analysis of complex queries, indexes. 76 * Data security and protections. 77 * Other topics (propose for approval). 75 78 76 See: InstructionsP979 See: [[InstructionsP9]] 77 80 78 81 == Milestone M2: Presentation of the final version of the project … … 84 87 * Deadline: 01.09.2026 to get a grade in August/September exam session. 85 88 89 See: [[InstructionsM2]]
