Several Input Modules -- PHP, SQL server database -- output also in graph, search fuctionality
please see below more details of modules and requirements:
The database must encapsulate data for the following divisions:
? Business development
? Trade
? Foreign Investment
? OIDGF
? Monitoring? & Compliance
? Finance and Administration
## Deliverables
Requirements:
The database developer must consider the following:
User friendly: very simple, to the point, but very effective
Statistics : the database must be able to generate reports (pie graphs, line graphs, tables, distribution curves ....etc) for data analysis.
Contact system: a consistent recording of client/contact information for each division.
Import/Export data: be able to import and export data from other applications. Particularly excel for stats
Reference system: A proper client referencing system which may differ for each division.
Legal requirements:
Interface: Interface for this database should be attractive, professional in presentation and well structured to increase the accessibility, acceptability and readability.
Details User Input/Output fields:
**Foreign Investment**
**Input:
**SearchModule Company Reg #:
Date:(date)
Name of enterprise: (text)
Village of enterprise:
Company Status: (check box)
Defunctional/Active/Inactive/revoked
Sector: (check box)
Marine/Finance/Transport/Marine/ Unit Titles/Management/Manufactoring/Legal
Companies representative:
Profession: (text)
Name:(text)
Phone: (integer)
Mobile: (integer)
Fax: (integer)
Email: (linked text)
Capital investment: (currency)
Shareholders:
Name of shareholder(text)
% of shares of each shareholder(float)
Nationality of each shareholder(text)
Phone/Fax/Email/Postal
(Add a shareholder numerous times to database)
Contact Information of the company:
Company Phone(integer)
CompanyMobile(integer)
Company Fax(integer)
Company Email(text linked)
Postal of company:(text)
Conditions imposed: (text fields)( Numerous conditions imposed)
Levy Exemptions: date(date field)/conditions(text)/amount of levy(currency)
History : Date(date):
Notes/Decision made by Board(text):
Amount of Levy exempted: (currency)
Attachments: urls/add documents to database.
**Output:**
Graphical Analysis
Total Capital investment by sector/date/ Village
Total Levy exempted by date/value/ sector
**Monitoring & Compliance**
**Input:**
SearchModule
Name of Enterprise: Company Reg #:
Sector:
Annual Returns:
Date:
Site Visits:
Phone/Fax/Email/Postal
Business Premises :
Village:
Last date of site visit:
Date of conditions
Terms & Conditions
Expiry date
Checks annual returns by date
Conditions imposed: (Numerous text fields)
History Note: (text)
Shareholders:
Name of shareholders(text)
% of shares of each shareholder(float)
Contact Details of shareholders:
Phone/Fax/Email/Postal
Legal Representative: (text)
Attachments: urls/add documents to database.
**Output:**
Graphical analysis
Number of site visits by date/sector/village
**Outer Island Development Grant Fund (OIDGF)**
**Input:**
SearchModule: Client Reference Numer:
Date: (date)
Name of Client:
Contact Details:
Phone/Fax/Email/Postal
Name of Enterprise: (text)
Island: (text)
Approved/Declined: (check box)
Sector: (checkbox)
Marine/Finance/Transport/Marine/ Unit Titles/Management/Manufactoring/Legal
Project Name:(text)
OIDGF Contribution: (currency)
Personal Contribution: (currency)
Project Cost: (currency)
**Output:**
Graphical analysis
OIDGF approvals by island: Number OIDGF Contribution($) Personal Contribution($)
OIDGF approvals by sector: Number OIDGF Contribution($) Personal Contribution($)
**Trade**
**Input:**
SearchModule Client Reference Numer:
Date: (date)
Client Name: (text)
Contact Details: (text)
Phone/Fax/Email/Postal
Importer/Exporter: (checkbox)
Value of Import/Export: (currency)
Sector/Industry: (Checkbox)
Marine/Finance/Transport/Marine/ Unit Titles/Management/Manufactoring/Legal
**Output:
**Graphical analysis
Number of Importers/Exporters by date/sector/
Value of Import/Export by date/sector
**Business development
**
**Input:**
SearchModule Client Reference Numer:
Clients Name: (text)
Gender: (text)
Name of Business: (text)
Sector: (checkbox)
Marine/Finance/Transport/Marine/ Unit Titles/Management/Manufactoring/Legal
Inquiry: (text)
DoB: (date)
Contact Info:
Phone: (integer)
Fax#: (integer)
Email: (text)
Postal: (text)
Business Premises (name, village):
History Note:
Date of visist: (text)
Purpose of visit: (text)
Comments by Advisor: (text)
**Output:**
Graphical analysis
Graph of the number of visits per month
Graph of the number of business inquiries per month