Laravel algorithm to analyze a NoSQL and create SQL related tables,

Being new to web-development generally and Laravel/SQL/NoSQL specifically, we are developing a Front-End and an API Back-End app to do the following:

(1) User to enter the data as ‘table-01’ in the Front-End app,

(2) In addition to the data contents, user also specify which Cols/Rows are the headers using a check mark (indicated as 1 or 0 in ‘table-01’)

(3) FE-App to save this table in a NoSQL table,

(4) In the BE-app, an algorithm to be implemented as follows:

a. Read this table ‘table-01’ from NoSQL Database,

b. Identify the headers (attributes) marked by Boolean indicators,

c. Create SQL tables (on-the-fly) for each attribute using Laravel migration,

d. Fill each table with the attribute related data without duplication,

e. Create junction tables between these attribute tables based on ‘table-01’ relations,

As an example, the below LINK is a file that includes a simple table01 (in NoSQL format) including some Cars details in one sheet (in Red color), and the target SQL tables to be extracted by an automatic algorithm in the Other sheets (in two categories Green for the main tables and Blue for the Junction tables).

LINK: https://drive.google.com/file/d/0B5ujaoA98H_xUFNFbWJRX0FsUDg/view?usp=sharing

What we need is to create this algorithm using Laravel/NoSQL/SQL/any other tool that may support,