A fully normalized database may slow down data access. To increase the performance in data access, for example, one may remove the address table in Figure 8.9. How should the database be redesigned if the address table were removed?

Transcribed Image Text:

Parcel table Owner table PIN P101 P102 P103 P104 Sale date 1-10-98 10-6-68 3-7-97 7-30-78 PIN P101 P101 P102 P102 P103 P104 Acres Zone code 1.0 1 3.0 2 2.5 2 1.0 1 Owner name Wang Chang Smith Jones Costello Smith Address table Zone table Owner name Wang Chang Jones Smith Costello Figure 8.9 Separate tables after normalization. The fields relating the tables are highlighted. Zone code 2 Owner address 101 Oak St 200 Maple St 105 Ash St 300 Spruce Rd 206 Elm St Zoning Residential Commercial