Enter text here

Enter text here

1. The problem with incorrect data on stock levels is that is can lead to having too much which can be a waste.

2. The problem with incorrect employee data is that this could lead to an employee being paid too much or too less that what they originally worked for.

3. Validation

   • This is to check whether the information is sensible and reasonable to use.
   • Length check, type check etc.

4. Verification

   • This is used to ensure that data matches with the original source.
   • Proofreading check, double entry check etc.

5. A database is when all your data is gathered and organised in one place

6. A database query is when we are able to extract and sort information from the database.

7. Extracting: this can be performed by choosing specific fields and using filters to select data that meet specific criteria

8. Sorting: can organise data by any retrieved field in ascending or descending order.

9. Numerical modelling is where mathematical calculations are used to simulate a real-life system.

10. Data modelling is a process used to plan the structure of a database to ensure that data is stored in the most organised and efficient manner.

11. Tabular presentation is a text presentation of data within a table.

    • This is used where precise data and detail is required.

12. Graphical presentation is where data is presented using a chart or some other form of diagram.

    • This is used where ease of interpretation and spotting trends is required.