OVERVIEW David Wong and Kiran Sidhu are business partners and the current owners of a relatively young new car dealership in Surrey called Excellence New Cars. Excellence has grown quickly from a small car sales only dealership to a company which provides new car sales and service, financing solutions and parts sales. Currently they do not have a pre-owned sales department, but they will soon expand into this business as well. The dealership has four main departments as described above: new car sales, service, parts sales, and new car financing. Each departinent has a manager as well as staff, and there is a dealership general manager as well. There are six sales representatives, four service advisers and six technicians, two parts sales reps, three financing agents, as well as a number of support staff. With the success of their Surrey dealership, David and Kiran are now considering opening another dealership in David and Kiran recently decided that the infonmation system provided by the car manufacturer (which shall remain nameless for this project, but it could be an Asian car manufacturer...) is not perfectly suited to their needs. They would like you to build a custom information system to support its business needs. The new system would replace a mix of paper-based and digital systems. The business partners have asked you to design an information system that would support the dealership's current operations and future growth. In your first meeting, Kiran provided an overview of the dealership's business processes and staff members. She identified the managers within the dealership: Rohit Dhaliwal is general manager, Frank Johnson is new car sales manager, Wendy Hanyu is service manager, Janu Richards is parts manager, and Lynn Chan is financing manager. Stuart Young is office manager for the dealership. Stuart's employees include Hannah Zhou and Parm Sidhu, who look after human resources and payroll. Tim Brown, Olivia Wong and Emma O'Brien report to Stuart looking after salaries, benefits and employment details for the dealership's staff. The sales department has six sales reps: Harjit Sandhu, Karnveer Singh, Phil Wright, Brenda Dong. Jane Edmundsen and Alan Koenig. The service department has four service advisors who set up service appointments and deal with customers who are having their cars serviced. The advisors are Lindsay Carter, Ricky Sherwani, Jason Pruett and Kim Connor. The parts department has two sales reps, Sara Jamshidi and Vicki Ng, who take in-person and over-the-phone orders. The finance agents are Bill Picardo, Nancy Tan, and Gurjit Manhas