L2 ICT U1 Database Flashcard

Front

What is a database?

Back

A collection of data that is organised in a way that makes it easily accessed and maintained.

Front

What is a flat-file database?

Back

A database with only one table.

Front

What is a relational database?

Back

A database with more than one table.

Front

What is a record in the context of a database?

Back

A single entry in a database table.

Front

What would a record in a book store's database table typically store?

Back

The details of a single book, such as ISBN, title, and price.

Front

What is a field in the context of a database table?

Back

An individual piece of data in a record

Front

Which of the following is NOT an example of a field in a database table? ISBN, Book Title, Genre, Table of Contents

Back

Table of Contents

Front

What type of data does the 'Text' data type store in a database?

Back

Alphanumeric values

Front

Which data type would be most appropriate for storing a book's price in a database? Options: Text, Number, Data/Time, Boolean

Back

Number

Front

What can the 'Number' data type store?

Back

Whole numbers, floating point numbers, and negative values