The order of the one to many links is important. Some examples are shown below

Entity relationship diagrams or ERD’s provide a quick reference point for creation of a database. Also they provide an excellent way of working out which entities will be involved in a query. Most queries will span across multiple entities and as such we need to give careful thought to them.