4.10.2 Relational databases Flashcards
1
Q
What is a composite key?
A
A key that is made up of multiple attributes
2
Q
What is a database?
A
Structured collection of data
3
Q
What is a record?
A
all the data about one item
4
Q
What is a flat file / relational database?
A
Flat file database - single table
Relational database- multiple tables
5
Q
What is a primary key?
A
a field which uniquely identifies each record in a database
an attribute that will identify a particular instance of an entity
6
Q
What is a foreign key?
A
an attribute in one table that is (linked) to a primary key attribute in another table
7
Q
What is an attribute?
A
a property or characteristic of an entity
