Changes between Version 11 and Version 12 of ConceptualModel


Ignore:
Timestamp:
09/25/25 10:39:51 (3 weeks ago)
Author:
221514
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ConceptualModel

    v11 v12  
    5656   * **Partial Key**: `trip_id` - An artificial ID of a trip.
    5757   * **Attributes**:
     58     * **base_price**: The base price for the trip, since the tickets are created only upon trip booking, the ticket has to infer the price from somewhere where the user sees this information.
    5859     * **status**: The state of the trip (e.g., `completed`, `cancelled`, `in progress`).
    5960     * **date**: Scheduled date for the trip.
     
    7172   * **Primary Key**: `ticket_id` - An artificial ID for the ticket.
    7273   * **Attributes**:
    73      * **price**: The base price for the ticket.
     74     * **price**: The base price for the ticket, which is inferred from the trip later on.
    7475     * **date_purchased**: The date the ticket was purchased.
    7576     * **seat**: Derived attribute (calculated as `capacity - free_seats`).