Posted On: Feb 22, 2018
The subset of a table which is basically stored logically in a database is called as a view. A view is a virtual table which is containing the rows and columns. The fields located in views are similar to tables and they do not contain the date of their own. Its advantages are:
Never Miss an Articles from us.
A database, in general, is a collection of information in a more organized form for better access...
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...