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…


No comments have yet been made