Need web accessible database:
1) User & Owner Data Entry forms
2) Searchable Membership database
3) Searchable data entered via forms
4) MySQL Database
5) Prefer VB.net or java app
Source code must be provided at completion of project.
Need a web app (utilizing a mysql database) that can run on Windows (xp, etc.) & be accessible via web [please advise on
this requirement]. We don't need it hosted... we just want remote usability/access to a single database app.
Data & members must be fully searchable (ie: any data field of a record can help locate that record).
I. MEMBERS FORM(s)
I.a. Administrator (two App Editor's accounts with equal & unlimited rights - 1 for purchasing organization & 1 for app
I.b. Owners (Main users' accounts, assignable by Organization editor - unlimited members, unlimited rights to data)
I.c. Affiliate (Limited access/data entry - unlimited members) - NOTE: Affiliate has a 'subclass' "R".
I.d. Non-members (Limited access/data entry - unlimited members) - NOTE: Non-member has a 'subclass' "M".
I.e. Account details (data record):
I.e.1 Personal Data: First name, Middle name, Last name, Date of Birth, Age, Gender, Race, Personal Email, Phone & Address
(viewable by Owners & Admin only);
I.e.2 Employee Data: EID (Employee ID is Record KEY), Employer, Work location, Workplace phone, workplace email, employee
title, workplace contact, number of years employed by Employer, Employee Status (Employed, Unemployed);
I.e.3 Organization Related Data: number of years with Organization, number of events by Member (Ia-d) [appear as
number of successes by Member (Ia-d), number of failures by Member (Ia-d), Class (Ia-d) & subclass "R";
I.e.4 History of Member (Affiliate/Non-member/Owner): Attachable word or pdf docs and ~256 data entry field. Attachments
will appear accessible/viewable as links;
I.f. Member sign up form: All data entered by member (or non-member) and approved by Owner; Attachments will be uploaded.
I.g. Member search form: Accessible only by Owners & Admin - ANY data field of Member records will present other related
data in associated 'Account Details' fields [similar to kellybluebook (automobile search) drop down fields, but with more
versatility. Clicking 1 drop down box of any Account Detail Field will sort the other associated fields (like windows
"auto-complete". While searching an 'EID' would present an 'exact' match, searching by 'Employer' would build a record set
of all employees for that 'Employer'].
I.h. 'Employer' is itself a record set of various employers with a basic (sequential) unique ID [Editable/Expandable by
Owners & Admin]. Each Member Class would also be a record set or sub database with inherent relationships to all other
II. EVENTS FORM(s)
II.a. Class I Altercation
II.b. Class II Grievance
II.c. Class III Response
II.d. Class IV Resolution
II.e. Class V Organization Meetings
II.f. Class VI Other Meetings
II.g. All Classes include Event's fields: Title, Date, Time, Event Members (I.a-d) [multiple members may be listed for one
event & subclass must be visible], Address of Event Location, Event specific location (room etc.), [automatic links
displayed for other event classifications & member data (I.e.3, etc.)], Upload/Download section for including xls, word, &
pdf files - accessible/viewable as links;
III.h. Class I Event's fields include: Employer, Employee Status, Altercation Description/Notes of Event - Text Field
(Searchable), Significance to altercation;
III.i. Class I Event's fields include: Employer, Employee Status, Affiliate "R" subclass, Non-Member "M" subclass,
Grievance Request/Demands - Text Field (Searchable);
III.j. Class II Event's fields include: Employer, Employee Status, Affiliate "R" subclass, Non-Member "M" subclass,
Response - Text Field (Searchable);
18 freelancers están ofertando el promedio de $363 para este trabajo
Hi there. I am senior developer from Vietnam. I have been working on this site for 2 years. I am interested in your [login to view URL] let's me help you.