DATABASE NORMALIZATION from 1NF-2NF-3NF , normalize the following data below and elaborate G22 A B fx C

DATABASE NORMALIZATION from 1NF-2NF-3NF , normalize the following data below and elaborate

 

Transcribed Image Text:

G22 A B fx C D E F G H 1 J K L M PK Staff No. 12345 1 WARD STAFF ALLOCATION 3 UNNORMALIZED TABLE - ONE LARGE TABLE Name Address 6 S123 Morgan Russell 23A George Street 7 S098 Tel No. 01506-67676 Nurse Carol Cummings 15 High Street Edinbu0131-334-5677 Staff Nurse Position Shift Ward No. Ward Name Location Week beginning Charge Nurse Charge Nurse No. Tel Extn. Late Late Ward 11 Orthopaedic Block E 09/01/1998 Moira Samuel S011 7711 8 9 10 11 12 13 G22 A B fx C D E F G H 1 J K L M PK Staff No. 12345 1 WARD STAFF ALLOCATION 3 UNNORMALIZED TABLE - ONE LARGE TABLE Name Address 6 S123 Morgan Russell 23A George Street 7 S098 Tel No. 01506-67676 Nurse Carol Cummings 15 High Street Edinbu0131-334-5677 Staff Nurse Position Shift Ward No. Ward Name Location Week beginning Charge Nurse Charge Nurse No. Tel Extn. Late Late Ward 11 Orthopaedic Block E 09/01/1998 Moira Samuel S011 7711 8 9 10 11 12 13