database basics

key terms

• entity- name given to anything that data is stored about
• attribute- describes properties of a entity eg the entity customer has attributes like, forename, surname, phone number etc
• entities are the table name and attributes at the fields in that table
• tables contain data about an entity and are organised in rows (records) and columns (fields)
• record- collection of data about a single item, each row is a seperate record
• fields- break records into seperate bits of…