2 Introduction
As part of our MIS 4163 class, we are going to work in a project that will prepare a system design for the application we select. Our team, the Purple Pirates, is a team composed of 5 people. We have selected to put together the design for a service order and invoicing application for an auto repair business. We have named our project ARS which stands for Auto Repair System.
JMC Auto Repair is the business we selected for our project. It is a small family business without a sophisticated computer system. Even though they have a personal computer they do not have an application to process their service orders or manage customer information.
We are going to design an application data base (DB) for a service orders and invoicing system that will simplify the administrative processes, and it will keep basic customer information as well as information of the services rendered and parts used. With this information at hand, they will be able to offer future services to their customers.
3 Vision
Our vision is to develop a design of an auto service and invoicing application. This solution will provide a quote that could be converted to a work order. The work order could be updated as the work is being performed and once complete, it will generate an invoice. The application will allow for the storing of customer information for future studies. We will use Microsoft Access (MS) data access management system (DBMS) to act as the application hub for the JMC Auto
Riordan Manufacturing is a multi location multi million dollar company that is looking to take advantage of a piece of software that is a state of the art sophisticated information system. Riordan would like to integrate its old information and use it to implement the new system and just have one system take care of everything. Since the corporation already has a similar system in place, this technology should be easily done with the new system. This new system should be very cost efficient and the process
This way the IT department can understand what the higher level and lower level employees need for system stability and a better graphical interface. Another plan of action would include the method of Systems Development Life Cycle or SDLC. The phases of this method are planning, analysis, system design, implementation and operation. First we must plan on what exactly we are trying to accomplish. We know we need to upgrade the Riordan Manufacturing system. Next we must analyze the system and look for problematic errors. A project proposal can be essential to launching a system analysis (Farah, 2013). These are things to keep in mind: understand the business situation or problem, understand the significance to the problem in the organization, think of alternate solutions, the use of computer information systems for solutions, find people interested in the solving the problem (Farah, 2013). This plan is used to decrease redundancies, errors, and increase security. Finding all the weak spots in the company will help in the improvement of integrating an updated efficiently functioning system. Feasibility is important to account for when upgrading the system. Integrating a CRM will help to work with customers and understand their needs and wants to benefit the company and the relationship with their customers. Designing the system will involve knowing what kind of software is needed to store and
From the above comparison between two solutions (Plan A and B), the cost effectiveness of both solutions is similar. Two solutions development difficulty all is same. In the future, the new system is a scalable, reliable and robust system more suitable. Security issue is very important on the system. The password authentication technology can provide accuracy verification. Web-base service order system can automatic response the customers’ general request. Database centralization can integrate the current and the new systems. The system would computerize and would reduce the handworks. For the reasons of system efficient, consistence and reliability, Plan A should be a better solution for developing the
With Microsoft Access I have created a database. The Database has been made to help staff and Equest systems to carry out then business sales operations effectively and efficiently. The Database which I have created is a computer based Database; it is produced for EQuest System. In this Database you can discover that I have made it easy so it user friendly. Firstly I have created tables; the first table which I have created is a customer table. In this table there is information
A system is an organized structure that has inputs and outputs that carry out a specific activity. A system is a group of components that makes up a complex functioning unit. When an element changes, the system will stop functioning right. Once the system has been defined by jurisdiction, budget, coverage requirements and user needs, the next step is to design the system using components and systems that are obtainable and have the desired features that the customer and the design engineer have agreed upon. If the design engineer is not careful, then there will be coverage, operational, maintenance and reliability issues that will plague the system forever. The equipment-engineering phase will specify each and every component in the system, (Wiesenfeld, 2010). Due to a problem or situation, there is a beginning and an end to a system that is tasked to solve that problem.
Iain’s & Co. are a large building company that currently employ a team of IT technicians to help them manage their IT infrastructure and their IT users. They recently have taken over a similar small company that employs technical staff in the same way. Iain’s & Co. feel that they need a centralised IT support system that will monitor, track and report problems that have been identified by their IT users across both sites. Iain’s & Co. have hired me as their Systems Analyst to provide them better solutions to manage their IT Supports system.
New applications will utilize off-the-shelf software components that have been customized per Riordan’s specifications and further messaged to ensure that each application will integrate smoothly with all the others in order to create a single cohesive whole. Great effort will be made to ensure that the data structures used in each are consistent in order to simplify the creation of the enterprise’s database. To help facilitate this, we will create an umbrella application that will integrate each other system as a module. This umbrella application will be extendable as needed and will act as a single-launch point for the various systems utilized by Riordan. We will also be working closely with Riordan’s IT department to develop a bridge that will enable them to easily port their existing databases into the new one automatically.
An order processing system will be trap the order information from the customer service or straight away get it from customers. The data will be stored in a central database and the order information will be send to the accounting and shipping departments. The order processing system will be generate the tracking data based on the orders and inventory for every step of the way. Order processing system is very useful in any company especially those retailer or supply chain company. This system can help to ensure that all of the customers’ orders are filled on time. Since it is an automatically systems thus it can reduce errors while order is processing. By using this system, it can create a win-win situation between their business and their customers. It will enhance customers’ experience with more reliable deliveries and zero mistakes order fulfillment. For the business side, it can maximize the profit of the company with all the accurate orders, not to mention about the long-term revenue boost that comes from consistently satisfying
After all the information is obtained, analysts will review, analyze and structure the information obtained so they can develop an overall understanding of the new system’s requirements. To define the new system requirements; drawing diagrams, workflow diagrams and activity diagrams will be used to express and model the new system’s processing requirements. Last, the IT team selects and recommends an alternative to Riordan Manufacturing. The recommendation recaps the results of the analysis phase activities, and together the team makes firm decisions about an alternative.
3. Use Part 3 of the case study in Appendix B, Topic B, named ABC Financials Product Database to identify which aspects of this project – scope, time or cost – are the most important to upper management, potential users of the new system, and technical project staff, respectively. Then discuss the tradeoffs that can be made. Be prepared
A car repair workshop is a car owner's best friend. Even people who have knowledge in fixing their own cars have at least once in their life visited a vehicle repair shop to have a check on their car engines. But what should motor vehicle owners look for when they need a reliable car repair workshop that could handle any problems with their car engines that they would encounter?
When designing any new system special considerations, guidelines, and specification should be taken into consideration. It is best practice that as many people as possible participate in the project, adding some sort of
Here I want to discuss what is System analysis and design, when and where the concepts are used and how to overcome the problems using these concepts. The methodology of using characterizing the parts, structural engineering, interfaces and information for a framework to fulfil the decided necessities is said as system design. This course is helpful in developing the designing and analysing skills. Overall, system analysis and design is said as analysing and designing the different process.
System development can generally be thought of having two major components: systems analysis and systems design. In System Analysis more emphasis is given to understanding the details of an existing system or a proposed one and then deciding whether the proposed system is desirable or not and whether the existing system needs improvements. Thus, system analysis is the process of investigating a system, identifying problems, and using the information to recommend improvements to the system. System design is the process of planning a new business system or one to replace or complement an existing system.
Use this section to identify the design documents that have been developed and summarizes the overall solution design in a succinct statement. Also, define why each of these design documents is necessary for the project.