Entity Framework Inheritance vs Tables <p>Ok I am very new to creating databases with Entity in mind.</p> <p>I have a Master table which is going to have:</p> <pre><code>departmentID functionID processID procedureID </code></pre> <p>Each of those ID's need to point to a specific list of information. Which is name, description and owner of course they link back to each ID in the master table.</p> <p>My question is, should I make 4 separate tables or create one table since the information is the same in all the tables except one.</p> <p>The <code>procedureID</code> will actually need to have an extra field for <code>documentID</code> to point to a specific document.</p> <p>Is it possible and a good idea to make one table and add some inheritance, or is it better to make 4 separate tables?</p>