Changes between Version 8 and Version 9 of P6


Ignore:
Timestamp:
05/13/26 21:04:06 (13 days ago)
Author:
193284
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • P6

    v8 v9  
    33== Overview ==
    44
    5 This phase demonstrates how the Wedding Planner database can be used for advanced reporting, analytical queries, stored procedures, and relational algebra representation.
     5In this phase we demonstrate how to extract, analyze and summarize data from the Wedding Planner database using advanced SQL.
    66
    7 The goal of this phase is to show that the database is not used only for storing data, but also for extracting meaningful information such as financial summaries, guest statistics, venue utilization, RSVP conversion rates, and overall wedding performance.
     7We focus on generating complex reports across multiple related tables, and implementing reusable logic through stored procedures and views.
    88
    9 == What We Cover ==
     9These techniques are important because in a real system the database is not used only for storing data, but also for producing meaningful insights such as guest statistics, financial reports, venue utilization analysis, RSVP conversion analysis, and operational summaries.
    1010
    11 * Complex SQL reports across multiple related tables
    12 * Stored procedures for reusable reporting logic
    13 * Relational algebra representation of the reports
    14 * Aggregation, grouping, filtering, and calculated fields
    15 * Financial, operational, and RSVP-based analysis
    16 * Performance considerations for complex reports
     11== Phase Structure ==
    1712
    18 == Report Scenarios ==
     13This phase is divided into the following analytical scenarios:
    1914
    2015|| Scenario || Description ||
    21 || [[P6BudgetReport|Budget vs Actual Expenditure Analysis]] || Compares planned wedding budget with actual vendor costs ||
    22 || [[P6VenueCapacityReport|Venue Capacity Utilization Analysis]] || Analyzes guest attendance compared to venue capacity ||
    23 || [[P6RSVPConversionReport|Event RSVP Conversion Rate Analysis]] || Measures RSVP response rates and attendance conversion ||
    24 || [[P6SynthesisAndPerformance|Synthesis and Performance Considerations]] || Combines analytical dimensions and explains optimization strategies ||
     16|| [[P6BudgetAnalysis|Scenario 1: Budget vs Actual Expenditure Analysis]] || Financial analysis of wedding budgets and actual vendor costs ||
     17|| [[P6VenueCapacity|Scenario 2: Venue Capacity Utilization Analysis]] || Analysis of venue occupancy and attendance metrics ||
     18|| [[P6RSVPConversion|Scenario 3: Event RSVP Conversion Rate Analysis]] || RSVP response and attendance conversion analysis ||
     19|| [[P6SynthesisPerformance|Synthesis and Performance Considerations]] || Integrated analytical query and optimization strategies ||
     20
     21== Technologies and Concepts Used ==
     22
     23* Advanced SQL queries
     24* Aggregate functions
     25* Multi-table joins
     26* Relational algebra expressions
     27* PostgreSQL stored procedures
     28* Temporary tables
     29* Analytical reporting
     30* Performance optimization strategies
    2531
    2632== Summary ==
    2733
    28 Phase 6 introduces advanced database reporting for the Wedding Planner Management System.
     34The reports implemented in this phase demonstrate how relational databases can be used not only for transactional processing, but also for analytical and reporting purposes.
    2935
    30 The implemented reports use multi-table joins, aggregate functions, conditional aggregation, temporal calculations, stored procedures, and relational algebra expressions.
    31 
    32 These reports help analyze wedding costs, venue usage, RSVP efficiency, and overall event planning performance.
     36The generated reports provide insights into financial planning, attendance analysis, RSVP effectiveness, and overall wedding management efficiency.