Warning: Undefined array key 1 in /home/acaproso/public_html/._System/._Template/.Main.php on line 112
Management of database information systems questions

Management of database information systems questions | form four Information and Computer Studies

Find Management of database information systems examination questions, form four Information and Computer Studies in acaproso.com

# Question
1

A mail order company selling plastic equipments keeps details of its stock on a database. Part of the database is shown in the following table.

Code_num Colour Speakers Power(W) No.Of CDs Price(Tshs)
13416 Black 450 4 650000
13425 Silver 260 1 500000
13504 Silver 480 5 750000
14001 Black 100 3 110000
14005 Black 1000 4 900000
14010 Silver 240 6 350000
  1. Which field should be used as the key field?
  2. Which code_Num data will be listed if the following search condition is applied? (Speaker power>400) AND (No of CDs>4).
  3. Write down a search condition to find all the equipment which is silver coloured or has a price greater than 500,000/=
  4. Write down the order of the Code_num after the price(Tsh) field has been sorted in ascending order.

Short answers
2

A query is really nothing more than a question you ask to access your data.


True OR False