Primary Key - A field that uniquely identifies a record in a table, Secondary Key - A key field which can be used to access a table in a different way, Referential Integrity - A measure of the consistency of the data in a database. It is violated when the relation to which a foreign key refers to no longer exists., ACID - A set of properties that guarantee that database transactions are processed reliably.  , Indexing - The process of creating additional information, which i improves the speed of data retrieval operations, Flat File - A database that specifies data attributes (columns, etc.) for only one table at a time, Relational Database - Allows the user to specify information about multiple tables and the relationship between those tables, Foreign Key - The linking field in the foreign table formed when a relationship is made, Composite Primary Key - A primary key that is the unique combination of two or more fields, Normal Forms - A way of structuring the data in a relational database according to formal rules, in order to avoid problems of efficiency and security in accessing and maintain the data., SQL - The language and syntax used to write and run database queries,

A-Level Database Terminology

โดย
สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม