Relational Model

• The Relational Model was first developed in 1969 by E.F Codd (of IBM). It was a breaking through for users and designers.
• Its conceptual simplicity set the stage ofr a genuine database revolution.
• The Relational Model displays database structures in tables, more closely representing a modern computer based database than the ERD
• A collection of data items organized as a set of formally described tables from which data can be accessed easily.

• The diagram to the left was our student entity. 
• The table on the right is the same entity translated into a relational model. 
• Asides from displaying an entity differently, the relational model also has one more important task which is storing information. 
• A relational model is able to display an entity's structure while also containing information on each instance of the entity. (As in we do not need to talk about all students as a collection, we can show individual student's info.)