Microsoft Word - ABS2-Design 1 | P a g e Airline Booking System Phase 2: Design Document Version 1.0 XYZZY Software May, 2018 2 | P a g e Table of Contents Revision History...

please check attached file.


Microsoft Word - ABS2-Design 1 | P a g e Airline Booking System Phase 2: Design Document Version 1.0 XYZZY Software May, 2018 2 | P a g e Table of Contents Revision History ....................................................................................... Error! Bookmark not defined. 1. Introduction .................................................................................................................................... 3 2. Requirements .................................................................................................................................. 4 3. Architecture .................................................................................................................................... 5 4. Database / Data Access Design ....................................................................................................... 6 5. GUI Design ....................................................................................................................................... 7 6. Class Diagram ................................................................................................................................ 11 7. Sequence Diagrams ....................................................................................................................... 13 8. Test Plan ........................................................................................................................................ 14 Acknowledgements ............................................................................................................................... 15 3 | P a g e 1. Introduction XYZZY Software is contracted to develop a reservation system for a very small and exclusive airline. The system is to be developed using Java Technologies (NetBeans, Java DB) and a phased implementation strategy will be adopted. This document represents the current state of the design for the Phase 2 system. 4 | P a g e 2. Requirements Because of the simplicity of the functional requirements, the corresponding use cases are not duplicated here. The purpose of the system is to assist staff in the management of reservations. In this regard, note that the airline is unusual in that it only operates two flights per day – one from Canberra to Melbourne and the other from Melbourne to Canberra. Because of the quality of the in-flight dining, business is thriving and in order to retain its exclusivity, the owners have no immediate intention of adding more flights or destinations. The reservation system is to be implemented as a Java desktop application that employs a simple Swing GUI and Java DB database. Interaction between the database and the application is to be via JDBC. The NetBeans IDE is to be used for development. The functional requirements for the Phase 1 system were as follows: 1. Start the application and connect to the database 2. Close the database connection and stop the application 3. Display all reservations 4. Display all reservations for which the number of passengers is within a specified range 5. Display the total number of passengers who have booked for a particular flight 6. Add a reservation to the database if sufficient seating is available 7. Clear all fields in the GUI 8. For commands that return reservation records (ie requirements 3 and 4) the records are to be browsable via previous and next buttons, as detailed in Section 5. Furthermore, the display of browsable records is to be realised using the MVC (Model View Controller) pattern. Any output associated with requirements 5 and 6 will be initiated by the controller (using the MVP pattern) and not by the model. Refer to the class diagram of Figure 6 for clarification. Note that “presenter” functionality is provided by the ReservationsController class. Your application must conform to Figure 6, although you are free to add additional private members and methods. The database design and sample data are provided in Section 4. Note that dates are represented (both in the database and in the application) as text strings. Data validation is not required at this stage. However, basic preconditions must be satisfied for each requirement and if these are not satisfied, an appropriate message is to be displayed. These preconditions are specified in Section 8. 5 | P a g e 3. Architecture A three-layered architecture will be employed in Phase 2, consisting of view, controller and model layers. Given the simplicity of the architecture, an architecture diagram is not provided. Layers are to be modelled as packages – the package structure for the application is illustrated in Figure 1. Figure 1. Package structure 6 | P a g e 4. Database / Data Access Design Flight capacity (20 passengers) is to be hardcoded into the ReservationQueries class. The remaining