Online database and reports creation

Awarded

Situation

I am developing an online database that allows the following 192 reports to be displayed and maintained via a web interface. In addition to faithfully recreating the contents of the reports, the database will provide a mechanism for authorised users to propose changes to individual entries and will allow for the generation of reports.

[url removed, login to view]

Task

1) To select a database engine that is compatible with my siteground web hosting account.

2) To faithfully recreate the template for country reports (with the additional columns shown in the attached)

3) To add additional functionality, including:

- ability for authorised users to propose modifications to specific entries

- ability for administrator to add new questions or countries

- ability for all users to generate reports as described below

4) To populate the database with the information contained in the existing reports

5) To demonstrate the solution operating via my siteground account

Added functionality:

In addition to faithfully recreating the existing reports, and important part of this project is the additional functionality sought through the use of an online database. This includes the following requirements:

a) To provide a mechanism for authorised users to propose changes to entries via either a page that shows one question for all countries or that shows all questions for one country. After such proposed changes are made, a mechanism should exist where these proposed changes can be shared with an external authorising group before being accepted or rejected or deferred. Where an administer assesses the change as "accepted" or "deferred", an additional column should appear on the country report showing what change was proposed.

b) To allow scores to be set for each question, such as "mandated" and "optional". It should be possible to generate a report that for each country states how many "optional" and "mandated" entries exist in each category as a percentage of the total number of questions. (This report should be sortable either alphabetically or by value)

c) To enable export of country reports as PDFs

Result

The database, which will be hosted on a siteground account, will allow any user to view the status of 1540 implementation in each country and thematically. It will also allow authorised users to propose modifications to the entries.

Skills: Database Administration

See more: web developing online, online web developing, online report generation, generation web creation, my reports, faithfully, Database administrator, database question, generate online report, populate database, developing web interface, siteground hosting, online database web, export report pdf, pdf report generation, project web database administration, database web developing, online database creation project, web database administration project, pdf view online, database scores, implementation database category, view pdf online, states database, interface existing web database

About the Employer:
( 5 reviews ) lon, United Kingdom

Project ID: #5516977

8 freelancers are bidding on average $769 for this job

elboukharimu

Hi, I'm very interested helping you creating your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio More

$900 USD in 21 days
(16 Reviews)
4.7
ngscoder

Hi Thank you for posting this project. With 250+ projects on freelance our work quality speaks in itself. We have seen your detailed requirements are happy to be the part of this project. We would suggest you to More

$824 USD in 20 days
(3 Reviews)
3.7
Prateekagra

hi i have a sound knowledge of sql development and designing and have 7 years of experience tell me when we can discuss about your project in more depth

$666 USD in 10 days
(1 Review)
2.9
Aloknano

A proposal has not yet been provided

$1000 USD in 9 days
(1 Review)
0.0
cederlie

I am a Technologist, with emphasis in Databases. I have experience as an Architect, Administrator, and Developer. Therefore, I have the knowledge to build and support Enterprise Database Systems from the ground up. I h More

$750 USD in 30 days
(0 Reviews)
0.0
darkknight2012

hello mr kclalpha, I am not sure I knew Siteground, but I have a lot of experience in PHP, MySql, Smarty, HTML, CSS, Javascript, jQuery, Ajax. All of them are embed in Wordpress. By the way i will send you some of More

$300 USD in 20 days
(0 Reviews)
0.0
malakoder

A proposal has not yet been provided

$824 USD in 10 days
(0 Reviews)
0.0
yolindi12

My ability to learn and follow instructions to the T. My skills in excel and in different formats are very good. And you are more than welcome to contact me.

$888 USD in 15 days
(0 Reviews)
0.0