Closed

web app db

This project received 19 bids from talented freelancers with an average bid price of $356 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
19
Project Description

Project Description:
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 [url removed, login to view] 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).

FORMS:

I. MEMBERS FORM(s)
I.a. Administrator (two App Editor's accounts with equal & unlimited rights - 1 for purchasing organization & 1 for app

creator)
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

individual links],
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

data.

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);

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online