Skip to content
BvunzoHub

Menu

Get full accessSign in

ZIMSEC O-Level Computer Science

8.9Form 1: Database creation; file structure elements; database objects

Form 1: Database creation; file structure elements; database objects in ZIMSEC O-Level Computer Science: what the syllabus expects you to know, the learning objectives and how to practise.
Subtopic42 practice questions2 lessons
Practise this topicAll Computer Science topics

Learning objectives

What the syllabus expects you to be able to do.

  1. 8.9.1Create a database and a file structure (fields, data types, field sizes, formats, validation rules and input masks).
  2. 8.9.2Design forms, reports and queries.

Lessons

  • Designing a database table: fields, records, data types and keys

    45 min

    Full access

  • Querying a table with SQL

    50 min

    Full access

Join to read every lesson, or see what Full access includes.

Sample question

A sample question on this topic. Answer it, check it, then read the worked answer.

Form 1: Database creation; file structure elements; database objects: sample question

1 mark

A table Customers has a text field Town. Which WHERE clause correctly selects the customers who live in Gweru?

Choose one answer

Turn Form 1: Database creation; file structure elements; database objects into a strength.

Practise with instant marking, see your mastery grow and get a study plan built around your exam date.

Start learningComputer Science topics