 |
Home > Section 7 > Subsection 7 (Normalisation - part 1) |    |
Learning outcomes for this page: COnsolidate knowledge of first normal form
1. If a table is not in first normal form what is the basic problem (one correct answer):
1. A text field that needs splitting up
2. One or more Non atomic fields
3. Null values in fields
4. Too many fields in the table
5. One or more multivalued fields
2. What is another name for a multi-valued field:
3. First normal form frequently involves:
1. The creation of additional records only
2. The creation of new field types
3. The removal of redundant data
4. The merging of several tables
5. The creation of additional tables and therefore records
4. What is the technical term used for splitting the fields up in a table to create two or more tables:
- Progesterone
- Division
- Projection
- Purgation
- Splitting
5. In the following example which field has the non atomic values (I have presented the data in a way to confuse you!):
|
Patient id |
Blood test |
Date of birth |
Gender |
|
1 |
12.45 |
22/10/78 |
male |
|
1 |
1.754 |
22/10/78 |
male |
|
1 |
3.55 |
22/10/78 |
male |
|
2 |
2.43 |
7/12/90 |
Female |
|
2 |
7.32 |
7/12/90 |
Female |
For: Clinicians | NHS managers | Non healthcare workers
Work through the above MCQs. Remember to save the results in your portfolio.
Written by Robin Beaumont & Chris Noden e-mail:robin@ieg-net.co.uk or chrisnoden@hotmail.com