irasubizapacifique7-spec/Weather-Based-Crop-Advisory-System-

The Weather-Based Crop Advisory System is a PL/SQL-driven application that analyzes daily weather data against ideal crop requirements to provide Rwandan farmers with automated, data-driven advisories on planting, irrigation, and harvesting. # Weather-Based-Crop-Advisory-System- The Weather-Based Crop Advisory System is a PL/SQL-driven application that analyzes daily weather data against ideal crop requirements to provide Rwandan farmers with automated, data-driven advisories on planting, irrigation, and harvesting. # Weather-Based Crop Advisory System for Agricultural Decision Support in Rwanda ## Project Overview This project is a comprehensive capstone developed for the course **Database Development with PL/SQL (INSY 8311)** at the **Adventist University of Central Africa (AUCA)**. Agriculture remains one of the most important sectors in Rwanda, yet it is heavily influenced by unpredictable weather conditions. This system provides **data-driven, automated crop advisories** by comparing real-time weather records with crop-specific requirements. All business rules are implemented using **Oracle PL/SQL**, making the solution reliable, efficient, and fully database-driven. --- ## Project Details | Detail | Value | |-------|-------| | **Project Title** | Weather-Based Crop Advisory System for Agricultural Decision Support in Rwanda | | **Student Name** | Irasubiza Pacifique | | **Student ID** | 27983 | | **Core Technology** | Oracle Database, PL/SQL | | **Objective** | Generate automated crop advisories (**GOOD**, **MODERATE**, **BAD**) by comparing weather data with ideal crop requirements | --- ## Key Features ### Automated Advisory Generation A main PL/SQL procedure **`GENERATE_ADVISORY`** reads weather data, compares it with each crop’s requirements, and generates advisory messages automatically. ### Weather Status Classification A PL/SQL function **`CHECK_WEATHER_STATUS`** determines whether weather conditions are **GOOD**, **MODERATE**, or **BAD** for a crop based on: - Temperature - Rainfall - Humidity ### Smart Decision Support Advisories help farmers make informed choices regarding: - Planting time - Irrigation needs - Disease and pest risk management ### Fully Data-Driven Al …