Decomposition is the process of breaking down in parts or elements.
It replaces a relation with a collection of smaller relations.
It breaks the table into multiple tables in a database.
If there is no proper decomposition of the relation, then it may lead to problems like loss of information.
Normalization is the process of re-organizing data in a database.So that it meets 2 requirements.
Data fragmentation allows you to break a single object into two or more segments(অংশ) or fragments(টুকরা). The Object might be a user database,a system database or a table. Each fragment can be stored at any site over a computer network. There are 3 types of data fragmentation strategies :
Normalization is the process of re-organizing data in a database.So that it meets 2 requirements.
- There is no redundancy(আতিশয্য) of data.
- Data dependencies are logical.
Data fragmentation allows you to break a single object into two or more segments(অংশ) or fragments(টুকরা). The Object might be a user database,a system database or a table. Each fragment can be stored at any site over a computer network. There are 3 types of data fragmentation strategies :
- Horizontal fragmentation
- Vertical fragmentation
- Mixed fragmentation