Relational Database -- 2
Budget: £750 – £1,500 GBP
I require an experienced database developer to create a comprehensive relational database program. This project will primarily focus on data storage and retrieval.
The database program will be dedicated to the storage and retrieval of customer information. Particular focus should be given to the handling of customers' physical asset information.
The database should be capable of being run from a cloud-based server with multiple discreet users, each with a number of staff logins.
Ideal Skills:
- Proficient in relational database programming
- Knowledge in handling sensitive customer information
- Experience in developing database programs for customer data
To successfully complete this project, you need to create an efficient and secure method for data storage and retrieval. Moreover, the experience in handling physical asset information of customers will be a plus.
Given the complexity of the database inter-relationships only applicants with demonstrable previous experience in relational database are expected to apply. However if an applicant without previous experience can produce a strong argument as to why they should be considered then they should submit these reasons.
Project Detail Synopsis
At the present time physical infrastructure and equipment records are recorded on an Excel system with the records being recorded in a tabular format with ascending linear mileage running from the top and the phscial asset subjects set out left ro right along the top of the spreadsheet.
This allows for multiple items to be recorded against a specific mileage area. Each item is recorded separately based on the exact linear dimension. Items that extend longitudinally are recorded with a start and a finish mileage. All records start at the commencement mileage and are ranked by the finish mileage
At present the physical information is split into 8 subject areas. Within each subject area the data is then further sub-divided into specific item and subdivided again into constituent components. An example of this is shown in an attached screenshot of the Excel spreadsheet. This has been done to make the Excel spreadsheet easily searchable. It is recognised that a relational database may work differently and the Developer should develop an appropriate architecture that provides the outcome.
For the sake of clarity the input and output should be intuitive or obvious. How this is achieved is up to the Developer.
The project is to convert an existing Excel spreadsheet into a searchable relational database allowing simple searches. Search results should be capable of being printed using the Excel spreadsheet image however the Developer shall be free to suggest an alternative
A visual representation of the top-down system architecture is attached.
A more detailed explanation of the existing system with visualisations is attached.
Form of Submission.
To enable a level playing field amongst applicants, it is requested that tenders are submitted in the format set out in the documents attached.
The database program will be dedicated to the storage and retrieval of customer information. Particular focus should be given to the handling of customers' physical asset information.
The database should be capable of being run from a cloud-based server with multiple discreet users, each with a number of staff logins.
Ideal Skills:
- Proficient in relational database programming
- Knowledge in handling sensitive customer information
- Experience in developing database programs for customer data
To successfully complete this project, you need to create an efficient and secure method for data storage and retrieval. Moreover, the experience in handling physical asset information of customers will be a plus.
Given the complexity of the database inter-relationships only applicants with demonstrable previous experience in relational database are expected to apply. However if an applicant without previous experience can produce a strong argument as to why they should be considered then they should submit these reasons.
Project Detail Synopsis
At the present time physical infrastructure and equipment records are recorded on an Excel system with the records being recorded in a tabular format with ascending linear mileage running from the top and the phscial asset subjects set out left ro right along the top of the spreadsheet.
This allows for multiple items to be recorded against a specific mileage area. Each item is recorded separately based on the exact linear dimension. Items that extend longitudinally are recorded with a start and a finish mileage. All records start at the commencement mileage and are ranked by the finish mileage
At present the physical information is split into 8 subject areas. Within each subject area the data is then further sub-divided into specific item and subdivided again into constituent components. An example of this is shown in an attached screenshot of the Excel spreadsheet. This has been done to make the Excel spreadsheet easily searchable. It is recognised that a relational database may work differently and the Developer should develop an appropriate architecture that provides the outcome.
For the sake of clarity the input and output should be intuitive or obvious. How this is achieved is up to the Developer.
The project is to convert an existing Excel spreadsheet into a searchable relational database allowing simple searches. Search results should be capable of being printed using the Excel spreadsheet image however the Developer shall be free to suggest an alternative
A visual representation of the top-down system architecture is attached.
A more detailed explanation of the existing system with visualisations is attached.
Form of Submission.
To enable a level playing field amongst applicants, it is requested that tenders are submitted in the format set out in the documents attached.
Related categories:
Software Architecture
Software Testing
MySQL
Database Programming
Database Development