Relational Database Model:
Dr. E.F.Codd first introduced the Relational Database Model in 1970. This model allows data to be represented in a ‘simple row-column format’.
Properties of the relational database model:
- Data is presented as a collection of relations.
- Each relation is depicted as a table.
- Columns are attributes that belong to the entity modeled by the table (ex. In a student table, you could have a name,
- address, student ID, major, etc.).
- Each row (“tuple”) represents a single entity.
- Every table has a set of attributes that taken together as a “key” (technically, a superkey”) uniquely identifies each entity.