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


Copyright © www.teach-ict.com