1.5. Data processing
A subsection of Information Technology, 9626, through 1. Data processing and information
Listing 10 of 36 questions
A manager wants to code the data about clothes sold in a shop, ready for storing in a database. The table shows the manager’s first attempt. Category Data Colour Light green (G), Black (B), Dark green (G), Red (R) Type of clothing Shirt (S), Skirt (S), Trousers (T), Pullover (P) Size 25 – 30 (S), 31 – 36 (L), 37 – 42 (XL), 43 – 48 (XXL) Brand Astio (A), Dasiap (D), Utap (U), Gumho (G) Give three different reasons why the manager wants the data coded. Give three different drawbacks of coding the data as shown in the table. Describe two different improvements which could be made to this coding system.
9626_s21_qp_12
THEORY
2021
Paper 1, Variant 2
View
Coding of data, such as G for green and B for blue, has some advantages and disadvantages. Tick the most accurate statement regarding an advantage of coding data in this way. ü Data can become more difficult to interpret. All codes are easy to forget. It never leads to the coarsening of data. Coding of data means time is saved when entering data. Tick the most accurate statement regarding a disadvantage of coding data in this way. ü Codes cannot be used in a flat file database. More mistakes are made when entering data. It is possible to run out of meaningful code combinations. It is more difficult to use validation rules with the data. A shirt manufacturer uses codes to store information about its shirts. For example, a blue shirt with a neck of 40 cm and a chest of 98 cm could be coded as B4098. Explain what each part of the code P4395 could mean and why there may be problems with coding shirts in this way. Include in your explanation ways of improving this coding method. Other methods are used to convert data. These include encryption and the use of codecs. Analyse the effectiveness of these two methods.
9626_w21_qp_13
THEORY
2021
Paper 1, Variant 3
View
Questions Discovered
36