Database Crossword

occurs in database systems which have a field that is repeated in two or more tables
A technique of preventing simultaneous access to data in a database, to prevent inconsistent results.
A set of properties that guarantee that database transactions are processed reliably
Database transaction is an indivisible and irreducible series of database operations such that either all occur, or nothing occurs
Any data written to the database must be valid according to all defined rules, including constraints, cascades, triggers, and any combination thereof
A DBMS usually acquires locks on data which may result in a loss of concurrency or implements multiversion concurrency control. This requires adding logic for the application to function correctly.
guarantees that transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes
Information processing that is divided into individual, indivisible operations
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
The language and syntax used to write and run database queries
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
All non-key elements are fully dependant on the primary key
All the incomplete dependencies have been removed
That is a relation in which the intersection of each tuple and attribute contains one and only one value
A table with no normalisation. All data and all fields in one table
A data structure that improves the speed of data retrieval operations on a dataset table at the cost of additional writes and storage space
The process of arranging data in tables and setting their relationships
The process of producing a data model for describing the data or information aspects of a business domain or its process requirements, in an abstract way that lends itself to ultimately being implemented in a data such as a relation database
A key field which can be used to access a table in a different way
When more than one field is added together to form a unique primary key for a table
The linking field in a table formed when a relationship is made
A field that uniquely identifies a record in a table
Allows the user to specify information about multiple tables