Acme Garage

The purpose of this report is to analyze the current structure of the system used by Acme Garage to maintain the stock, purchase, vendor and transaction details and provide the updated structure with new proposed solution. This new solution can help Acme Garage to implement a single point of contact for all kind of transaction instead of using manual books for maintain job details and access database for customer and vendor details. Acme Garage is using Job books to maintain the details for certain job with all parts details that are used in the job with the customer linked to this. Maintaining the historical data of these kind of job books is not easy. Maintaining the excel for stock is not a good idea with orders in a filing cabinet. We have provided the report with the details which are presented below:   Acme Garage is a car repair company that have 2 major section administrative and mechanics section. Kim is working in office and maintain all order, jobs, customer and stock data in different form i.e. database, excel and manual copies. Bill and ben works as mechanics in the garage and record the job data on paper with the parts used in job and labor charges. Key issues of the current system are as below: The current system is used by Kim who have understanding of computer as she used excel to maintain stock and customer and vendor access database to create, retrieve and update ,delete the data. It is easier to create the application that can use the existing customer and supplier data in backend and create new tables to store rest of data. In this we have provided the present system that will get used by Kim who will have complete understanding the PC as they will get used the excel sheet for maintaining the client and stock and access the vendor the database for accessing for deleting, updating, retrieving and creating.  Ã‚   After analyze the current system it observed that stock management process should be automate and customer and supplier database should be in a single database. Order data also be integrate with this system. Based on the new proposed system below are the ER Diagram, class diagram and DFD   Below is the class diagram which was created with the help of tables that were used in this project: Below is the updated DFD which was created with the new details of the class diagram and we have provided the relationship also:   Below is the modeling for the data that is based on the diagram of the ER and we have provided the relationship among both of them: As per the new proposed system I have identified below tables with their primary and foreign keys. Below I have provided all the table names and their data types with the foreign and primary keys:   Acme Garage needs to implement a new system to manage all transactions related to customer, supplier and job. Based on the requirements below are the functional and Non-functional requirements. Programming prerequisites determination sets up the premise for an understanding amongst clients and contractual workers or suppliers (in business sector driven undertakings, these parts might be played by the promoting and advancement divisions) on what the product item is to do and in addition what it is not anticipated that would do. Programming prerequisites particular allows a thorough appraisal of necessities before outline can start and lessens later overhaul. It ought to likewise give a reasonable premise to evaluating item costs, dangers, and calendars Functional Requirements: Most necessities definition concentrates for the most part on practical prerequisites, which are based upon the normal working of the item or framework to be made. Working regularly is compared with item/framework highlights for which you may have a menu or catch decision, for example, recognize a client, select a thing to arrange, and compute the sum due. Non-functional Requirements: Nonfunctional necessities allude to an entire slew (I've distinguished more than 30) of qualities including execution levels, security, and the different "ilities, for example, convenience, dependability, and accessibility. Constantly, prerequisites definers get wrapped up in how the item/framework is relied upon to work and dismiss these additional components. In the above we have provided both the requirements that are non-functional and functional those are used in the system.   The proposed business solution have captured the information of customer, supplier and JOB. The new system is designed in such a way that it would be able to cater below functions from UI. Below we have provided the details of the UI that can be used for the solution of the proposed business and also the reports that are used in the UI so that we will have all the details at one place.  Ã‚   The new system required some cost to be implement below is the cost calculations Total time required to implement is about 500 hours at a rate of 120$ so final cost will be 60000$. Project is viable as the cost can be recovered within a years’ time so that the project will delivered successful. Here, we have explained the feasibility and also the cost and time that are needed for the execution of the project. By looking at that we will have all the details which will used in the project.   This project can be implemented in 2 modes I choose to prefer 2 nd option to implement the solution so that KIM can access the system from anywhere and also customer and suppliers can also be access the system and setting the data and making and receiving the payment from online system. We have described about both the 2 modes in the above which can be used in the project. Further maintenance is required for the above proposed solution as this system runs over internet so below could be the maintenance requirements Acme is using manual data entry in excels and paper work with some data in database so chances of mistakes can be higher and duplicating the data is another major concerns. This new system help them in getting the correct and real time view of stock and help them in generating more revenue and interacting with suppliers and customer on daily basis. So, here we have provided the revised DFD and all the updated tables with their primary keys and types of data so that we can distinguish between older and new version. Looking for an answer 'who will do my essay for cheap',