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
0%
A-Level Database Terminology
Share
Share
by
Jnicholson4
Edit Content
Print
Embed
More
Assignments
Leaderboard
Show more
Show less
This leaderboard is currently private. Click
Share
to make it public.
This leaderboard has been disabled by the resource owner.
This leaderboard is disabled as your options are different to the resource owner.
Revert Options
Match up
is an open-ended template. It does not generate scores for a leaderboard.
Log in required
Visual style
Fonts
Subscription required
Options
Switch template
Show all
Open results
Copy link
QR code
Delete
Continue editing:
?
