8525 AQA GCSE CS 3.7.1 Introduction to Relational Data

What is a database?

• A single file containing user data

• A temporary collection of unstructured information

• A random collection of data

• A structured and persistent collection of data

What are the two main types of databases?

• Relational and Non-Relational

• Single table and Double table

• Flat-file and Hierarchical

• Flat-file and Relational

Why are flat-file databases considered inefficient?

• Because they use complex queries for data retrieval

• Because they often contain duplicated data

• Because they store data without any structure

• Because they can handle large datasets efficiently

What is a key advantage of relational databases over flat-file databases?

• They contain only one table

• They do not require a database management system

• They eliminate data inconsistency and redundancy

• They are easier to duplicate

What does a Database Management System (DBMS) provide?

• A way to duplicate data efficiently

• A manipulation language like SQL

• A single table for data storage

• A structure for unorganized data

What is the role of SQL in a DBMS?

• To create a flat-file database

• To access and change the data

• To duplicate data

• To provide additional security

Why is data redundancy undesirable in databases?

• It increases storage requirements

• It simplifies data structure

• It enhances data security

• It makes data retrieval faster

How do relational databases help in maintaining data integrity?

• By duplicating data across multiple tables

• By using a single table for all data

• By storing all data in a flat-file format

• By relating tables and avoiding data inconsistencies

What is a significant disadvantage of using flat-file databases for large datasets?

• They are difficult to query

• They are too structured

• They enhance data security

• They require less storage

What does the persistence of a database refer to?

• The database's ability to handle large datasets

• The database's data being temporary

• The database's use of complex queries

• The database's data being stored permanently