databases 1 Flashcards
1
Q
whats a database
A
persistant organised store of related data
2
Q
entity
A
a real world thing we store data on
3
Q
attribute
A
characteristic of an entity
4
Q
types of relational databases
A
one to one , one to many , many to many
5
Q
primary keys
A
A primary key is a unique identifier for each record in the table
6
Q
secondary key
A
an attribute normally given to fields in which indexing is useful
7
Q
foreign key
A
a primary key in another table.