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

oleh
Cetakan
Benamkan

Papan mata

Gaya visual

Pilihan

Tukar templat

Pulihkan autosimpan: ?