Changes between Version 6 and Version 7 of P7


Ignore:
Timestamp:
05/12/26 01:55:41 (2 weeks ago)
Author:
193284
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • P7

    v6 v7  
    1616The 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.
    1717
    18 Technical Environment
     18== Technical Environment ==
    1919
    2020|| Component || Technology ||
     
    2525|| Character Encoding || UTF-8 ||
    2626
    27 Objectives
     27== Objectives ==
    2828
    2929* enforce advanced business rules directly inside the database
     
    4646|| Trigger Functions || 4 ||
    4747|| Triggers || 4 ||
    48 || SQL Functions || 4 ||
     48|| SQL Functions || 3 ||
    4949|| Procedures || 1 ||
    5050|| SQL Views || 4 ||
    5151|| Additional Constraints || Multiple ||
    5252
    53 SQL Scripts
     53== SQL Scripts ==
    5454
    5555|| Script Name || Description ||
     
    7777This section contains example SQL testing scenarios used to validate the advanced database functionality.
    7878
    79 Summary
     79== Summary ==
    8080
    8181This phase successfully introduced advanced PostgreSQL database functionality into the Wedding Planner Management System.
     
    8585The advanced SQL functionality improves data consistency, reduces application-level complexity, and supports analytical reporting for wedding management operations.
    8686
    87 Additional Notes
     87== Additional Notes ==
    8888
    8989* All trigger functions are implemented using PL/pgSQL.