• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46

Definition-nature of the problem solved - Car Mechanic business

Extracts from this document...


Contents Contents 1 Definition-nature of the problem solved 3 Description of Business 3 Current Method Used 3 Data Flow of Current System 5 Inefficiencies and Problems 6 Origins and Forms of Data 7 Initial Problem Definition 7 Investigation and Analysis 8 Methods of Fact Finding 8 Interview Notes 9 4.6 Current Data Structures 11 4.7 Requirements Specification 12 Output requirements 12 4.8 Agreement to Requirements 14 4.9 Alternate Solutions 14 4.10 Limitations of Chosen Solution 16 Design 17 Nature of the Solution 17 5.1.1 Objectives 17 5.1.2 System Structure 18 Design of Forms 19 Design of Reports 22 Design of Mail Merged Letters 23 Design of Data Capture Forms 24 Relationships 24 ERD- Entity Relationship Diagram 24 TRD- Table Relationship Diagram 24 Table Designs 25 Query Designs 25 Data Dictionary 28 System Security 33 Data Security 34 Intended Benefits 34 Limits and scope 35 Time Line 36 Software Development 37 Input, Output and processing printouts 37 Queries 40 Data Structures 40 Definition-nature of the problem solved Description of Business * Willcare is an independent car mechanic business. The business located near the owner's home where there are a number garages available. It is a small service business promoted by the owner and has been running around 20 years. The owner may employ some workers for a specific job, but usually works alone on a variety of jobs. A separate outlet provides supplies when they are needed. * The main aim of the business is to provide an alternative for customers who don't like the treatment from there local dealerships. The owner feels that people would prefer a face-to-face meeting with him to discuss their problem and says he prefers talking to clients personally rather than through a system because it helps create trust. His business also aims to give an equal amount of customer satisfaction to all those using the business. Also, to make sure that the companies recognition grows, so that more people are aware of what it has to offer. ...read more.


This will be useful because it will allow quicker access when the user wants to use a different part of the system. Each customer's details will be filled in the shown boxes and various pieces of the information will be validated to make sure it is correct within the laws of the system. The most important aspect of this page will be the member ID. Each customer will be given a unique number that will be used to look him or her up through the system. The owner may feel, however that giving all his current customers a number for the system would alienate them and waste company time. Therefore I may only use member ID's for new customers and use a different look up method for existing customers e.g. their D.O.B. For the customers D.O.B entry I will use a combo box method so data input can be sped up. This form also includes a link to "Add a Job". This button will allow the user, once they have entered the details to go straight to the job form so they can choose what they want done and find out the estimated price. The post code is an important way to identify customers legitimately and will contain a validation making sure it is accurately filled in. During my interview with the company owner I learned he would require the system to produce an output in the form of a receipt. To quickly produce the receipt using a mail merge technique the produce a receipt button will create the receipt for the job currently recognised in the form entry. If this is not the required job for the customer, the user can search for a different one using the view customer job button. The maintenance menu includes a link to job prices and a supplier list. These are options that are likely to be scarcely used. ...read more.


This table allows the data from both of these tables to be stored together, with a one to many relationship leaving the table in both directions. This will be shown later in the Relationship Diagram. Here you can see both the Job ID and Part ID present both classified as numbers under the data type. The JobPartsID field now acts as an autonumber for this table so that the two pieces of data can be classified together. This will allow the production of receipts and other printouts to be faster and more accurate. Part_TBL This table follows the same patterns as the previous two in that the ID, in this case Part is the primary key and an auto number. The price field uses the data type currency. This will automatically fill the cell with a pound sign when data is entered. It will help in calculations within the database and provide quicker usage for the user when filling in forms. Supplier ID is present as well so that the user can see which supplier supplies them with a specific part. Supplier_TBL My final table contains information about the company's suppliers. The table contains a part name and part ID field that will link to the parts table. The data types remain similar to those in the previous tables to keep a constant style throughout the system. It helps to keep the system less complicated for the user and helps problems become apparent quickly. Field Name Description of Contents Type of Validation Expected Supplier ID Unique number to distinguish between suppliers. No duplicates. No number higher than those of listed suppliers. Supplier Name Name of supplier Required Part ID Number to classify a certain part No duplicates. Relationship Diagram Here are the five tables described above presented in their relationship format. There are only one to many relationships present because the Job Parts table has acted as a link table between the Job and Parts tables which were previously a many to many relationship. ?? ?? ?? ?? Simon Rubery TG2 Candidate Number-9145 I.CT Project 2516 Centre Number-20309 Page 1 of 46 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Marked by a teacher

    Designing a data system for a vintage clothes business.

    3 star(s)

    takes note of which stock sold out quicker She then fills out an order form via email to Haines(manufacturer) She asks for X amount of products Thirdly, updating website: Luki designs new product Gets manufacturer to show her what finish product will look like Luki then posts picture and short

  2. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    Then there is the project team. This team has to be composed of skilful members that form a stable union. An important issue is the empowerment of the project team. This means that the team (or one or more of his members) has to posses the power and possibility to make important decisions regarding the project

  1. Marked by a teacher

    The software that manages a database is called a Database Management System (DBMS). The ...

    3 star(s)

    A composite primary key is a combination of two or more columns that act as a unique identifier for a table. For example the library database has two tables with composite primary keys. One table, Incoming Books holds the data of the books which will be available in the library recently.

  2. Hardware and software ICT revision notes

    Some macro programs are produced using automated routines called wizards. You must learn: * the purpose of macros in applications software * reducing input errors * speeding up processing * standardising routine procedures All three of these save time by replacing often used sometimes lengthy series of keystrokes with shorter versions.

  1. Computing Project

    begin close; end; procedure TFmMenu.BtnRegAMemClick(Sender: TObject); begin FmRegAMem.show end; procedure TFmMenu.BtnRntDVDClick(Sender: TObject); begin FMRentOutaDVD.show end; procedure TFmMenu.BtnAddDVDClick(Sender: TObject); begin FmAddNewDvd.show end; procedure TFmMenu.BtnCreateReportClick(Sender: TObject); begin FmCreateAReport.show end; procedure TFmMenu.BtnReturnDvdClick(Sender: TObject); begin FmReturnedDvds.show end; procedure TFmMenu.BtnLoansOverdueClick(Sender: TObject); begin FmLoansOverdue.show; end; procedure TFmMenu.BtnLoginClick(Sender: TObject); begin fmlogin.show; end; procedure TFmMenu.BtnSetupUandPClick(Sender: TObject); begin fmsetupuserandpass.show; end; end.

  2. System Analysis The aim of the Jewellery store system is to make the work ...

    These various activities are called phases of the SDLC. Following are the different phases of the SDLC: 1. Problem Definition 2. Feasibility Study 3. System Analysis 4. System Design 5. Software Development 6. Testing 7. Implementation 8. Maintenance SDLC is also known as Classic Life Cycle Model, Linear Sequential Model or Water Fall Model.

  1. Principles of Software Design & Development - A system needs to be created which ...

    It adds item to the list after the button has been clicked. 3 Byte This will be responsible for Individual prices (nothing values more than 255)

  2. Future Developments in ICT

    Soon we could see these mammoths replaced by smaller, single Quantum computers, capable of accelerating specific calculations by an order of magnitude. By encoding information in more than just two states (0 and 1) through the alteration of an electrons spin, many qubits can be generated, and these can exist

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work