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
Share
Share
Share
by
Jnicholson4
KS3
Computing
Databases
I-edit ang Content
I-Print kini
Embed
Uban pa
Assignments
Leaderboard
Show more
Show less
Kini nga leaderboard naka-pribado. Pag-klik sa
Share
aron himuon kini nga publiko.
Kini nga leaderboard gi-disable sa tag-iya sa resource.
Kini nga leaderboard gi-disable tungod ang imong mga kapilian lahi ra sa tag-iya sa resource.
I-revert ang mga Kapilian
Ang
Match up
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:
?
