We have an existing Access Database that's loosing information. We found out that the design of the database was poorly done and therefore the loosing of the data. The database was split into the back-end (saved in one of the two computers in the office) and the front-end for the two users we have in the office.
Now we want to create a similar database in MySQL so we can run it from our new [url removed, login to view] account and have a user interface (the front-end) on our website (in a private page) so we can have access from anywhere in the web (eventually we would like to have an android app so my family can access it from their phones).
My family's business is Insurance Sales, all types and from all companies.
The database keeps records of our customers and their insurance packages. We also keep in record the multiple Insurance companies we work for and their contacts. Having this in mind, The database needs to have a many-to-many relationship, since one client can have multiple policies from the same company, and one company can have multiple clients in one policy.
In a policy there is usually three people involved: the person how buys the insurance (the client), the person that the insurance is for (the insured), and the person that will receive the benefits (the beneficiary). All three people can be the same person, but they could ALSO be different people.
First example: for a car insurance policy all three people can be the same person. the client buys coverage for his own car, he is the one who's covered, and hi is the beneficiary in case of repairs.
Second Example: A husband (the client) buys a life insurance for his wife (the insured), in which the beneficiaries are their kids.
In regards of the database design, I will send the tables we've used on the Access database and they can be reorganized as needed. The tables names are in Spanish but I will translate them into English for your reference, but we want keep the Field names in Spanish. Same with the front-end, I will help you to use the proper words in Spanish.
As for the front end, it needs to be an online user interface, with login and password. It doesn't need to have a direct connection with our website, since this is for internal use (instead we'll use a subdomain). The programmer has to be able to recreate the existing queries in the MS access database, design a simple but organized user interface. The new interface does not needs to look the same way as the MS Access database, but it needs to have the same ways to obtain the information.
Since I will upload the old database, the programmer will have a good idea of what we were trying to achieve. We would like to have a design proposal from the programmer before any work is performed, in order so see if the concept is clear. Time frame, approaches, methods and languages are some of the information we need to know upfront.
Please review the database (and its Spanish Version for reference) and prepare a list of questions for me.
24 freelancers are bidding on average $346 for this job
Dear Sir, I am Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,
Hello I can migrate your database form Access to MySQL perfectly and will also tweak for the better performance I am bidding for the database conversion regards Nikhil