Adil Khan 1 year ago
AdiKhanOfficial #FYP Ideas

Smart Interface

Smart Interface is a web-based application that facilitates the non-professional user to interact with database using natural language instead of Database Query Language. User will be able to INSERT, SELECT, UPDATE, MIN, MAX, on any unknown tables of any database using inner joins.The system will b

Project Title

Smart Interface

Project Area of Specialization

Artificial Intelligence

Project Summary

Smart Interface is a web-based application that facilitates the non-professional user to interact with database using natural language instead of Database Query Language. User will be able to INSERT, SELECT, UPDATE, MIN, MAX, on any unknown tables of any database using inner joins.The system will b generic for every database using NLP.

The  system includes two modules: natural language processor or linguistic module and database module. This system processes the user's request in Natural English language. The request should be domain specific. The query in natural language is then translated into equivalent SQL statement and finally SQL statement will be executed to perform desired function on the database. User will be able to access Database using Natural Language (English). There will be no need of SQL syntax from user end. Both non-technical and technical people can use it. There will be no predefined constraint regarding the selection of the words, but it should be domain specific and tables name of database should be proper nouns.

Project Objectives

To interact with database, one should have technical knowledge of database. Our system aims to facilitate non technical user to extract and manipulate data from database without taking help of DB developer in natural language(English).

Project Implementation Method

The  system includes two modules: natural language processor or linguistic module and database module. This system processes the user's request in Natural English language.The query in natural language is then translated into equivalent SQL statement and finally SQL statement will be executed to perform desired function on the database. User will be able to access Database using Natural Language (English). There will be no predefined constraint regarding the selection of the words.Tables and Column names of database should be proper nouns.

Benefits of the Project

The smart interface aims to enable users to interact with databases on the basis of natural language which is innovative.The current system is made up of  static forms and static queries.It has a learning phase.Our system aims to reduce that learning phase and making interaction with database more natural,easy ans innovative.

Technical Details of Final Deliverable

FR # 1

The system shall a­llow the user to input Natural Language Query.

FR # 2

The system shall generate SQL Query.

FR # 3

FR # 4

System shall be able to store and retrieve data.

System shall be able to store and retrieve data using inner joins.

FR # 5

The user shall be able to execute the SQL Query.

FR # 6

The system shall able to fetch the records from Database

FR # 1

FR # 2

FR # 3

FR # 4

FR # 5

FR # 6

Final Deliverable of the Project

Software System

Type of Industry

IT

Technologies

Artificial Intelligence(AI)

Sustainable Development Goals

Industry, Innovation and Infrastructure

Required Resources

Elapsed time in (days or weeks or month or quarter) since start of the project Milestone Deliverable
Month 1SRS submissionSRS report
Month 2website developmentonline website
Month 3Generic Database import and configurations User Portal
Month 4Natural Language Module development and integrationworking FYP
Month 5Testing on different databasesImproved Accuracy
If you need this project, please contact me on contact@adikhanofficial.com
0
171
Android based News Summarization

Android-based Automatic Text summarization, is to shorten the amount of text in the docume...

1675638330.png
Adil Khan
1 year ago
AN INTEGRATED INDIGENOUSLY DEVELOPED IOT BASED HOSPITAL ROBOT FOR COVI...

COVID 19 is an epidemic that has caused worldwide respiratory problems and has weakened th...

1675638330.png
Adil Khan
1 year ago
Lec 03 Adv comp arch

defaultuser.png
Faseeh Iftikhar
5 years ago
Sports Management System

The project brings the entire manual process of the sports department online which will de...

1675638330.png
Adil Khan
1 year ago
3D Car Modification App

We?re going to develop an android based application, In this application there?s multiple...

1675638330.png
Adil Khan
1 year ago