Find Jobs
Hire Freelancers

Access Hierarchical DB creation

$30-250 USD

Terminado
Publicado hace alrededor de 10 años

$30-250 USD

Pagado a la entrega
We need a hierarchical check-box based database where each record (an user) gets to select what geographical regions they are interested in visiting for tourism. e.g., At the top-most layer, the user gets to check off the 6 continents (e.g., Asia, America, Africa, Europe, Australia, Antartica). Then based on their choices here (e.g., say Asia and America are selected), the user is presented with the countries within their choices. Then once countries are chosen, then states and then cities and so on. Key requirements are: a) The names of continents/countries etc., should be flexible and should be read in from an external file. Ideally it should be sufficient to be able to provide a csv file with each node depicted with a "parent" node and a list of "children" nodes. e.g., a country would have a parent node of a continent and its "children" nodes would be the states of that country. b) The user should have the ability to not select or de-select a particular choice. So each one has 3 choices (Yes/No/Dont-Care). If a node is selected to be a "No/Dont-care", all the children and descendents are automatically a "No/Don'tCare". If a user selects "Yes" for a node, then the children nodes need to be presented for a Yes/No/Dont-care choice c) The choice of database, whether mySQL or MSAccess is upto the designer. The tables should retain the hierarchical nature of the selections and not be flat. d) The UI is not super important -- a simple check-box based system is fine. e) Turnaround time is critical -- we are looking to finish this ASAP... f) A simple proof of concept with say 2-continents, 2 nations in each continent, 2 cities in each nation is a good starting point to see. Please describe how your will architect the problem, your turn around time (this is very important)...We intend to move quickly on this.
ID del proyecto: 5573047

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
I'm an expert Access / SQL / database developer with good experience developing hierarchial UIs like the one you mentioned. I read and fully understood your requirements and confirm that I can deliver this to you in 1 day. The way I will do it is to use an Access database with tables that will store the data (continents, countries etc). If you want to import from external CSV file I can build that in as well. The ability to choose the continents, countries etc will be present to the user as an Access form, with ComboBoxes and ListBoxes that allow multiple-selection. If you prefer checkboxes I can do that as well. Thanks for considering my bid. Bests, Larry
$90 USD en 1 día
4,7 (53 comentarios)
5,8
5,8
7 freelancers están ofertando un promedio de $232 USD por este trabajo
Avatar del usuario
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, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your database, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$252 USD en 10 días
4,9 (33 comentarios)
5,2
5,2
Avatar del usuario
Hello sir, Your project is challenging and I've been through this kind of problems. Basically I'll have a table which contains the continents/countries/cities, and each record has a type field. Now I have another table that makes the connection(to get the hierarchy), that will have the parent id and the child id. This ids are continents/countries/cities ids, so that's the way you keep records hierarchical. It has no sense when you look into the DB, but in the frontend, it is extremlly easy: I take the contints and for each one, I get the countries, and for each country I get the cities. Also, a hierarchical display will be done, as you asked. As about the import, you may import the list of countries,continents,cities, but the connection between them will be done manually, via a friendlly interface that I'll code it too(a drag and drop interface where for each continent you select the countries, and for each country, you select the cities). Also, a interface where you add continents/countries/cities will be developed, all these admin features being protected via a admin interface(user/pass). D you want to integrate this one into a developed site? Does that site use a framework? Or is it jut plain php/html? I'm ready for questions. Thank you
$250 USD en 3 días
5,0 (16 comentarios)
4,8
4,8
Avatar del usuario
Hello I will do this job perfectly. Hire me start this work asap Ready to start quality work immediately Regards Nikhil
$309 USD en 12 días
4,7 (15 comentarios)
4,8
4,8
Avatar del usuario
I am a software engineer and I have much of experience for this project. my expertise lies in quality service and delivery on Time i guarantee you 100% satisfaction. kindly if you wants high quality work then as soon as possible contact me. Please give me chance to prove myself.
$246 USD en 7 días
5,0 (1 comentario)
1,8
1,8
Avatar del usuario
Experienced software architect with 20 years in design, development and maintenance of applications. I can provide you a data model and you can use either with Access or with MySQL or any other RDBMS. I can provide you the model in couple of hours from now.
$166 USD en 2 días
5,0 (2 comentarios)
1,8
1,8
Avatar del usuario
Hi, I can promise that if i'll start today or tomorrow and you cooperate to fix target together, then project will be ready at on monday morning or sooner.
$100 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
San Marcos, United States
5,0
1
Forma de pago verificada
Miembro desde mar 18, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.