what is a view discuss the difference between a view and a base relation?
3 Answers. A base relation (table) actually contains data. A view is a query over one (or more) base relations but does not actually contain any data itself. A base relation is just a table that actually physically exists and is stored in the database.