Database - A collect of data in a formal structure, e.g. tables, but without any formally defined relationship between those tables., Relational database - Allows the user to specify information about multiple tables and the relationship between those tables, Table - A collection of records within a database, Record - A collection of fields from a database table relating to a single entity., Primary key - A field that uniquely identifies a record in a table, Foreign key - The linking field in the foreign table formed when a relationship is made., SQL - The language and syntax used to write and run database queries, SELECT - A key word in the SQL programming language used for the querying, ORDER BY - A key word in the SQL programming language used to sort the output from a SELECT query, FROM - An SQL key word used to signify which table(s) we are using., Join - A relationship between two tables, whereby a primary key one table links to a foreign key in another,

GCSE.U7.SQL-Definitions Flashcard

Drucken
Einbetten

Bestenliste

Flash-Karten ist eine Vorlage mit offenem Ende. Es generiert keine Punkte für eine Bestenliste.

Visueller Stil

Einstellungen

Vorlage ändern

Soll die automatisch gespeicherte Aktivität wiederhergestellt werden?