PostgreSQL / Prisma
Browse and strategize across all 16 official problem statements requiring PostgreSQL / Prisma. Complete with verified datasets, tech stack blueprints, and jury defense playbooks.
Problem Statements List (16)
Match My TeamAutomated High-Current Short-Circuit Test System for IEC 60898-1:2015 MCB Compliance.
Testing Miniature Circuit Breakers (MCBs) under international standard IEC 60898-1:2015 requires dangerous high-current short-circuit tests (up to 10kA) with precise point-on-wave switching that manual laboratory setups struggle to capture accurately. Build an automated high-current short-circuit testing and data acquisition (DAQ) platform with microsecond synchronous point-on-wave firing, optical arc voltage monitoring, and automated test certificate generation for BIS laboratories.
Development of a Software Program/Application for Generation of Test Reports for Non-Automatic Weighing Instruments (NAWI) as per OIML Recommendation R- 76
National Test House (NTH) and Bureau of Indian Standards (BIS) laboratories manually compile physical test results across multiple scientific disciplines (chemical, mechanical, electrical), causing reporting delays, transcription errors, and risks of fake certificate forgery. Build an automated laboratory test report generation and verification system that ingests instrument data, applies standard-specific pass/fail rules, and issues tamper-evident QR-verifiable test certificates.
AIIA Clinical Trials Dashboard - a real-time, cloud-based, GCP-compliant Clinical Trial Management System (CTMS) for Ayurveda research, with CDISC/FHIR-interoperable data, role-based KPIs, and integrated ethics, regulatory (CTRI / NDCT Rules 2019) and pharmacovigilance tracking.
All India Institute of Ayurveda (AIIA) and national Ayush research centers conduct clinical trials using fragmented paper Case Report Forms (CRFs) and spreadsheets, resulting in regulatory non-compliance with GCP guidelines, delayed trial monitoring, and lack of real-time adverse event reporting. Build the 'AIIA Clinical Trials Dashboard'—a cloud-based, CDISC/GCP-compliant electronic data capture (EDC) and real-time trial monitoring platform.
Software Based Model Development for Design of Area Specific Shelter for Thermal Comfort Maintenance.
Indian armed forces stationed at extreme high-altitude forward posts (Siachen, Ladakh, Tawang >18,000 ft) require specialized military shelters that balance thermal insulation (-50°C), structural resistance against 150 km/h blizzard winds and heavy snow loads, and rapid modular assembly. Build a software-based parametric engineering simulation and CAD generative design platform that optimizes high-altitude shelter geometry, thermal composite materials, and solar heating efficiency.
Development of a Real-time Airfare Price Index for India through Automated Web Scraping of Airline and Online Travel Aggregator Portals for Augmentation of the Consumer Price Index (CPI).
The Ministry of Statistics and Programme Implementation (MoSPI) tracks consumer price inflation using lagging manual monthly surveys that fail to capture the high volatility and dynamic pricing algorithms of Indian domestic airfares. Build a Real-Time Airfare Price Index (APIX) automated platform for MoSPI that continuously scrapes, normalizes, and aggregates route-level flight fares across airlines and OTAs, computing high-frequency Fisher/Jevons price indices with seat availability weighting.
Digital Platform for efficient remote management of Indian Antarctic Research Stations
Indian Antarctic Research Stations (Maitri and Bharati) operate thousands of kilometers away in sub-zero isolation, where equipment telemetry (diesel generators, HVAC life support, water purification, scientific instruments) is monitored on fragmented local computers without unified remote digital twin oversight from NCPOR Goa. Build a centralized Digital Platform for remote management of Indian Antarctic Research Stations with satellite IoT telemetry synchronization, predictive life-support maintenance, and emergency response coordination.
Integrated Polar Expedition Logistics and Asset Management System
Indian Antarctic and Arctic scientific expeditions involve complex international logistics (chartering ice-class ships, cargo flights from Cape Town, shipping containers, specialized polar gear, food rations, heavy snow vehicles) across multi-month planning cycles where lost cargo or expired maintenance parts can jeopardize year-long scientific missions. Build an Integrated Polar Expedition Logistics and Asset Management Platform for NCPOR that tracks multimodal shipments, manages extreme-environment asset lifecycles (PistonBully snow groomers, cranes, skidoos), and optimizes container packing.
Integrated Polar Science Outreach, Knowledge Repository and Media Dissemination Portal
India's landmark scientific discoveries in the Polar regions (Antarctica, Arctic, Himalayas/Third Pole) and Southern Ocean remain hidden in academic journals, limiting public awareness, school STEM engagement, and accessible media dissemination. Build an Integrated Polar Science Outreach, Interactive Knowledge Repository, and Media Dissemination Platform for NCPOR featuring interactive 3D digital twins of polar stations, virtual Antarctic expeditions, open scientific dataset downloads, and school educational gamification.
Autonomous Low-Cost Ocean Observation Platform for Polar and Southern Oceans
Long-term oceanographic and climate monitoring in the harsh, storm-tossed Southern Ocean and Antarctic waters is severely limited by the high operational cost of research vessels and lack of low-cost autonomous observation platforms. Build an Autonomous Low-Cost Ocean Observation Platform (Wave/Solar powered surface drifter/glider) and digital telemetry portal for NCPOR that measures sea surface temperature, salinity, wave height, dissolved oxygen, and acoustic ambient marine noise with satellite cloud sync.
Air PollutionWeather Coupled Forecasting System (Delhi NCR Focus)
Severe winter air pollution in Delhi-NCR (hazardous PM2.5 / PM10 AQI > 450) is driven by an explosive combination of stubble burning emissions, vehicular exhaust, and stagnant meteorological conditions (nocturnal temperature inversions, calm surface winds <1 m/s, low boundary layer height). Build a coupled Air Pollution-Weather Forecasting platform for IITM/SAFAR combining WRF-Chem atmospheric chemistry models, satellite fire radiative power (FRP), and deep learning to forecast hyper-local AQI and stubble smoke dispersion 72 hours in advance.
Efficiency in streamlining industrial approvals,compliance processes,and access to government support services
Industrial investors setting up factories in Maharashtra struggle to obtain 40+ statutory clearances (MIDC land allotment, MPCB pollution consent, Fire NOC, factory license, DISH safety, electricity power sanction) through fragmented departmental portals with slow manual file movements. Build an AI-Powered Intelligent Single-Window Industrial Approval and Compliance Acceleration Platform for MAITRI (Maharashtra Industry, Trade and Investment Facilitation Cell) with automated composite application routing, real-time SLA tracking, and dynamic regulatory compliance checklists.
Challenges in aligning skill development programs with industry requirements and emerging job market demands
Industrial manufacturing and IT sectors in Maharashtra face severe technical talent shortages while thousands of ITI and polytechnic graduates remain unemployed due to outdated vocational curricula that do not match industry requirements (EV battery assembly, CNC programming, solar PV maintenance, AI robotics). Build an AI-driven Vocational Curriculum Alignment and Dynamic Skill Gap Analytics Platform for the Maharashtra State Skill Development Society (MSSDS) that continuously analyzes real-time job market postings to recommend modular curriculum updates for ITIs.
Difficulties in tracking employment outcomes,skill gaps, and the impact of skilling initiatives
The Government of Maharashtra invests hundreds of crores in vocational skill training programs (Pramod Mahajan Kaushalya Vikas Yojana, ITI training), but government officials have no reliable mechanism to track longitudinal post-training employment outcomes, wage increments, and job retention rates, leading to unverified placement claims by private training partners. Build a Longitudinal Employment Outcome and Skill Impact Tracking Platform for the Government of Maharashtra that uses EPFO Provident Fund integration, DigiLocker verification, and automated graduate surveys to track career trajectories.
Quantum-Inspired Fuel Consumption Prediction and Green Fleet Optimization
Commercial shipping fleets and heavy inter-city freight logistics companies face severe carbon emissions and high fuel costs due to unoptimized voyage speeds, oceanic currents, and non-linear aerodynamic/hydrodynamic drag. Build a Quantum-Inspired Fuel Consumption Prediction and Green Fleet Optimization Platform for Egreen Quanta that uses Quantum Support Vector Regression (QSVR) and Quantum-Inspired Genetic Algorithms (QIGA) to predict vessel hydrodynamic fuel burn and calculate fuel-optimal weather-routing trajectories.
Student Innovation
AICTE Open Innovation: Smart Automation (Software) — Small and medium enterprises (MSMEs) in India lose millions in operational waste due to manual equipment tracking, unoptimized electricity consumption, and disconnected legacy software tools. Build an Intelligent Industrial Smart Automation and Resource Optimization Platform that uses computer vision, Edge IoT automation, and predictive machine learning to autonomously orchestrate factory equipment, optimize energy loads, and streamline business workflows.
Student Innovation
AICTE Open Innovation: Smart Automation (Hardware) — Legacy industrial machinery in Indian manufacturing workshops operates without digital telemetry, resulting in sudden mechanical motor breakdowns, undetected thermal overheating, and expensive production downtime. Build a Retrofittable Industrial Edge-IoT Smart Automation and Machine Health Monitoring Controller Box featuring multi-channel vibration accelerometers, non-invasive current transducers (CT), thermal infrared sensors, automated safety relay interlocks, and Modbus/RS485 communication.