Changes between Version 6 and Version 7 of P7
- Timestamp:
- 05/12/26 01:55:41 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
P7
v6 v7 16 16 The advanced database objects are implemented on top of the normalized relational schema developed in Phase P2 and validated through the prototype application in Phase P4. 17 17 18 Technical Environment 18 == Technical Environment == 19 19 20 20 || Component || Technology || … … 25 25 || Character Encoding || UTF-8 || 26 26 27 Objectives 27 == Objectives == 28 28 29 29 * enforce advanced business rules directly inside the database … … 46 46 || Trigger Functions || 4 || 47 47 || Triggers || 4 || 48 || SQL Functions || 4||48 || SQL Functions || 3 || 49 49 || Procedures || 1 || 50 50 || SQL Views || 4 || 51 51 || Additional Constraints || Multiple || 52 52 53 SQL Scripts 53 == SQL Scripts == 54 54 55 55 || Script Name || Description || … … 77 77 This section contains example SQL testing scenarios used to validate the advanced database functionality. 78 78 79 Summary 79 == Summary == 80 80 81 81 This phase successfully introduced advanced PostgreSQL database functionality into the Wedding Planner Management System. … … 85 85 The advanced SQL functionality improves data consistency, reduces application-level complexity, and supports analytical reporting for wedding management operations. 86 86 87 Additional Notes 87 == Additional Notes == 88 88 89 89 * All trigger functions are implemented using PL/pgSQL.
