Hi Jason, thanks for your response. I actually had gone through tutorials and I was able to get the idea of how the ORM works but in this scenario, since this is just the first few steps of the project, I have issues like,
1. A form that takes the input from user (requirements in the table). The user inputs will be requirements (cpu, memory, cpu model etc. and this is a json object). The user also tells what type of hardware he needs (router, networks etc) and softwares (oracle, microsoft). Here the challenge is, once the user input the requirements(JSON object), how do I compare this with the inventory (This inventory is something I still need to build. If you see specs in the table, thats the specifications of an environment that we have and that too should be JSON).
2. Howsoever I deal with the user input, I am suppose to make comparisons, (ESTIMATE table) and then give an environment to the user. (An environment is like what kind of VMs suits the requirement of the user).
3. I am not sure about this database as well. I was thinking that may be I should put the details that user put in ITEM table. Take these values from ITEM table and store in ESTIMATE table after making some calculations. Finally from ESTIMATE, make comparisons and give an ENVIRONMENT to the user.
I am not sure if I was able to explain this. If you may wonder why JSON object, the idea is that inventory may have many things added in the future. I am not able to get these things straight.