Changes between Version 1 and Version 2 of UseCase0005


Ignore:
Timestamp:
09/02/26 17:56:22 (4 days ago)
Author:
236024
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UseCase0005

    v1 v2  
    1 = UC0005 - Create Event Edition and Programme =
     1= UC0005 - Create Event Edition and Event Functions =
    22
    33'''Initiating actor:''' Board Member
    44
    5 A Board Member creates an event edition and defines its main data. The scenario creates Job Fair 2027 with locations, function slots, and programme sessions.
     5A Board Member creates an event edition, adds its locations, and defines event functions. In this scenario, the Board Member is acting as the President.
    66
    77== Scenario ==
    88
    9 1. The Board Member opens the event administration page.
     91. The Board Member opens the create event edition page.
    1010
    11 2. The application lists event types.
     112. The application lists event types and locations.
    1212
    1313{{{#!sql
    14 SELECT
    15     et_name,
    16     et_description
     14SELECT et_id, et_name
    1715FROM event_types
    1816ORDER BY et_name;
     17
     18SELECT l_id, l_name
     19FROM locations
     20ORDER BY l_name;
    1921}}}
    2022
    21 3. The Board Member enters the event edition data.
     233. The Board Member enters Job Fair 2027 with the selected event type and dates.
    2224
    23254. The application stores the event edition.
    … …  
    2527{{{#!sql
    2628INSERT INTO event_editions (
    27     et_name,
    28     event_title,
    29     event_start_time,
    30     event_end_time
    31 )
    32 VALUES (
    33     'Job Fair',
     29    ee_id,
     30    et_id,
     31    ee_title,
     32    ee_start_time,
     33    ee_end_time
     34) VALUES (
     35    1001,
     36    2,
    3437    'Job Fair 2027',
    3538    TIMESTAMP '2027-03-22 09:00:00',
    … …  
    3841}}}
    3942
    40 5. The Board Member enters the event locations.
    41 
    42 6. The application stores the event locations.
     435. The application stores the event edition locations.
    4344
    4445{{{#!sql
    45 INSERT INTO event_edition_locations (
    46     et_name,
    47     event_title,
    48     event_start_time,
    49     location
    50 )
    51 VALUES
    52     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'INNOFEIT'),
    53     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'FEEIT'),
    54     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'MFS');
     46INSERT INTO event_edition_locations (ee_id, l_id) VALUES
     47    (1001, 12),
     48    (1001, 13),
     49    (1001, 14);
    5550}}}
    5651
    57 7. The Board Member enters the planned event function slots.
    58 
    59 8. The application stores the event function slots.
     526. The application stores the event function slots.
    6053
    6154{{{#!sql
    62 INSERT INTO core_team_functions (
    63     et_name,
    64     event_title,
    65     event_start_time,
    66     function_name
    67 )
    68 VALUES
    69     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Main Organiser 1'),
    70     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Main Organiser 2'),
    71     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Corporate Relations Responsible 1'),
    72     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Corporate Relations Responsible 2'),
    73     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Logistics Responsible'),
    74     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'PR Responsible'),
    75     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'FR Responsible'),
    76     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'IT Responsible'),
    77     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00', 'Design Responsible');
     55INSERT INTO event_functions (ee_id, ef_no, ef_name) VALUES
     56    (1001, 1, 'Main Organiser 1'),
     57    (1001, 2, 'Main Organiser 2'),
     58    (1001, 3, 'Corporate Relations Responsible 1'),
     59    (1001, 4, 'Corporate Relations Responsible 2'),
     60    (1001, 5, 'Logistics Responsible'),
     61    (1001, 6, 'PR Responsible'),
     62    (1001, 7, 'FR Responsible'),
     63    (1001, 8, 'IT Responsible'),
     64    (1001, 9, 'Design Responsible');
    7865}}}
    7966
    80 9. The Board Member enters programme sessions.
    81 
    82 10. The application stores the programme sessions.
    83 
    84 {{{#!sql
    85 INSERT INTO event_sessions (
    86     et_name,
    87     event_title,
    88     event_start_time,
    89     est_name,
    90     es_start_time,
    91     location,
    92     es_title
    93 )
    94 VALUES
    95     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00',
    96      'Official Opening', TIMESTAMP '2027-03-22 10:00:00', 'INNOFEIT', 'Job Fair Opening Ceremony'),
    97     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00',
    98      'Company Stands', TIMESTAMP '2027-03-23 10:00:00', 'FEEIT', 'Technical Companies Stands'),
    99     ('Job Fair', 'Job Fair 2027', TIMESTAMP '2027-03-22 09:00:00',
    100      'Company Stands', TIMESTAMP '2027-03-23 10:00:00', 'MFS', 'Engineering Companies Stands');
    101 }}}
    102 
    103 11. The application shows the programme for Job Fair 2027.
     677. The application shows the created event edition, locations, and event functions.
    10468
    10569{{{#!sql
    10670SELECT
    107     es.est_name,
    108     es.es_start_time,
    109     es.location,
    110     es.es_title
    111 FROM event_sessions es
    112 WHERE es.et_name = 'Job Fair'
    113   AND es.event_title = 'Job Fair 2027'
    114   AND es.event_start_time = TIMESTAMP '2027-03-22 09:00:00'
    115 ORDER BY es.es_start_time, es.location, es.est_name;
     71    ee.ee_id,
     72    et.et_name,
     73    ee.ee_title,
     74    ee.ee_start_time,
     75    ee.ee_end_time
     76FROM event_editions ee
     77JOIN event_types et
     78    ON et.et_id = ee.et_id
     79WHERE ee.ee_id = 1001;
     80
     81SELECT
     82    l.l_id,
     83    l.l_name
     84FROM event_edition_locations eel
     85JOIN locations l
     86    ON l.l_id = eel.l_id
     87WHERE eel.ee_id = 1001
     88ORDER BY l.l_name;
     89
     90SELECT ef_no, ef_name
     91FROM event_functions
     92WHERE ee_id = 1001
     93ORDER BY ef_no;
    11694}}}
    117 
    118 12. The application shows the function slots for Job Fair 2027.
    119 
    120 {{{#!sql
    121 SELECT
    122     ctf.function_name
    123 FROM core_team_functions ctf
    124 WHERE ctf.et_name = 'Job Fair'
    125   AND ctf.event_title = 'Job Fair 2027'
    126   AND ctf.event_start_time = TIMESTAMP '2027-03-22 09:00:00'
    127 ORDER BY ctf.function_name;
    128 }}}