Database Management Concepts

Front

How is data organized in a database to ensure the same information is kept for everyone?

Back

Data is organized in fields so the same information is kept for everyone.

Front

What is the benefit of using relational databases in terms of information storage?

Back

In a relational database, some information can be in different tables.

Front

Staff only need to see relevant tables, so few people have access to all the information held on one person.

Back

Why do staff members have restricted access to certain tables in a database?

Front

How does a digital database improve confidentiality compared to paper records?

Back

No need to hold paper copies, so it increases confidentiality.

Front

What features can be used in a database to reduce data entry errors?

Back

Rules can be set up regarding the format of data.

Front

What is one advantage of having all data in the same format in a database?

Back

There are fewer errors if all data is in the same format.

Front

How can drop-down menus help in a database?

Back

Drop-down menus can be used to eliminate errors.

Front

What is a relational database?

Back

A database where some information can be stored in different tables.

Front

Why is it important to restrict access to certain database tables?

Back

To ensure confidentiality and limit access to sensitive information.

Front

What is one method to ensure data consistency in a database?

Back

Organizing data in fields to keep the same information for everyone.