Database Management System20825 marksViews and view creation
What is the view? How can you create a view in SQL? Illustrate with an example.
What is the view? How can you create a view in SQL? Illustrate with an example. [5]
A view is a virtual table that is derived from one or more base tables (or other views) using a SQL query. It does not physically store data itself; instead, it stores the query definition, and the data is retrieved dynamically whenever the view is accessed. Key characteristics of a view: - It be...