What is a view? Discuss the difference between a view and a base relation.

What will be an ideal response?

View is the dynamic result of one or more relational operations operating on the base relations to
produce another relation. Base relation exists as a set of data in the database. A view does not
contain any data, rather a view is defined as a query on one or more base relations and a query on
the view is translated into a query on the associated base relations.