The following is a code for one product in an extensive cosmetic line: L02002Z621289. L means that it is a lipstick, 0 means it was introduced without matching nail polish, 2002 is a sequence code indicating in what order it was produced, Z is a classification code indicating that the product is hypoallergenic, and 621289 is the number of the plant (there are 15 plants) where the product is produced.

a. Critique the code by listing the features that might lead to inaccurate data entry.
b. Designer Brian d’Arcy James owns the cosmetic firm that uses this coding scheme. Always interested in new design, Brian is willing to look at a more elegant code that encodes the same information in a better way. Redesign the coding scheme and provide a key for your work.
c. Write a sentence for each change you have suggested, indicating what data entry problem (from Problem 5a) the change will eliminate.
d. Mr. d’Arcy James is delighted with your work. He says the firm would like to hire you to help them branch out into selling theatrical makeup (shows such as Wicked and Shrek with eight performances a week use a lot of green greasepaint). Add any necessary new codes for the coding scheme you suggested in b above, and provide a key for your work.


a. It is too long to input correctly.
b. One possible solution is:

One character for product line
One character for matching product: Y for yes, N for no
Four digits for production sequence
One character for product classification
Two characters and two digits for plant code:

N E: northeast region S E: southeast region
M W: mid-west region S W: southwest region
E S: east region N W: northwest region
W S: west region

Two digits for plant number: 01, 02, 03…

c. The data entry problems will be solved by not having confusing codes and by having good editing criteria for each field.

d. Students will come up with a variety of examples. One code might be:

G Y1234Z12

G for grease paint
Y for matching product (might have hair color or lipstick)
1234, four digit sequence number
Z (hypoallergenic)
12 (plant number 12)

Computer Science & Information Technology

You might also like to view...

When writing an algorithm in a natural language it is helpful to use ________ instead of ________.

a. programming language, natural language b. nouns, pronouns c. abbreviations, actual words d. nouns, adjectives

Computer Science & Information Technology

In the IA-32 architecture, a(n) ________ occurs when a process has attempted to access memory outside of its segment.

a) page fault b) general protection fault exception c) segment-overflow exception d) TLB miss

Computer Science & Information Technology

It's a good idea to exaggerate your experience on a professional networking site so that you can land a better job.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

A(n) ________ field is a predefined list of values.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology