This section portrays a real example of the creation of an entity relationship diagram (ERD). I don’t intend that this discussion be all-inclusive of this topic; however, I would like you to see the basic steps that are taken in the event that you need to create one:
Identify the entities.
Define the identifiers.
Define the relationships.
Determine cardinality and ordinality of the relationship.
Determine descriptive attributes. Move these to related entities.
Create the ERD.
Review and refine the ERD.
The attributes of the database are contained in the f lows of the system’s data f low diagram (DFD). The analyst reviews this set of data, identifies ...