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 代碼
刪除
恢復自動保存:
?