The Jersey City Fire Dept, suspects a serial arsonist is at work. The Fire Chief

Question

The Jersey City Fire Dept, suspects a serial arsonist is at work. The Fire Chief has provided you with two tables of data (below). As the Fire Dept. GIS professional, you have been asked to determine if the data suggest a pattern of arson. You decide to perform a "table join" and analyze the data. Show below how the 2 tables connect after you perform a table join What columns did you use as the Primary and Foreign keys? ___ Is there a potential pattern of arson? Yes___ No ___ Explain WHY you reached the conclusion in c) above

Explanation / Answer

ID is primary key and street addres is foriegn key

Shape ID Street Address Market Value(5) Accelrent issurance point 1 105 Hudson Ave 75000 No yes point 2 231 Communipaw 35000 No No point 3 1105 Hwy 440 600000 yes yes point 4 26 JFK Blvd south 105000 no yes point 5 29 deniali street 35000 no no point 6 517 Aliaster st 75000 no no point 7 523 Jersy st 151000 no no point 8 119 harborview 255000 no yes point 9 269 riverview 495000 yes yes point 10 25 Bayview 351000 yes yes

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.