Trusted since 2008
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

The following car details are to be entered in a database: Make, Date-of-manufacture, colour, and cost. a) Prepare a suitable database structure showing field names and...

The following car details are to be entered in a database: Make, Date-of-manufacture, colour, and cost.
a) Prepare a suitable database structure showing field names and their field data types
b) Explain how you index the data such that cars of the same make and colour are together.
c) Write a statement that can be used to select cars of colour green.
d) Give an instruction that would:
i) Select cars whose cost is between 500,000/= and 1,000,000/=
ii) Determine the average cost of all cars.

Answers

Kavungya
a)Field name Data type
ID (Primary key) Auto Number
Make text
Date of manufacture Date/time
Colour Text
Cost Currency
b)Create a query to show same make and colour
c)Create a query. In the colour field, and in the Criteria row, write “green”
d) i)Create a query. In the cost field, and in the criteria row, write “.>500000
and <1000000”
ii)Create a query. Choose average of costs “Avg” option in the total section.
Kavungya answered the question on June 6, 2019 at 09:06

Answer Attachments

Next: Differentiate between Fill and stroke

Previous: Describe four major shortcomings of the conventional (paper )file structures that are being addressed by the database approach.

View more Computer Studies Questions and Answers  |  Return to Questions Index

Exams With Marking Schemes

Related Questions