Databases & Queries Flashcards
(5 cards)
1
Q
What is a database?
A
An organized collection of data that can be easily accessed, managed, and updated.
2
Q
What is a query in a database?
A
A request to retrieve or manipulate data within a database.
3
Q
What is a primary key?
A
A unique identifier for each record in a database table.
4
Q
What is a foreign key?
A
A field in one table that uniquely identifies a row of another table, establishing a relationship between the two.
5
Q
What is a field, record, and table in a database?
A
Field: A single data item (e.g., “Name”)
Record: A full set of fields for one entry
Table: A collection of related records
