Posted On: Feb 22, 2018
A database, in general, is a collection of information in a more organized form for better access. The data can be stored or executed in multiple ways and collectively they are defined as tables, views or database objects. Data warehouse refers to the medium of a repository of the data from the multiple resources. The data from the data warehouse is available to transform or even use in online processing.
Never Miss an Articles from us.
In order to remove the redundant data, normalization is used. It also reduces the null values and enables the efficiency of indexing...
Denormalization is the inverse process of normalization...
There is, of course, a difference between the primary and unique key..