FORUM ON WEEK 4

ER diagram

ER diagram

by Sweety Islam -
Number of replies: 1

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 Sweety Islam

Re: ER diagram

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.