Difference between revisions of "IS480 Team wiki: 2012T1 Bumblebee Project Documentation"
m (→Manage Result) |
m (→Bootstrap Data) |
||
Line 56: | Line 56: | ||
|- | |- | ||
| style= "background:#000000; color: #ffffff; padding: 10px 4px 0 15px; width: 20%; font-size: 13px;" valign="top" | <b>Brief Description</b> | | style= "background:#000000; color: #ffffff; padding: 10px 4px 0 15px; width: 20%; font-size: 13px;" valign="top" | <b>Brief Description</b> | ||
− | | style= "background:#ffffff; color: #000000; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" |User can import | + | | style= "background:#ffffff; color: #000000; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" |User can import flight_arrival_schedule.csv/txt, flight_departure_schedule.csv/txt, flight_requirements.csv/txt, staff_record.csv/txt and staff_roster.csv/txt. System will store information in database. |
|- | |- | ||
| style= "background:#000000; color: #ffffff; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" |<b>Flow of Events</b> | | style= "background:#000000; color: #ffffff; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" |<b>Flow of Events</b> | ||
− | | style= "background:#ffffff; color: #000000; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" | 1) User | + | | style= "background:#ffffff; color: #000000; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" | 1) User selects “Browse” and selects targeted file - flight_arrival_schedule.csv/txt, flight_departure_schedule.csv/txt, flight_requirements.csv/txt, staff_record.csv/txt and staff_roster.csv/txt. |
− | 2) User | + | 2) User selects “Bootstrap” button. |
− | 3) System will load the data from the | + | 3) System will load the data from the csv or txt files into corresponding tables in the database. |
4) System will direct user to “Manage Simulation Parameters” page. | 4) System will direct user to “Manage Simulation Parameters” page. | ||
Line 70: | Line 70: | ||
|- | |- | ||
| style= "background:#000000; color: #ffffff; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" |<b>Alternate Flows</b> | | style= "background:#000000; color: #ffffff; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" |<b>Alternate Flows</b> | ||
− | | style= "background:#ffffff; color: #000000; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" | | + | | style= "background:#ffffff; color: #000000; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" | NA |
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| style= "background:#000000; color: #ffffff; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" |<b>Special Requirements</b> | | style= "background:#000000; color: #ffffff; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" |<b>Special Requirements</b> | ||
− | | style= "background:#ffffff; color: #000000; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" | User must select the right csv | + | | style= "background:#ffffff; color: #000000; padding: 10px 4px 0 15px; font-size: 13px;" valign="top" | User must select the right csv/txt files with the right formats. |
− | |||
− | |||
Data format is ignored if irrelevant | Data format is ignored if irrelevant | ||
− | |||
'''Flight Schedule Format - Departure''' | '''Flight Schedule Format - Departure''' | ||
Line 136: | Line 129: | ||
Column Y: Rem. DEP Daily | Column Y: Rem. DEP Daily | ||
− | |||
'''Flight Schedule Format - Arrival''' | '''Flight Schedule Format - Arrival''' | ||
Line 188: | Line 180: | ||
Column X: Rem. ARR Daily | Column X: Rem. ARR Daily | ||
+ | '''Flight Requirements Format''' | ||
− | ''' | + | '''Gate Departure''' |
Column A: Airline (Text) | Column A: Airline (Text) | ||
− | Column B: | + | Column B: Aircraft Type (Text) |
+ | |||
+ | Column C: CSO at Gate (Number) | ||
− | Column | + | Column D: CSA at Gate (Number) |
− | Column | + | Column E: Gate Opening Hours (Number) |
− | + | '''Counter Departure''' | |
− | Column | + | Column G: Airline (Text) |
− | Column | + | Column H: No of Narrow Aircraft (Number) |
+ | Column I: No of Wide Aircraft (Number) | ||
+ | |||
+ | Column J: CSO at Counter (Number) | ||
+ | |||
+ | Column K: CSO at Counter (Number) | ||
+ | |||
+ | Column L: Counter Opening Hours(Number) | ||
+ | |||
+ | '''Gate Arrival''' | ||
+ | |||
+ | Column N: Airline (Text) | ||
+ | |||
+ | Column O: CSO at Gate (Number) | ||
+ | |||
+ | Column P: CSO at Gate (Number) | ||
'''Staff Record Format''' | '''Staff Record Format''' | ||
Line 214: | Line 224: | ||
Column C: STF NO. (Text) | Column C: STF NO. (Text) | ||
− | Column D: | + | Column D: NA |
− | Column E: | + | Column E: NA |
Column F: DOJ (d-mmm-yy) | Column F: DOJ (d-mmm-yy) | ||
Line 271: | Line 281: | ||
Column AB: Kriscom - SQ (Text) | Column AB: Kriscom - SQ (Text) | ||
− | |||
'''Staff Roster Format''' | '''Staff Roster Format''' | ||
Line 281: | Line 290: | ||
Column C: RosterCycle (Text) | Column C: RosterCycle (Text) | ||
− | Column D: Mon (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd | + | Column D: Mon (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text) |
− | Start Time – End Time) (Text) | ||
− | Column E: Tue (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd | + | Column E: Tue (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text) |
− | Start Time – End Time) (Text) | ||
Column F: Wed (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text) | Column F: Wed (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text) | ||
Line 296: | Line 303: | ||
Column J: Sun (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text) | Column J: Sun (Normal shift - Row [2]: Start Time, Row [3]: End Time, Split Shift – Row[2]: 1st Start Time – End Time, Row[3] 2nd Start Time – End Time) (Text) | ||
− | |||
|- | |- |
Revision as of 14:41, 9 August 2012
Home | Project Overview | Project Documentation | Project Management | Learning and Growth |
Diagrams | User Interface | User Manual | User Acceptance Test | Meeting Minutes | Presentations |
Use Case
Use Case |
|
Use Case Description
Use Case Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Bootstrap Data
Manage Airline Requirements
Manage Simulation Paramaters
Simulate Staff Deployment
Manage Result
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sequence Diagram
Sequence Diagram |
Bootstrap DataManage Airline RequirementsManage Simulation ParametersSimulate Staff DeploymentManage Result |
ER Diagram
ER Diagram |
|
Logical Diagram
Logical Diagram |