An existing ER diagram was presented earlier and illustrated how the entities in the diagram could be represented as tables.
Now I will show you how to examine your tables to ensure they reduce data redundancy and allow records to be added, updated, and deleted without inadvertently changing or removing important information.
If you are stuck and don't know how to proceed in a database design, focus on creating tables that represent a single entity each.
This is the easiest way to create a sound database design.