Relational database Flashcards
1
Q
What is a table?
A
The representation of an entity within a database that is a structure for storing attributes
2
Q
What is a field?
A
A single item of data from a record
3
Q
What is a flat file database?
A
A database made of one table
4
Q
What is a relational database?
A
A database made up of two or more related tables
5
Q
What is the benefits of using relational databases over flat file databases?
A
Less data entry
Less data duplication
Less storage required
Less inconsistency in the data
6
Q
What is a primary key?
A
An attribute used to uniquely identify a record
7
Q
What is a composite key?
A
A primary key made of two or more attributes
8
Q
What is a foreign key?
A
An attribute in one table that links to a primary key in another
