A supermarket stocks tins of beans in 3 different sizes, from 4 different manufa

Question

A supermarket stocks tins of beans in 3 different sizes, from 4 different
manufacturers, and in 3 different varieties (plain; with sausages; with
vegetarian sausages). Every combination of size, manufacturer and
variety is possible. How many bits of information are needed to
represent the type of a tin of beans in the supermarket’s database?
Assume that the supermarket’s database contains several terabytes of
data. Would the database be held in primary, secondary or tertiary
storage? What kind of storage device would be most appropriate for
this database? Justify your answers.

Explanation / Answer

Answer)

The number of bits needed varies as per the data type.

Assuming the type of tn of beans in the supermarket are of varchar type. This would need the varied size and a maximum of 4000 bytes are possible for SQL database.

Incase if it would have been a character then it would have used 1 byte or 8 bits of information space to have stored.

The storage would depend on the type of information and rate of information being fetched. If the information is being fetched on a frequent basis then it would be the secondary memory where as if it would information is not being fetched frequently but rarely then it would take the tertiary storage.

Hope this answer helps. Happy to help. :)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.