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

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.

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.

Answer / Solution

UNSOLVED

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

Answer / Solution

TRUE