FORUM ON WEEK 4

ER model & schema

ER model & schema

by Ripon Mondal -
Number of replies: 2

Those are little complicated, I think I have to learn more and read also to understand the topic clearly.

In reply to Ripon Mondal

Re: ER model & schema

by Abir Mahmud -
ER diagrams can be mapped to relational schema, that is, it is possible to create relational schema using ER diagram.
...
Mapping Process
Create table for weak entity set.
Add all its attributes to table as field.
Add the primary key of identifying entity set.
Declare all foreign key constraints.
In reply to Ripon Mondal

Re: ER model & schema

by Sweety Islam -

ER Model stands for Entity Relationship Model is a high-level conceptual data model diagram. ... The ER Model represents real-world entities and the relationships between them. Creating an ER Model in DBMS is considered as a best practice before implementing your database.