Search code examples
databasedatabase-designtheorydatabase-table

How do you determine the base table?


My question is in relation to database theory.

If I am given a set of tables, is there a way to determine the base table just by looking at them?


Solution

  • It is a tenet of the relational model that there is no unnecessary distinction between a Base Table (Base Relation) and a Derived one (aka virtual relation or "view"). Both types have attributes, keys and all the other features you would expect of relations and both can be used in just the same ways. As a practical matter of implementation it is necessary that the DBMS software provide some means to differentiate them but logically speaking they are the same.

    The principle that base and derived relations are similar in this way is sometimes called the Principle of Interchangeability.

    Actually, I'm surprised there is so much puzzlement here about your question and surprised that your question is downvoted. Base table / relation is a very common term in relational database theory and in the SQL standard. Your question seems perfectly concise and in order to me.