Tweet
Aggregation,Decomposition,Generalization in RDBMS
Aggregation-: It is the process of selecting the data in group of records is called aggregation.
There are five aggregate system functions
Sum, Min, Max, Avg, Count. They all have their own purpose
Decomposition:- The process of selecting all data without any grouping and aggregate functions is called Decomposition. The data is selected, as it is present in the table.
Generalization:- while generalization seems to be simplification of data, i.e. to bring the data from Un-normalized form to normalized form.
There are five aggregate system functions
Sum, Min, Max, Avg, Count. They all have their own purpose
Decomposition:- The process of selecting all data without any grouping and aggregate functions is called Decomposition. The data is selected, as it is present in the table.
Generalization:- while generalization seems to be simplification of data, i.e. to bring the data from Un-normalized form to normalized form.