Views_in_DBMS

  VIEWS INTRODUCTION View is a virtual table created by a query by connecting one or additional tables. The fields in a view are fields from one or additional real tables in the database. To create a view we use the CREATE VIEW statement. It is operated equally to the base table but does not contain any information of its own.  What is a View in DBMS..? Generally complications arises in SQL queries because of joins, Group By clauses and other referential dependencies in SQL. So for the aim of simplification virtual data can be used. In addition to this security challenges can be resolved by giving solely the required access to user and proscribing access to other data. This can be done with the help of views in DBMS. For instance, a user needs only 2 columns of data, so the Database Administrator can create a virtual table of those 2 columns that the user needs with the help of view. CREATING A SIMPLE VIEW A simple view takes only one table and doesn’t take any inbuilt SQL fun...