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 Flashcard
Share
Share
Share
by
Jnicholson4
KS4
Computing
I-edit ang Content
I-Print kini
Embed
Uban pa
Assignments
Leaderboard
Ang
Flash cards
usa ka open-ended nga template. Dili kini makamugna ug mga marka sa leaderboard.
Kinahanglan mag log in
Visual style
Fonts
Subscription required
Mga Option
I-switch ang template
Ipakita tanan
Daghang mga format ang mugawas samtang gidula nimo ang activity.
Open results
Copy link
QR code
Mag-delete
I-restore ang gi-autosave:
?