Database Project

已关闭 已发布的 Sep 25, 2008 货到付款
已关闭 货到付款

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

工程 微软 微软Access MySQL PHP 项目管理 软件构架 软件测试 SQL 用户接口 / IA 视窗桌面

项目ID: #3257603

关于项目

36个方案 远程项目 活跃的Oct 17, 2008

有36名威客正在参与此工作的竞标,均价$1761/小时

xenonartws

See private message.

$7225 USD 在14天内
(125条评论)
8.4
LeadSoft

See private message.

$6800 USD 在14天内
(42条评论)
8.1
fastudiovw

See private message.

$722.5 USD 在14天内
(734条评论)
7.5
shaddadfalcon

See private message.

$2550 USD 在14天内
(111条评论)
7.0
acumensoftUK

See private message.

$4250 USD 在14天内
(22条评论)
6.7
helvivw

See private message.

$1275 USD 在14天内
(64条评论)
7.0
eye4tech

See private message.

$2252.5 USD 在14天内
(41条评论)
7.0
suthernsoftware

See private message.

$4760 USD 在14天内
(61条评论)
6.6
MosesImmanuvel

See private message.

$2975 USD 在14天内
(59条评论)
5.8
instantcodervw

See private message.

$748 USD 在14天内
(60条评论)
5.7
sunjove

See private message.

$944.35 USD 在14天内
(32条评论)
5.4
pegasusforce

See private message.

$935 USD 在14天内
(4条评论)
4.9
vw6977538vw

See private message.

$425 USD 在14天内
(98条评论)
5.1
adeeylx

See private message.

$1275 USD 在14天内
(12条评论)
4.7
xxxxxxxxxxxvw

See private message.

$637.5 USD 在14天内
(11条评论)
4.6
khanusman

See private message.

$425 USD 在14天内
(25条评论)
4.4
dipankarsoft

See private message.

$425 USD 在14天内
(11条评论)
3.6
arkotechvw

See private message.

$1020 USD 在14天内
(4条评论)
3.6
klaus71

See private message.

$1700 USD 在14天内
(5条评论)
3.3
noumanpak

See private message.

$510 USD 在14天内
(9条评论)
3.0