Database Concepts Flashcard

Front

What is a record in a database?

Back

A row in a table

Front

What is the smallest piece of information for an entity in a database?

Back

Field

Front

What is the purpose of action queries in a database?

Back

To change data like adding, updating, and deleting

Front

What is the main function of reports in a database?

Back

To present data in different views and formats

Front

Which of the following is a guideline for naming tables? Use only numbers, Use spaces, Use letters, numbers, and underscores, Use lowercase letters only

Back

Use letters, numbers, and underscores

Front

How many types of relationships are there in databases?

Back

3

Front

Which type of relationship is the most common in databases? Options: One to one, One to many, Many to many, None of the above

Back

One to many

Front

What is the role of queries in a database?

Back

To ask questions about data

Front

In a "One to Many" relationship, which table is considered the parent?

Back

The table on the left.

Front

What is one benefit of using forms in databases?

Back

They allow updating parent and child records simultaneously.