Computing - Topic 7

Database

an organised collection of data that is structure to make it easier for a program to store and search for information

Relational database

a database that stores data in tables (relations) that are linked using keys (primary keys and foreign keys)

Primary Key

A field that uniquely identifies each record in a table. They are important for database operations such as data retrieval, updates and deletes

Foreign Key

a field which is a primary key in a linked table

Field

a column in the database (also known as attributes)

Record

a row in a database table

Chars

a data type with a fixed length

Varchars

a data type with no fixed length

to insert

insert into … (name of table) values

to update

update ….(name of table)

set …..(primary key) to …….

where …… = …….

to delete

delete from ……(name of table)

where ….. = ……..