Name the Term
Name the term:
Database
Why are databases better for concurrent use compared to spreadsheets? In terms of accessibility.
Databases allow many users to access data simultaneously.
What does cloud storage mean in the context of databases?
Storing data online, managed by a cloud provider
What is a relational database?
A database that keeps data in several connected tables.
What is a report in a database?
A summary of data
Name the term:
Scaleability
Why are constraints important in a database?
They prevent data inconsistency.
What is one advantage of databases in terms of data recovery?
Databases back up information within seconds.
Which type of database allows users to access it over the Internet?
Online Database
Which feature of a database ensures that only authorized users can access the data?
Security
Name the term:
Field
Why are databases important for businesses?
They allow businesses to make smart choices and plan for the future.
What is the best way to enter large amounts of data into a database?
Importing it from other sources
What is a key benefit of using offline databases?
They reduce the risk of cyber-attacks.
What is a flat file system?
Another name for a spreadsheet
Name the term:
Query
What is one reason organizations prefer databases over spreadsheets? In terms of Data
Databases can handle more data points efficiently.
What does forced data entry mean in the context of databases?
Controlling and validating the information users enter.
What is one advantage of local databases?
They can be accessed faster
What is the role of a database management system (DBMS)?
To create and manage databases
Name the term:
Record
Why are key-value databases useful for tasks that need quick data access?
They have a flexible structure
What is the primary key in a relational database?
A field that uniquely identifies each record.
Which type of data is best stored in a relational database?
Structured Data
What is non-structured data?
Data that doesn't have a clear order or pattern