tidal-agriculture

bySaniha

Build me project for Title: Agriculture Market Price Information System Develop a full-stack DBMS-based web application called "Agriculture Market Price Information System" using HTML, CSS (frontend), Python Flask (backend), and MySQL (database). The system should include the following features: 1. Database Design: * Create a MySQL database with tables: * crops (crop_id, crop_name) * markets (market_id, market_name, location) * prices (price_id, crop_id, market_id, price, date) * admin (id, username, password) * Use primary keys and foreign keys to maintain relationships. 2. User Module: * Provide a user-friendly homepage. * Allow users to select crops using a dropdown list. * Display market prices based on selected crop. * Show results in a tabular format. * Include filters such as market name and date (optional). 3. Admin Module: * Implement secure admin login system. * Create a dashboard for admin. * Allow admin to insert new crop prices into database. * Automatically store current date using system date. 4. Data Visualization: * Display price trends using graphs (Chart.js). * Show price vs date for better analysis. 5. Real-Time Simulation: * Implement a scheduler in Python that automatically inserts price data at regular intervals (simulating real-time updates). 6. Additional Features: * Highlight high prices using conditional formatting. * Make UI simple and responsive. * Use SQL joins to fetch combined data from multiple tables. 7. Backend Requirements: * Use Flask framework. * Handle routes for homepage, admin login, dashboard, and price search. * Connect Python with MySQL using mysql-connector. 8. Frontend Requirements: * Use HTML and basic CSS. * Create forms for user input and admin login. * Display data dynamically using templates. 9. Optional Enhancements: * Add price alerts. * Add filtering by date range. * Implement indexing for faster queries. The system should demonstrate proper use of DBMS concepts such as normalization, relationships, joins, indexing, and real-time data handling.