10. Designing relationships

When designing or solving relationships for an E-R diagram, it is helpful to remember the following information:

 

The 'Many' side is usually the foreign key

The 'One' side is usually the primary key

 

Before you design or set up a database, you should work out:

- the entities

- the attributes

- the entity relationships

 

This process is called 'data modelling'

 

 

challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Data Modelling