Help with building Chatbot for a custom ERP Software
Hello,
I am working as an AI/ML Intern at a software company that builds ERP software based on companies' needs, such as schools, Construction sites, Hospitals, Fuel Pumps, and so on. I need help building an AI Chatbot which can be integrated with an ERP application. The company uses .NET as their main language for building applications.
For example: an ERP application for a school
There are user roles: Admin, Principal, Teacher, Accountant, Student/Parent, Driver
Student lifecycle: Admission → Academic → Attendance → Examination → Result
ERP Modules: Admission Management -> Admission, Registration, Entrance Admit Card, and so on, such as Billing Management, Transport Management, and Examination Management
The task is to integrate an AI system into the ERP web application in which:
A user, such as an admin, principal, or accountant, inputs a question in natural language like "Give me the names of students whose remaining dues are over 5000 since last month" or "How many students are present today" or "Show me a graph of student attendance for the last 3 weeks"
The input is then converted to a relevant database query and searches for all the required details from the user input. The ERP uses Microsoft SQL to store all its data.
The AI generates output in natural language for the user and shows the relevant answer.
Restriction: No user should be able to alter any of the data in the database. It should be read-only.