FORUM ON WEEK 4

What is ER Model? Why do you use it??:

What is ER Model? Why do you use it??:

by RakiBul IsLam -
Number of replies: 6

An entity relationship diagram (ERD), also known as an entity relationship model, is a graphical representation that depicts relationships among people, objects, places, concepts or events within an information technology (IT) system.

ER Diagrams are most often used to design or debug relational databases in the fields of software engineering, business information systems, education and research. ... ER diagrams also are often used in conjunction with data flow diagrams (DFDs), which map out the flow of information for processes or systems

In reply to RakiBul IsLam

Re: What is ER Model? Why do you use it??:

by Sajib Dhali -
ER Diagrams are most often used to design or debug relational databases in the fields of software engineering, business information systems, education and research. ... ER diagrams also are often used in conjunction with data flow diagrams (DFDs), which map out the flow of information for processes or systems.
In reply to RakiBul IsLam

Re: What is ER Model? Why do you use it??:

by Md. Khadamul Islam -
Entity Relationship Model (ER Modeling) is a graphical approach to database design. It is a high-level data model that defines data elements and their relationship for a specified software system. An ER model is used to represent real-world objects.
An entity-relationship diagram, or ER diagram, is essential for modeling the data stored in a database. It is the basic design upon which a database is built. ER diagrams specify what data we will store: the entities and their attributes. They also show how entities relate to other entities.
An entity relationship diagram (ERD) shows the relationships of entity sets stored in a database. By defining the entities, their attributes, and showing the relationships between them, an ER diagram illustrates the logical structure of databases. ER diagrams are used to sketch out the design of a database.
In reply to RakiBul IsLam

Re: What is ER Model? Why do you use it??:

by Mehedi Hasan Shaon -
An entity-relationship diagram, or ER diagram, is essential for modeling the data stored in a database. It is the basic design upon which a database is built. ER diagrams specify what data we will store: the entities and their attributes. They also show how entities relate to other entities.
An entity relationship diagram (ERD) shows the relationships of entity sets stored in a database. By defining the entities, their attributes, and showing the relationships between them, an ER diagram illustrates the logical structure of databases. ER diagrams are used to sketch out the design of a database.
In reply to RakiBul IsLam

Re: What is ER Model? Why do you use it??:

by Sweety Islam -
ER Diagrams are most often used to design or debug relational databases in the fields of software engineering, business information systems, education and research. ... ER diagrams also are often used in conjunction with data flow diagrams (DFDs), which map out the flow of information for processes or systems.
In reply to RakiBul IsLam

Re: What is ER Model? Why do you use it??:

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 Abir Mahmud

Re: What is ER Model? Why do you use it??:

by RakiBul IsLam -
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.