Eed Diagrams
An entity-relationship diagram, or ERD, shows the overall design structure of a database. The basic unit of an ERD is the entity. Each entity represents a particular kind of data. For instance, an employee training database might have an entity for employee data, and entity for department information, and an entity for the classes. One way to get a handle on entities is to remember that in a relational database there is generally one table for each entity.
Recognizing which entities you need in a database is a skill that develops with practice. Nevertheless, some tips can get you started.
When you were writing themes in junior high, your English teacher probably told you to have one paragraph for each topic or each point you wanted to make. In database design you have one entity for each data topic. In the example quoted above, you can see that employee information is different than class information. So often when you start detailing the specific pieces of information that need to be stored, those data topics naturally emerge.
Another tip is to ask yourself what the purpose of the database is. For instance, an employee database will almost always have an employee entity. A
one, entity, employee, database, relationship, entities, each, department, class, information, erd, data, between, shows, relationships, instance, design, topic, start, side, shown, pieces, parts, notations, need, marked, line, figure, employees, classes, belong, 3-1, yourself, writing, words, word
