Need web accessible database: \r\n\r\n1) User & Owner Data Entry forms\r\n2) Searchable Membership database\r\n3) Searchable data entered via forms\r\n4) MySQL Database\r\n\r\nSource code must be provided at completion of project.\r\n\r\nNeed a web app (utilizing a mysql database) that can run on Windows (xp, etc.) & be accessible via web [please advise on \r\nthis requirement]. We don\'t need it hosted... we just want remote usability/access to a single database app.\r\n\r\nData & members must be fully searchable (ie: any data field of a record can help locate that record).\r\n\r\nFORMS:\r\n\r\nI. MEMBERS FORM(s)\r\nI.a. Administrator (two App Editor\'s accounts with equal & unlimited rights - 1 for purchasing organization & 1 for app \r\n\r\ncreator)\r\nI.b. Owners (Main users\' accounts, assignable by Organization editor - unlimited members, unlimited rights to data)\r\nI.c. Affiliate (Limited access/data entry - unlimited members) - NOTE: Affiliate has a \'subclass\' \"R\".\r\nI.d. Non-members (Limited access/data entry - unlimited members) - NOTE: Non-member has a \'subclass\' \"M\".\r\n\r\nI.e. Account details (data record): \r\nI.e.1 Personal Data: First name, Middle name, Last name, Date of Birth, Age, Gender, Race, Personal Email, Phone & Address \r\n(viewable by Owners & Admin only);\r\nI.e.2 Employee Data: EID (Employee ID is Record KEY), Employer, Work location, Workplace phone, workplace email, employee \r\n\r\ntitle, workplace contact, number of years employed by Employer, Employee Status (Employed, Unemployed);\r\nI.e.3 Organization Related Data: number of years with Organization, number of events by Member (Ia-d) [appear as \r\n\r\nindividual links], \r\nnumber of successes by Member (Ia-d), number of failures by Member (Ia-d), Class (Ia-d) & subclass \"R\";\r\nI.e.4 History of Member (Affiliate/Non-member/Owner): Attachable word or pdf docs and ~256 data entry field. Attachments \r\nwill appear accessible/viewable as links;\r\n\r\nI.f. Member sign up form: All data entered by member (or non-member) and approved by Owner; Attachments will be uploaded.\r\nI.g. Member search form: Accessible only by Owners & Admin - ANY data field of Member records will present other related \r\n\r\ndata in associated \'Account Details\' fields [similar to kellybluebook (automobile search) drop down fields, but with more \r\n\r\nversatility. Clicking 1 drop down box of any Account Detail Field will sort the other associated fields (like windows \r\n\r\n\"auto-complete\". While searching an \'EID\' would present an \'exact\' match, searching by \'Employer\' would build a record set \r\n\r\nof all employees for that \'Employer\'].\r\n\r\nI.h. \'Employer\' is itself a record set of various employers with a basic (sequential) unique ID [Editable/Expandable by \r\nOwners & Admin]. Each Member Class would also be a record set or sub database with inherent relationships to all other \r\n\r\ndata.\r\n\r\nII. EVENTS FORM(s)\r\nII.a. Class I Altercation\r\nII.b. Class II Grievance\r\nII.c. Class III Response\r\nII.d. Class IV Resolution \r\nII.e. Class V Organization Meetings\r\nII.f. Class VI Other Meetings\r\n\r\nII.g. All Classes include Event\'s fields: Title, Date, Time, Event Members (I.a-d) [multiple members may be listed for one \r\nevent & subclass must be visible], Address of Event Location, Event specific location (room etc.), [automatic links \r\ndisplayed for other event classifications & member data (I.e.3, etc.)], Upload/Download section for including xls, word, & \r\npdf files - accessible/viewable as links;\r\n\r\nIII.h. Class I Event\'s fields include: Employer, Employee Status, Altercation Description/Notes of Event - Text Field \r\n(Searchable), Significance to altercation;\r\n\r\nIII.i. Class I Event\'s fields include: Employer, Employee Status, Affiliate \"R\" subclass, Non-Member \"M\" subclass, \r\nGrievance Request/Demands - Text Field (Searchable);\r\n\r\nIII.j. Class II Event\'s fields include: Employer, Employee Status, Affiliate \"R\" subclass, Non-Member \"M\" subclass, \r\nResponse - Text Field (Searchable);\r\n\r\nIII.k. Class III Event\'s fields include: Employer, Employee Status, Affiliate \"R\" subclass, Non-Member \"M\" subclass, \r\nResolution -\r\n
I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(Admin),Oracle PL-SQL,Classic ASP, MS SQL (DBA,T-SQL),VB 6.0,VBA,COM/DCOM,VB Script,MS Access, Excel, Macros, Flash (AS2, AS3), Crystal Reports (Designer and Server), ColdFusion