A smart agriculture company has developed a precision farmin…
A smart agriculture company has developed a precision farming system that continuously monitors crop conditions across hundreds of farms. Sensors installed throughout the fields automatically collect measurements every hour and store the following information: Field ID Farm Name County Date Soil Moisture (%) Soil Temperature (°C) Air Temperature (°C) Humidity (%) Light Intensity Crop Health Status (Healthy, Moderate Stress, Severe Stress) The company would like to build a computational system capable of monitoring current crop conditions and predicting future crop health. Answer the following questions. Computational Thinking (1 Point): Briefly explain how decomposition would help organize the development of this agricultural monitoring system. Data Storage (1 Point): The company currently stores all observations in hundreds of CSV files distributed across different computers. Would a relational database be a better solution? Briefly justify your answer. Data Retrieval (1 Point): After storing the observations in a database, explain how SQL and Python would work together to retrieve the information needed for analysis. Data Representation (1 Point): Once the query results have been imported into Python, which data structure would be the most appropriate for organizing and analyzing the observations? Briefly explain why. Data Preparation (2 Points): Before performing any analysis, identify four data quality issues that should be examined. Exploratory Data Analysis (2 Points): Describe two descriptive statistics and two visualizations that would help agricultural scientists better understand this dataset. Explain what information each would provide. Machine Learning (2 Points): The company would like to predict whether future crop conditions will be classified as Healthy, Moderate Stress, or Severe Stress. Answer the following. Is this a classification, regression, or clustering problem? Identify two possible features. Identify the label. Name one machine learning algorithm discussed in this course that could be used for this task. Briefly justify your answers.