During the normalisation process, you need to decompose database tables into _______ tables.
During the normalisation process, you need to decompose database tables into _______ tables.
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.
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.
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
Normalisation and database design are two closely ______ terms
Normalisation and database design are two closely ______ terms
______ fragmentation breaks tables/relations by columns.
______ fragmentation breaks tables/relations by columns.
_______ 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
___________ 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
Relations are referred as _______
Relations are referred as _______
____ attributes depends on the PK (primary key) attribute.
____ attributes depends on the PK (primary key) attribute.
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
_____________ 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
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.
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.
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
Attributes are referred as __________
Attributes are referred 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
____________ 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
__________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
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 ___________.