Consider three types of data in Queensland: one is about
Consider three types of data in Queensland: one is about
Consider three types of data in Queensland: one is about flora and fauna sightings which recordthe time and location (i.e., point) for a sighting of some species, one is about the areas of alldefined wetlands (as polygons), and another is about the defined areas (as polygons) for state andnational forest parks. A point is recorded using latitude and longitude, and a polygon is defined asa closed sequence of points.Question 1 [5 marks] Design a database for these three types of data. You may choose to usespatial data types such as POINT, LINE and POLYGON. The tables you design should support atleast the queries in Question 2 below. Use SQL create-table statements to present your design[You can document any your design assumptions if necessary].Question 2 [5 marks] Write three queries in an SQL-like query language,(1) [1 marks] to find the number of sightings of legless lizards in Pine Ridge ConservationPark.(2) [2 marks] to find all wetlands inside a state or national forest park.(3) [2 marks] to find all sightings of platypus and the distance to the closest wetlands (set thedistance to 0 if the sighting is inside a wetland).[Please define any non-standard SQL operations, relationships and functions you choose to usein a query.]Question 3 [10 marks] Design a step-by-step query execution plan, aiming to minimize the datato be fetched from the database and the number of spatial operations to be performed.(1) [3 marks] to process the query you give in Question 2.1 using Quad-tree indexes.(2) [3 marks] to process the query you give in Question 2.2 using R-tree indexes.(3) [4 marks] to process the query you give in Question 2.3 using R-tree indexes.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
WHATSAPP CHAT: +1 (781) 253-4162
Click ORDER NOW..
