<div>
Many thanks for a very clear explanation.
</div>


Many thanks for a very clear explanation.

<div>
<div class="content wysiwyg-content">
I am new to databases and am trying to follow an Entity Relationship Diagram (attached). I cannot see how this could be implemented in real life. If you were querying the 'GPA' of a particular student how would you know whether to search in the 'UNDERGRADUATE' or the 'GRADUATE' table. Grateful for any assistance.<a href="https://filedb.experts-exchange.com/incoming/2014/01_w05/831227/ERD.jpg" target="_blank" title="ERD (74 KB)"><img alt="ERD" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w05/800_831227/ERD.jpg" /></a>
</div>
</div>


ERD.jpg

I am new to databases and am trying to follow an Entity Relationship Diagram (attached). I cannot see how this could be implemented in real life. If you were querying the 'GPA' of a particular student how would you know whether to search in the 'UNDERGRADUATE' or the 'GRADUATE' table. Grateful for any assistance.

Understanding an Entity Relationship Diagram

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.