Database Applications Flashcards

What is a 'flat file' database?

Answer: A single table database with no relationships to other tables

A flat file database contains all data in a single table with no links or relationships to other tables, making it simple but limited for complex data.

In a relational database, what connects two related tables?

Answer: A foreign key

A foreign key is a field in one table that references the primary key of another table, creating the relationship between the two tables.

Which of the following is an example of a database management system (DBMS)?

Answer: Microsoft Access

Microsoft Access is a DBMS that provides tools for creating, organizing, querying, and managing databases.

When sorting database records in ascending order on a 'Last Name' field, which entry appears first?

Answer: Anderson

Ascending alphabetical order starts from A; 'Anderson' begins with 'A', placing it before names starting with later letters.

What does 'filtering' records in a database mean?

Answer: Displaying only records that meet specific criteria

Filtering temporarily hides records that do not meet the specified criteria, showing only the relevant subset of data without deleting anything.

Which type of query would you use to change the price field for all records where 'Category' equals 'Electronics'?

Answer: Update query

An Update query modifies existing values in one or more fields for records that match specified criteria, such as changing prices for a product category.

What is data validation in a database context?

Answer: Rules that control what data can be entered into a field

Data validation uses rules and constraints to ensure that only appropriate, accurate data is entered into database fields, maintaining data integrity.