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.
0%
GCSE.U7.SQL-Definitions
Podijeli
Podijeli
Podijeli
Autor
Jnicholson4
KS3
Computing
Databases
Uredi sadržaj
Ispis
Postavi
Više
Zadatke
Top-lista
Pokaži više
Pokaži manje
Ova top-lista je trenutno privatna. Odaberite opciju
Podijeli
da biste je javno objavili.
Ovu top-listu onemogućio je vlasnik sadržaja.
Ova top-lista je onemogućena jer se vaš odabir opcija razlikuje od postavki vlasnika sadržaja.
Vrati opcije na početne postavke
Spoji parove
je otvoreni predložak. Ne generira rezultate za top-listu.
Prijava je obvezna
Vizualni stil
Fontovi
Potrebna je pretplata
Postavke
Promijeni predložak
Prikaži sve
Više formata prikazat će se dok budete igrali.
)
Otvoreni rezultati
Kopiraj vezu
QR kôd
Izbriši
Vrati automatski spremljeno:
?