I am workin on a project in which i need to design and hotel inventory management system below are mention few point which i need to keep in mind while creating such flow
- user Interface of the system should look like an excel sheet where Column Should represent date and row should represent number of room in each category.
- Boxes in user interface should be clickable.
- by clicking on that box user should be able to block that particular cell and block his inventory
- Also on second click on that block celll user should be able to open that block inventory
- Blocked Inventory should show some icon like cross to represent that is inventory is blocked
Now below are few questions on which i would like to have your help.
- How this user interface can be build on php
- How i need to design my sql query
- How database normalization should be done in such case
i have not build a single line of code so would not be able to share. would request you to suggest some artical or webpage where i can understand such inventory management system.
Thanks Pratik Verma