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
共享
共享
共享
由
Jnicholson4
KS4
Computing
编辑内容
打印
嵌入
更多
作业
排行榜
闪存卡
是一个开放式模板。它不会为排行榜生成分数。
需要登录
视觉风格
字体
需要订阅
选项
切换模板
显示所有
播放活动时将显示更多格式。
打开成绩
复制链接
QR 代码
删除
恢复自动保存:
?