Get premium membership and access questions with answers, video lessons as well as revision papers.

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


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


Learn High School English on YouTube

Related Questions