Changes between Version 7 and Version 8 of P7

Timestamp:

05/12/26 02:09:03 (2 weeks ago)

Author:

193284

Comment:

--

P7

@@ -53 +53 @@
 == SQL Scripts ==
 
+This section contains the SQL script files used during the implementation of the advanced database development phase.
+
+The scripts are separated by functionality in order to improve organization, readability, maintenance, and deployment of the database objects.
+
 || Script Name || Description ||
-|| advanced_triggers.sql || Contains trigger functions and trigger definitions for booking validation and attendance consistency ||
-|| advanced_functions.sql || Contains reusable SQL functions and stored procedures for calculations and reporting ||
-|| advanced_views.sql || Contains analytical SQL views used for financial and operational summaries ||
-|| advanced_constraints.sql || Contains additional CHECK and UNIQUE constraints ||
-|| advanced_testing.sql || Contains SQL testing scenarios for validating triggers and constraints ||
+|| [[Media:advanced_triggers.sql|advanced_triggers.sql]] || Contains trigger functions and trigger definitions for booking validation and attendance consistency ||
+|| [[Media:advanced_functions.sql|advanced_functions.sql]] || Contains reusable SQL functions and stored procedures for calculations and reporting ||
+|| [[Media:advanced_views.sql|advanced_views.sql]] || Contains analytical SQL views used for financial and operational summaries ||
+|| [[Media:advanced_constraints.sql|advanced_constraints.sql]] || Contains additional CHECK and UNIQUE constraints ||
+|| [[Media:advanced_testing.sql|advanced_testing.sql]] || Contains SQL testing scenarios for validating triggers and constraints ||
+
+Additional Notes
+
+* All SQL scripts are compatible with PostgreSQL 15.
+* The scripts are intended to be executed using pgAdmin 4 or PostgreSQL command-line tools.
+* SQL files are organized by database functionality for easier maintenance and testing.
 
 == Contents ==