Complex examples
Learning outcomes for this page: Be aware of the pragmatic approach to achieving first normal form
Two solutions are given below to the example given of multiple repeating groups.The first following the generic procedure described above ‘to the letter’ while the second makes the new key field a single key field thus avoiding composite keys.
Portfolio exercise: none m10|04|00
Time: 0 minutes
For: Clinicians | NHS managers | Non healthcare workers
Written by Robin Beaumont & Chris Noden e-mail:robin@ieg-net.co.uk or chrisnoden@hotmail.com
