Lecturers-students relationship ERD

This example was designed on the base of Wikimedia Commons file: Example ERD2.png. "example entity relationship diagram showing relationship between lecturers and students" [commons.wikimedia.org/wiki/File:Example_ERD2.png] This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported license. [creativecommons.org/licenses/by-sa/3.0/deed.en] "Relationship diagrams (also known as logical data models) are used to design relational databases and can be a good way of understanding the structures in a data set. The 3 building blocks of an Entity Relationship model are entities, attributes and relationships. An entity is a discrete and recognisable 'thing', either a pysical object ..., or concept ... Each entity can be physically represented as a table, where each column of the table is an attribute of the entity ... A relationship is a verb that links two or more entities. ... Importantly, relationships also have a cardinality that can be 'one to one', 'many to one', 'one to many' or 'many to many'. ... Many to many relationships are often a sign that a design needs to be further elaborated. For example the 'teaches' relationship between teachers and students at a university would be many to many and would require the introduction of entities like class and date to fully understand the relationship." [en.wikibooks.org/wiki/Data_Science:_An_Introduction/Thinking_Like_a_Data_Engineer] The entity-relationship diagram example "Lecturers-students relationship ERD" was drawn using ConceptDraw PRO software extended with the Entity-Relationship Diagram (ERD) solution from the Software Development area of ConceptDraw Solution Park.