Normalization Convertor and SQL Schema Generator

Project Title

Normalization Convertor and SQL Schema Generator

Project Area of Specialization Computer ScienceProject Summary Problem Statement:

Normalization is a very hectic/time-consuming process for students as well as for database designers and developers. There is no such system that takes input from images and from the toolbox and then converts it into a normalized database structure and finally provides its SQL schema. Automatic conversion into SQL schema from the normalized tables to build all required database tables is also essential.

Proposed Solutions:

Our solution is to develop such a tool that uses image processing for scanning user-provided images of the logical schema along with a toolbox for building/editing the required logical schema. This will then convert it into semantic data and then provide the steps of normalization starting by highlighting all anomalies in the logical schema, and then perform the normalization starting from the first normal form. It then finally generates the SQL schema. The core functionality includes:

1. Input Toolbox/Drawing Tool for Logical Schema building

2. Image Processing for taking Logical Schema drawn images as an Input

3. Anomaly Detection and Perform Normalization to Resolve all detected Anomalies

4. SQL Schema Script Generation

 

Significance of Solution:

Our solution will help the students to understand the concept of normalization steps with the reasoning and will also help developers to build the SQL schema which will eventually save their time. As per our understanding,  there is no such tool available that takes a multi-value attribute and normalizes it from 1st NFR or provides a logical schema image upload option for input.

Project Objectives

The main purpose of this document is to define and describe the functions and specifications of the Normalization Converter and SQL Schema Generator. This Software Requirements Specification illustrates the core functionality with enough detail to help developers in developing a user-centered System. It will explain the purpose and features of the system, the interfaces of the system, what the system will do, the constraints under which it must operate, and how the system will react to external stimuli. It will also help the stakeholder to understand what will be the functionalities of the system.

Project Implementation Method

1.  Software Interfaces:
   1.  Software Requirement:

1. Browser: Google Chrome, Mozilla Firefox, Microsoft Edge, of latest versions to run the system.

2. Database: MySQL Database.

It will be used to create the structure of the data to be stored. By using MySQL we store data and create tables.

1. Server: Xampp Server. 

This will be our server where we store our data from a website.

1. Language: Html, CSS, Bootstrap, Angular JS for front-end, Python for back-end programming, SQL for the database.

1.  Hardware Interfaces:
   1.  Hardware Requirement:

1. Computer: RAM: At least 4GB, Hard Disk: At least 80 GB, Processor: At least Intel Core i3, 2.9 GHz CPU.

2. Mobile: Any android phone with good support of Chrome as our system is a web-based application.

Benefits of the Project

Our solution will help the students to understand the concept of normalization steps with the reasoning and will also help developers to build the SQL schema which will eventually save their time. As per our understanding,  there is no such tool available that takes a multi-value attribute and normalizes it from 1st NFR or provides a logical schema image upload option for input.

Technical Details of Final Deliverable

not finalized yet

Final Deliverable of the Project Software SystemCore Industry EducationOther Industries IT Core Technology OthersOther TechnologiesSustainable Development Goals Industry, Innovation and InfrastructureRequired Resources

Item Name	Type	No. of Units	Per Unit Cost (in Rs)	Total (in Rs)
			Total in (Rs)	60000
LAPTOP	Equipment	1	40000	40000
WEB HOSTING	Equipment	1	10000	10000
RESEARCH	Miscellaneous	1	10000	10000