Use Case/Description of Key Deal Information app
The purpose of the Key Deal Information app is to store some data in a (my)SQL-Database in order to
(i) Visualize the different persons/parties involved in a deal and
(ii) To have access on the information stored in the SQL-Database by third-party apps.
Export of stored data into OData-format is required.
All the information which need to be stored are listed in Appendix 1 and are straight forward.
The app needs no mutli-user access; one user is sufficient. However, the app itself and the data stored should be protected by a password.
The app should be designed to be access via desktop/tablet.
Within the app, you can add new Clients.
For each Client, different Projects can be added.
Each Project can have different Companies and Managers.
Each Company can have different Shareholders and Managing Directors.
One can add, edit and delete the respective data.
Every time changes to the data have been made, such changes shall be saved to the existing version of the data or one can choose to add a new version of the data (Versioning).
All the data should be searchable.
A very simple wireframe of the app is attached as Appendix 2.
One should have a dashboard showing all Clients and Projects.
Once a Project is selected, all Information for such Project should be displayed on a project dash-board. Once a Company, Manger, Manging Director, Shareholder etc. is clicked, a modal should pop up in which all the detailed information is displayed.
On the project dashboard, a visual "deal chart" should also be available. This deal chart should show the shareholding structure of the Companies stored within a Project.
It is important that all information are stored within a (my)SQL-Database. and afterwards exported into a OData format. Third-party applications need to have access to all the data in OData-format.
Part of the work should also be some example OData-queries which demonstrate how one can access selected information stored within the OData--format.
21 фрилансеров(-а) в среднем готовы выполнить эту работу за €630
Hi there, I have checked the details I have rich experienced with Database Programming, MySQL, Web Development, Website Design. Please initiate chat so we can discuss this job.