Database

From Higher Computing Science
Jump to: navigation, search

Key points

  • A database is a program that is designed to store information.
  • Databases are able to search and sort information efficiently.
  • Databases have a specific structure. 
  • Each database is made up of tables of data, which contains records for each person or object in the table. Each record has the same set of fields, which hold single pieces of item relating to the person or object in the record.
  • Each field has a data type.
  • Tables can be linked together by a shared field. 
  • In each table, a field that uniquely identifies the record is called a primary key.
  • A field that refers to the primary key in another table is a foreign key.


Information

Videos

Further information

Test yourself

Teaching resources