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