Management System: Design Document
Table of Contents -
Revision History
1. Introduction
2. Requirements
3. Architecture
4. Database / Data Access Design
5. GUI Design
6. Class Diagram
7. Sequence Diagrams
8. Test Plan
Acknowledgements
Introduction -
XYZZY Software has been approached by CQU to develop a system to assist unit coordinators in the management of marks. The system will be initially trialled for COIT20258 and a phased implementation strategy will be adopted. This document reflects the current state of the design for the Phase 2system.
Requirements -
Because of the simplicity of the user requirements, the corresponding use cases are not duplicated here, as would be the case in a normal XYZZY design document.
The purpose of the system is to assist a course coordinator in the management of student results. A Java desktop application is to be developed, driven by a simple Swing GUI. Interaction between the database and the application is to be via JDBC. The NetBeans IDE is to be used for development. Java DB must be used as the database.
The Phase 1 user requirements were as follows:
1. Start the application and connect to the database. If a connection cannot be established, the application must exit.
2. Close the database connection and stop the application
3. Display all records
4. Display the record for a specified student
5. Display all records where the total mark is within a specified range
6. Update the exam mark and total mark for a specified student.
7. Clear the display
In addition, it was decided that the architecture of the application was to conform to MVP (Model View Presenter).
For Phase 2, it has been decided to change the architecture to conform to MVC (Model View Controller). Also, browsing of query results is to be provided, as is the provision of a grade calculation capability. Thus, thefunctional requirements are as follows:
1. Start the application and connect to the database. If a connection cannot be established, the application must exit.
2. Close the database connection and stop the application
3. Display all records
4. Display the record for a specified student
5. Display all records where the total mark is within a specified range
6. Update the exam mark and total mark for a specified student.
7. Clear the display
8. Browse query results
9. Calculate grades for all students
As with the Phase 1 design, a class diagram is provided in Section 6 which must be followed.
The database design and sample data are provided in Section 4. 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.
Attachment:- Assignment File.rar