____________ Fragmentation is another denormalisation technique in which the database table is split by rows
____________ Fragmentation is another denormalisation technique in which the database table is split by rows
Relations are referred as _______
Relations are referred as _______
In_______ technique the records are summarised in some summary columns thereby reducing the number of records stored in a table
In_______ technique the records are summarised in some summary columns thereby reducing the number of records stored in a table
Normalisation and database design are two closely ______ terms
Normalisation and database design are two closely ______ terms
If the data values stored in a relation are _________, then the database is said to possess redundancy
If the data values stored in a relation are _________, then the database is said to possess redundancy
A relation should be in ______ normal form if and only if all join dependency in the table is connoted by candidate keys of the relation
A relation should be in ______ normal form if and only if all join dependency in the table is connoted by candidate keys of the relation
_______ is another type of update anomaly which occurs when inconsistencies arise due to the removal of record from a relation
_______ is another type of update anomaly which occurs when inconsistencies arise due to the removal of record from a relation
When a person tries to update the redundant database, then it results in _________anomalies.
When a person tries to update the redundant database, then it results in _________anomalies.
______ fragmentation breaks tables/relations by columns.
______ fragmentation breaks tables/relations by columns.
Database containing multiple copies of the ______ data result in wastage of expensive storage space.
Database containing multiple copies of the ______ data result in wastage of expensive storage space.
If there is any type of disagreement between data items in a database, then it is referred to as ___________.
If there is any type of disagreement between data items in a database, then it is referred to as ___________.
_________comprises of various set of rules which are used to make sure that the database relations are fully normalised by listing the functional dependencies and decomposing them into smaller, efficient tables
_________comprises of various set of rules which are used to make sure that the database relations are fully normalised by listing the functional dependencies and decomposing them into smaller, efficient tables
_____________ is the process of converting higher normal forms to lower normal forms with the objective of getting faster access to database
_____________ is the process of converting higher normal forms to lower normal forms with the objective of getting faster access to database
Two attributes A and B in any relation R are said to possess a ________ if for each distinct value of A, there is only one value of attribute B associated with it.
Two attributes A and B in any relation R are said to possess a ________ if for each distinct value of A, there is only one value of attribute B associated with it.
During the normalisation process, you need to decompose database tables into _______ tables.
During the normalisation process, you need to decompose database tables into _______ tables.
Attributes are referred as __________
Attributes are referred as __________
when an attribute’s value for a particular record needs to be modified, then this change must be done in all the occurrences of the record. Otherwise, it results in_______ anomaly.
when an attribute’s value for a particular record needs to be modified, then this change must be done in all the occurrences of the record. Otherwise, it results in_______ anomaly.
____ attributes depends on the PK (primary key) attribute.
____ attributes depends on the PK (primary key) attribute.
__________of a relational schema (R) consists of replacement of the relation schema by two or more relational schemas all of which contains a subset of the attributes of R
__________of a relational schema (R) consists of replacement of the relation schema by two or more relational schemas all of which contains a subset of the attributes of R
___________ decomposition, when the parts ofthe table can be joined back again without adding more tuples added to thedatabase relation
___________ decomposition, when the parts ofthe table can be joined back again without adding more tuples added to thedatabase relation