What does the result of a join operation between the zone table and the parcel table in Figure 8.9 look like?

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