Relational database
£750-1500 GBP
Paid on delivery
The project is to convert an existing Excel spreadsheet into a searchable PostgreSQL database allowing simle searches.
There are 8 principal asset subject record areas. The number of sub-sections vary within each principal subject area.
A visual representation of the top-down system architecture is attached.
The input GUI is also proposed to act as both an input and a search screen.
Data is to be recorded on a linear mileage basis based on a physical location along a defined distance. The input/output should allow for miles and yards as well as km and metres.
Every input/output will therefore show a start and a finish point, eg. 1m 200 yards to 2m 768 yards. Input/output would be recorded as 001-0200 to 002-0768. Mileage will run from 000 to 999 miles. Yardage will run 0001 to 1759 (There are 1760 yards in a mile so converts to the next mile, e.g. 124m 1760 yds becomes 12mm 0000yds).
The data must allow for the start and finish data to be the same to allow a small length record to be created, (e.g for a weld or a bolt).
Assett data will be coded using a simple numbering system where there are variables, e.g. there are two distinct rail prolfiles each one ith a different descriptor. This coding will be supplied. The code will be either a three figure format or a 3 plus 3 figure format with e.g. 057/317
Assett descriptors to be obtained from separate secure look-up pre-populated read only database with drop down menu.
NO requirement to enter data just set up the database.
Database should be capable of being replicated so that it can be used by a series of different non-related users. Database security to be simple username and password with read/write and read only authorities.
Addendum
Whilst the above has been written to give a best an undertsanding of the requirement as possible, each bidder is free to propose modifications which would result in a better solution. The bidder is the expert who is expected to deliver a suitable and sufficient solution.
Although the original anticipation was the use of a desktop or laptop computer for data entry/recovery, on the basis of some replies, I would be happy to understand if a solution that enables a tablet or mobile phone to be used would be something that would be beneficial as data entry could be made on site rather than collected and input from an office.
For your information cost is a key factor as this system is to be offered free of charge to non-profit making volunteer organisations.
Addendum 2
The intention is to host all the different user database on one server with unique logins for each group - e.g. the name of the group would be the username and their users. would select a password
Project ID: #37556668
About the project
65 freelancers are bidding on average £1199 for this job
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More
Greetings Sean, can Users manage assets categories & sub categories, for which data can be managed? Would you be flexible in your selected budget? As our team estimate is higher and I am not sure how you selected thi More
Hi, my name is Selim. I am the Director of ANC, registered in the UK. We are based in Solihull. We provide end-to-end development solutions, including web development, desktop apps, web apps, and native/hybrid mobile a More
Hi there! My name is Raman and I'm part of the team at CnELIndia that has been hired to assist you with your project. We understand that you're looking to convert an existing Excel spreadsheet into a searchable Postgre More
Hello, I'd be glad to develop the SQL database for you, based on your Excel data. Looking forward to chatting with you soon for more details. Best regards.
Hi there! As I have read, I see you need help professional to convert an existing Excel spreadsheet to a PostgreSQL database for your project and I could help you! I'm a professional Database Administrator and Analyt More
Hi Good evening , I have read the brief details on your job listing . I see you have been looking for someone experienced with Relational DB. Its been 8 years since I have been working on freelancer.com, I have 9 years More
Hi there, Thank you for considering our services for your project. We understand that you require the conversion of an existing Excel spreadsheet into a searchable PostgreSQL database. We have carefully reviewed the p More
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the More
The project requirements seem clear but there isn't information pertaining to relationships on the lookup tables, are you able to share may an empty version of the excel database I can have a look at to map the relatio More
Hello Sir, Regarding the input/output and mileage representation, do you have any specific preferences or requirements for the user interface design that would facilitate easy input of linear mileage data, considering More
SQL expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from t More
Hello, I have read your project description about Database Design. I am an expert in database systems and I have developed many database systems including but not limited to a database system for a School, County Burs More
Hello there! My name is Raushan and I am an experienced freelancer. I understand that you are seeking someone to create a searchable PreSQL database from an existing Excel spreadsheet and I believe I am the perfect per More
Hello! My name is Naman and I am a full-time freelancer with 2 years of industry experience. I have worked on various programming languages such as Django, Django rest framework, react.js, flask and MySQL. I am confide More
Hello, Thanks for reviewing my application. I analyze job requirements for a database developer and I can definitely assist you to put together a PostgreSQL database with search feature. I checked the database require More
Hello there! I am Jaynath and I understand that you are looking for someone to help you convert an existing Excel spreadsheet into a searchable PreSQL database allowing simple searches. I believe I am the perfect fit f More