What is the difference between a 'view' and 'base' relation in database systems?
+4
A:
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.
Eric Petroelje
2009-08-25 13:27:44
speaking of relational database.. views are also called "derived relations"
Svetlozar Angelov
2009-08-25 13:36:54
A:
You have asked an absolute beginner's question about keys, you have asked an absolute beginner's question about commit, you are now asking an absolute beginner's question about "view versus base", yet you use the word "relation" to ask a question here (NOBODY does that, they all use the word "table"), and you still claim that you are not a student doing homework ?