• 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. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    * Long term reimbursements infotype (0590) * Nominations infotype (0591) 1.7 POSTING TO ACCOUNTING Purpose Reporting for posting payroll results to Accounting, otherwise known as posting to Accounting, is a subsequent activity that is carried out after a successful payroll run. It usually takes place for each payroll period.

  2. Computing Project

    TButton; CBTitle: TComboBox; Label2: TLabel; LblEdPostCode: TMaskEdit; Label4: TLabel; LbledTelno: TMaskEdit; Label3: TLabel; procedure Button1Click(Sender: TObject); procedure BtnExitClick(Sender: TObject); procedure BtnNewMemberClick(Sender: TObject); private { Private declarations } public { Public declarations } end; var FmRegAMem: TFmRegAMem; memberid:integer; implementation uses Umenu; {$R *.dfm} procedure TFmRegAMem.BtnExitClick(Sender: TObject); begin Close; end; procedure TFmRegAMem.BtnNewMemberClick(Sender: TObject); begin if (cbtitle.Text='')

  1. Video Club Database Project

    OK 3 Click on 'Delete' command button. Must be able to delete a record. OK 4 Click on 'Back to Main Menu' command button. Main Menu must appear on the screen. OK SECTION 4 SYSTEM MAINTENANCE 1. SYSTEM OVERVIEW This Customer information system is designed to keep records of Customer profiles and their past purchases.

  2. GCSE I.T Security Case Study - Riverside Leisure Centre

    This controls, although doesn't block altogether, the threat of viruses and unauthorised access to the data. However, such a program does have one main disadvantage Anti-virus Software Surprisingly, Riverside's systems are not yet equipped with anti-virus software. This would be a good investment as a good quality program such as

  1. Barilla SpA - Case Report

    Costs may not be reduced - if organized distributor (DO) decreased stock, Barilla would have to increase own inventory by changing rigid production schedule As Giorgio Maggiali, we would deal with these concerns as follows: 1. JITD is a selling tool -not a threat to sales.

  2. Today's competitive global business environment, understanding and managing enterprise wide information is crucial for ...

    They are scaleable to full data warehouses and at times are summarized subsets of more detailed, pre-existing data warehouses. 1.2.4. Metadata/Information Catalogue: Metadata describes the data that is contained in the data warehouse (e.g. Data elements and business-oriented description) as well as the source of that data and the transformations

  1. Different ways of data capture

    WYSIWYG 'What you see is what you get' displays exactly on screen what you will get when text is printed. SPREADSHEETS These create worksheets representing data in columns/rows form. Used for numerical data e.g budgets, cashflow forecast, profit/loss statements, experimental results.

  2. Tod's Tyres is a small business that supplies new car tyres to company car ...

    design including output, forms and reports In this particular exercise, I have created each form and report by using wizards, supplied through the software used. Form design of "cardtbl"... Report design of "invoice"... Method of data entry, including validation I intend to enter data through the forms created from the

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