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