Computing - Topic 7

Database - an organised collection of data that is structured 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 deletions

Foreign Key - a field which is a primary key in a linked table

Field - a column in a database table (also known as attributes)

Record - a row in a database table

Chars - a data type with a fixed length

Varchars - a data type without a fixed length

to insert - insert into ….(name of table) values …..()

to update - update ……..(name of table)

                    set ….. = “new value“

                    where ….. = ………

to delete - delete from ………(name of table)

                    where …… = ………