Keep Coding Keep Cheering!
The ER (Entity-Relationship) model is a graphical representation used to design databases. On the other hand, the relational model is a mathematical representation that outlines the connections between database tables. After creating the system’s ER diagram, we must translate it into relational models, which can be instantly implemented by any RDBMS, such as Oracle, MySQL, […]
February 23, 2023 | DBMS | No comments
As data complexity increases today, it is becoming increasingly difficult to apply the traditional ER paradigm for database modeling. In order to handle the complex application better and reduce modeling complexity, the current ER model needs to be enhanced or improved. Consequently, three new concepts were added to the current ER Model as part of […]
February 17, 2023 | DBMS | No comments
The ER (Entity-Relationship) model is a conceptual data model used in database design. It represents the data in terms of entities, attributes, and relationships. Here are the basic concepts of the ER model: Entity: An entity is a real-world object, concept or thing with an independent existence that can be easily distinguished from other objects. […]
February 15, 2023 | DBMS | No comments