Y8 IT/CO2 Database Homework 1 Flashcard

Front

Which of the following is a characteristic of a database? Stores information, Random papers in a drawer, A book, Scattered photos

Back

Stores information

Front

Which of the following is NOT an example of a database? Netflix movie library, Spotify music collection, School records, Random papers in a drawer

Back

Random papers in a drawer

Front

A ______ is one complete set of information in a table (like one student’s details).

Back

record

Front

A ______ is the single piece of information in a record (categories like a student’s name or age).

Back

field

Front

A ______ is a unique identifier for each record (like a student’s ID number) it needs to be unique to recognise that record.

Back

primary key

Front

A primary key is used to give each record a ______ code. It's unique and can never be repeated.

Back

unique

Front

What is a computerized database?

Back

A database that stores data digitally on a computer.

Front

A paper-based database stores data on ________.

Back

physical paper

Front

What is a flat file database?

Back

A database that stores all data in a single table with rows and columns.

Front

A relational database organizes data into multiple linked tables, allowing complex data management and efficient relationships between different types of information. This makes it easier to search for information, and it ensures only the relevant information is in each _______.

Back

table