databases Flashcards
1
Q
What is a database?
A
A database is an organised way to store data so that it can easily be retrieved using queries.
2
Q
What is a record?
A
It is a set of information about something.
3
Q
What is a field?
A
It is an item of data in a record?
4
Q
what is a flat file database?
A
A flat file data base stores a single table of data.
5
Q
What is a primary key?
A
It is a field which stores unique data for each record in a table.
6
Q
What is data redundancy?
A
It is where data is repeated in a database table.
7
Q
What is a relational database?
A
A relational database contains multiple tables.
8
Q
What is a foreign key?
A
It is a field in a table which references the primary key of another table.