The EasyDrive School of Motoring was established in Glasgow in 1992. Since then, the school has grown steadily and now has several offices in most of the main cities of Scotland. However, the school is now so large that more and more administrative staff are being employed to cope with the ever-increasing amount of paperwork. Furthermore, the communication and sharing of information between offices, even in the same city, is poor. The Director of the school, Dave MacLeod, feels that too many mistakes are being made and that the success of the school will be short-lived if he does not do something to remedy the situation. He has assigned this project to you to develop a database system to support the day-to-day operation of the school. In addition, he would like part of the system to be open to their customers, so that customers can perform booking and inquiry functions online, without the need for administrative support. Initial estimates suggest a budget of HK$2.6 million for the project. Of the budget, $800,000 is for the software, and $500,000 for hardware costs. The rest is for consulting and development services. The annual maintenance would be 15% of the hardware cost, and 10% of the software costs. You estimate that the benefits resulting from this project are mainly savings in administrative costs of HK$500,000 for year 1, HK$800,000 for year 2, and HK$1,000,000 for year 3, and HK$1,200,000 for year 4 to 5. 2. Assuming that you are the project manager of this database system development project for EasyDrive School of Motoring.

a. Create a Work Breakdown Structure (WBS) by Phase for this project. Break down the tasks to level 2 or 3 as appropriate. There is no fixed answer for this. A good answer should be: o Complete the project is finished when all the tasks are executed;

o Comprehensive includes all the necessary tasks for the project in sufficient levels of details.

b. Develop a Gantt chart using ProjectLibre for the WBS created in (a) above.

Phase 1: Planning and Analysis

Define project objectives and scope

dentify stakeholders and project team

Conduct feasibility study

Develop project plan and schedule

Define project requirements

Conduct risk assessment and management plan

Obtain approval for project plan

Phase 2: Design

Develop database schema and data models

Design user interface and user experience

Develop system architecture and components

Define system requirements

Obtain approval for design

Phase 3: Development

Develop and implement database system

Develop and implement web portal for customers

Develop and implement administrative functions

Test system functionality

Obtain approval for development

Phase 4: Deployment

Install and configure system components

Migrate data to new system

Train staff and customers on system usage

Conduct user acceptance testing

Obtain approval for deployment

Phase 5: Maintenance and Support

Provide ongoing system maintenance and support

Monitor system performance and usage

Identify and resolve system issues

Update system components and functionality as needed

Provide customer support and training as needed

b. Develop a Gantt chart using ProjectLibre for the WBS created in (a) above. Imagine and answer with a reasonable respective durations, dependencies, and start/end dates for the Gantt chart. It would also include milestones for each phase and the overall project completion.