Explore BrainMass
Share

Benefits of Views in Databases

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

What are the benefits of using Views in a database?

Use APA formatting and citation.

© BrainMass Inc. brainmass.com March 21, 2019, 11:21 pm ad1c9bdddf
https://brainmass.com/computer-science/operating-systems/benefits-views-databases-454811

Solution Preview

A view represents the application program's or an individual user's picture of the database (Pratt & Adamski, 2004). According to Ghanem, Elmagarmid, Larson, and Aref (2010), one of the reasons database views are needed is because the actual schema of the database is normalized restricting database administrators from using denormalized relations that represent the real world. Views have several advantages including database users to create reports, charts and other objects showing database data. The first important advantage of views is that views provide data independence (Pratt & Adamski, 2004). Since views represent a picture of the original database objects, any change for ...

Solution Summary

This solution briefly explains the various benefits of database views.

$2.19