Database Bitesize

What is a database?

• A collection of data organized for easy access and management

• A type of software used for graphic design

• A programming language

• A hardware device for storing data

Name two types of databases.

• Flat-file and relational

• SQL and NoSQL

• Primary and foreign

• Static and dynamic

What is a primary key?

• A unique identifier for a record in a database table

• A key used to encrypt data

• A secondary identifier for a record

• A type of database relationship

Explain the term 'foreign key'.

• A key used to access foreign databases

• A unique identifier for a record in a database table

• A field in one table that uniquely identifies a row of another table

• A type of database management system

What is a relational database?

• A database that stores data in a single table

• A database that stores data in multiple tables with relationships between them

• A database used for storing images

• A database that does not support SQL

Define 'data redundancy'.

• The duplication of data in a database

• The process of normalizing data

• The encryption of data

• The deletion of data

What is the purpose of a database management system (DBMS)?

• To manage and control access to the database

• To design websites

• To create graphic designs

• To manage network security

Describe the term 'data integrity'.

• The accuracy and consistency of data in a database

• The process of encrypting data

• The duplication of data

• The deletion of data

What is SQL and what is it used for?

• A programming language used for web development

• A query language used for managing and manipulating databases

• A type of database management system

• A software used for graphic design

Explain the difference between a flat-file database and a relational database.

• Flat-file databases store data in multiple tables; relational databases store data in a single table

• Flat-file databases store data in a single table; relational databases store data in multiple tables with relationships

• Flat-file databases are used for graphic design; relational databases are used for web development

• Flat-file databases do not support SQL; relational databases support SQL