Database Project

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