LISTING 1: The Denormalized Id_Residents Table

CREATE TABLE ld_Residents
(location_id	int		NOT NULL,
 first_name_0	varchar(20)	NOT NULL,
 middle_name_0  varchar(20)	NOT NULL,
 last_name_0	varchar(20)	NOT NULL,
 first_name_1	varchar(20)	NOT NULL,
 middle_name_1  varchar(20)	NOT NULL,
 last_name_1	varchar(20)	NOT NULL,
 first_name_2	varchar(20)	NOT NULL,
 middle_name_2  varchar(20)	NOT NULL,
 last_name_2	varchar(20)	NOT NULL,
 first_name_3	varchar(20)	NOT NULL,
 middle_name_3  varchar(20)	NOT NULL,
 last_name_3	varchar(20)	NOT NULL,
 first_name_4	varchar(20)	NOT NULL,
 middle_name_4  varchar(20)	NOT NULL,
 last_name_4	varchar(20)	NOT NULL)