Database Concepts Flashcards

1️⃣ Familiarise yourself with the flashcards:

  • Look through all the flashcards to see what's on both sides.
  • Make sure you understand the information on each card. If something's unclear, click the link to the revision notes at the bottom of the page for more details.

2️⃣ Test yourself:

  • Look at the question or prompt on each card and try to remember the answer before flipping it over.
  • Check the answer and make a note of any cards you find challenging and need to go over more.

3️⃣ Consistently Review and Practice:

  • Use spaced repetition: spend more time on the cards you struggle with and go over them more often.
  • Regularly review all the flashcards to help you better understand and retain the information over time.

Note: We may include questions that have multiple correct answers. It's useful to remember specific examples to understand these concepts better.

PERSONALISED 1-TO-1 TUTORING

Need more help on this topic? Get 1-to-1 support

Get support with clear explanations, practice and feedback (Ages 5 to 16).

  • DBS-checked tutors
  • Flexible times
  • Parents can be updated

Want an ad-free experience? Subscribe to remove ads

What is a database?

An organised store of data you can search and update.

What is a Database Management System (DBMS)?

Software that lets you create, store, search, and change databases.

In a database, what is a table?

A set of records about one type of thing.

In a database, what is a record?

A row that holds all the data about one item.

In a database, what is a field?

A column that holds one piece of data, like age or postcode.

What is a data type in a database?

It states the kind of data a field holds, such as text, number, date, or true/false.

What is a flat-file database?

A database that keeps all data in one table.

When is a flat-file database suitable?

When the data set is small and simple, with few items and fields.

What is a relational database?

A database with several tables that link to cut down repeated data.

What is data redundancy?

Storing the same piece of data more than once.

What is a database schema?

The plan of the database: its tables, fields, and data types.

Name two advantages of using a database over a spreadsheet.

It lets you search and sort data fast and reduces repeated data.