Databases

Introduction

c.f. arrays, records, arrays of records. Other affordances of databases are....

Tasks

Libreoffice Base - create single table database from an exam question - what are the data types and primary keys. Create and run the queries.

Extension: Create a multiple table database & link with primary keys. Convert queries to SQL.

Dot points

• define a single-table database from given data storage requirements
• choose and specify suitable data types
• choose a suitable primary key for a database table
• perform a query-by-example from given search criteria