Database aplication for administration of condition monitoring program
- or -
Post a project like this$$
- Posted:
- Proposals: 14
- Remote
- #1939273
- Expired
Software Engineer | Full Stack Developer | Cloud Architect | Motion Graphics Animator
London
IT Consultant |Virtual Assistant| graphics| | Website design | social media management .
Nairobi
256409405961097311932473146593522284710986657041076580121073620989662145795
Description
Experience Level: Intermediate
Estimated project duration: 1 - 2 weeks
General information for the business: We provide condition monitoring services for industrial customers.
Database management system (DBMS): SQL
Description of requirements/functionality: Database will consist of aproximately 10 to 15 tables with relationships, and aproximately with 12 to 16 data entry forms. Data is asociated with production assets with at least 3 levels of segregation: áreas, machine trains/systems, equipments. Other tables must be created for machine/system specs file, machine/system failure modes, machine failure symptoms/descriptors, failure history, failure investigation (date, descriptor found, recomended action, trending). Aplication must have forms to issue anomalies, and trend investigation. Diagnosis will be make easier by comparison between standard descriptors of a failure (failure model), with actual symptoms/descriptors found during investigation. Failure modes and symptoms /descriptores must be input in such way that they could be standarize (with a code) and by selectrin from lists. In order to be able to do that, failure mode and symptoms/descriptor fields must allow user to input a new definition or from an existing one selecting from a list.
Reporting will allow the user to see failure history for every machine/system, failure investigation of a single case (diagnosis report), summary of anomalies issued (aproximatelly 5-6 different report types)
App must have the capability of import and export data from Excel.
All forms and report text fields MUST be in SPANISH (mandatory requeriment).
I must remain with the database and app property and keep all rights for use and distribute comercially. IN order to do that, there has to be a licensing algorith so I can distribute to a third and give a license for use.
CMS and Admin requirements: multiuser capability
Specific technologies required: SQL (open to suggestions)
Attached is an example (unfinished Access database in access, not guarantee relationships are ok)
Database management system (DBMS): SQL
Description of requirements/functionality: Database will consist of aproximately 10 to 15 tables with relationships, and aproximately with 12 to 16 data entry forms. Data is asociated with production assets with at least 3 levels of segregation: áreas, machine trains/systems, equipments. Other tables must be created for machine/system specs file, machine/system failure modes, machine failure symptoms/descriptors, failure history, failure investigation (date, descriptor found, recomended action, trending). Aplication must have forms to issue anomalies, and trend investigation. Diagnosis will be make easier by comparison between standard descriptors of a failure (failure model), with actual symptoms/descriptors found during investigation. Failure modes and symptoms /descriptores must be input in such way that they could be standarize (with a code) and by selectrin from lists. In order to be able to do that, failure mode and symptoms/descriptor fields must allow user to input a new definition or from an existing one selecting from a list.
Reporting will allow the user to see failure history for every machine/system, failure investigation of a single case (diagnosis report), summary of anomalies issued (aproximatelly 5-6 different report types)
App must have the capability of import and export data from Excel.
All forms and report text fields MUST be in SPANISH (mandatory requeriment).
I must remain with the database and app property and keep all rights for use and distribute comercially. IN order to do that, there has to be a licensing algorith so I can distribute to a third and give a license for use.
CMS and Admin requirements: multiuser capability
Specific technologies required: SQL (open to suggestions)
Attached is an example (unfinished Access database in access, not guarantee relationships are ok)
Alejandro J.
100% (17)Projects Completed
12
Freelancers worked with
11
Projects awarded
62%
Last project
13 Feb 2023
Costa Rica
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
are you able to bear the expenses of a web app for this DB management with reporting?
Alejandro J.02 Apr 2018Depending on your price
-
Are you interested in developing this database as an online database with web based access?
Alejandro J.02 Apr 2018I am open to it It´s all about budget
610646610588
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies