Characteristics of the Relational Model
- Data is represented in rows and columns called relations.
- Data is stored in tables having relationships between them called the Relational model.
- The relational model supports the operations like Data definition, Data manipulation, and Transaction management.
- Each column has a distinct name and they are representing attributes.
- Each row represents a single entity.
Relational Model in DBMS
E.F. Codd proposed the relational Model to model data in the form of relations or tables. After designing the conceptual model of the Database using ER diagram, we need to convert the conceptual model into a relational model which can be implemented using any RDBMS language like Oracle SQL, MySQL, etc. So we will see what the Relational Model is.
The relational model uses a collection of tables to represent both data and the relationships among those data. Each table has multiple columns, and each column has a unique name. Tables are also known as relations. The relational model is an example of a record-based model. Record-based models are so named because the database is structured in fixed-format records of several types. Each table contains records of a particular type. Each record type defines a fixed number of fields, or attributes. The columns of the table correspond to the attributes of the record type. The relational data model is the most widely used data model, and a vast majority of current database systems are based on the relational model.