Data - Raw unorganised facts, Database - Organised collection of information , Relational  - databases became very popular in 1980, Integrity  - Databases can ensure that the data contained within them is correct,, Transaction - propagation of one or more changes to the database, Information - processed, organised and structured data, ACID  - transaction must conform to a set of rules known as, Isolation  - Modifications of data performed by a transaction must be independent of another transaction., Keys  - Columns are being shared between tables using , Consistency - No transaction should have any adverse effect on the data residing in the database., Validation - checking the input data to ensure it conforms with the data requirements, Atomicity - transaction must be treated as a unit, that is, either all of its operations are executed or none., Verification  - performs a check of the current data to ensure that it is accurate, consistent, DBMS - stores data in a file , Data redaction - .... allows you to transform sensitive information into patterns that aren’t comprehensible, Concurrency  - allow multiple users to affect multiple transactions is , Data masking  - .... provides a functional substitute for the original data., RDBMS - stores data in tables which are related, Foreign  - ... KEY creates a relationship between two tables, Durability  - modifications performed by the transaction must be permanent in the system., Schema - . .... is the skeleton structure that represents the logical view of the entire database., Data encryption  - the translation of data into a secret code., Data Definition Language - ..... is used for creating as well as modifying the structure of the database objects, DAM - process of observing, identifying and reporting database activities, Conceptual - The ..... level shows relationships between various data tables., Composite  - A ......... KEY is a combination of two or more columns that uniquely identify rows in a table., External  - The highest level in the three level architecture, Data dictionary  - ........... contains data about the database, Primary  - A ..... KEY uniquely identifies every row in that table., Physical - The ........ level describes how data is actually stored in the database,

Database - Assign 1

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?