Interpolation
In this final lab, were were building off the last water quality lab. This time we added sample sites and sample data collected on different dates to interpolate the water quality across the grid.
We wrote SQL to combine the 2 provided sample tables into 1 table and them wrote additional SQL to add a new column onto one of our existing tables. We completed an additional 5 SQL tasks to get all the data needed for our choropleth map. As with the other labs in this course, I have omitted the specifics on the SQL to avoid interfering with other students completion of this course.
We were asked to create an ERD for this water quality scenario. I used Lucidchart to complete mine. I still find myself regularly overanalyzing my ERD's and struggling for the right relationship term.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.