10 Questions
What is the primary function of a database in an organization?
To enter, modify, retrieve, and report information
What is a table in a database comprised of?
Many records
What does a record in a database represent?
Information relating to a single instance of an entity
What is a field in a database?
An attribute of the entity
What is a database typically made up of?
Several tables
What is the primary purpose of a key field in a database?
To uniquely identify each record and link to other tables
What is the term used to describe the way different tables in a database are linked to one another?
Relational
What is the purpose of a primary key field in a table?
To uniquely identify each record in the table and link to similar foreign key fields
What is the relationship between a primary key field and a foreign key field?
A primary key field is used to link to a foreign key field in another table
What is the purpose of a secondary or foreign key field?
To link to a primary key field in another table
Learn about the basics of database design, including the functions of a database, how it's structured, and how it supports organizations. Understand the components of a database, such as tables, records, and fields.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free