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, etc. The steps below can be used to change an ER model into a relational model:
For example in the above given ER diagram a table with name Student will be created in relational model, which will have 3 columns, Stud_id, Studname, Studaddr with Stud_id as the primary key for this table.
For example in the above given ER diagram an additional table will be created for the relationship, StudyIn. This table will hold the primary key for both Student and College, in a tuple to describe the relationship, which student study in College.
Note: proper foreign key constraints must be set for all the tables.
Note: also read about Relational Calculus
Please follow me to read my latest post on programming and technology if you like my post.
https://www.instagram.com/coderz.py/
https://www.facebook.com/coderz.py
Staying up to the mark is what defines me. Hi all! I’m Rabecca Fatima a keen learner, great enthusiast, ready to take new challenges as stepping stones towards flying colors.
There is a staircase with N steps, and you can ascend either 1 step or…
Build an autocomplete system that, given a query string s and a set of possible…
Design a job scheduler that accepts a function f and an integer n. The scheduler…
Problem Statement (Asked By Airbnb) Given a list of integers, write a function to compute…
A unival tree (short for "universal value tree") is a tree in which all nodes…
Problem Statement (Asked By Facebook) Given the mapping a = 1, b = 2, ...,…