Encerrado

M2M

The purchaser is new to IPad programming and requires a simple example of a many-to-many database. The database will comprise three tables:

1. Widgets

2. Functions

3. WFJunctions

xxxEach widget may be associated with any number of functions, and each function may be performed by any number of widgets. WFJunctions defines these relationships.

## Deliverables

**Implementation of a simple many-to-many database.**

The purchaser is new to IPad programming and requires a simple example of a many-to-many database.

The database will comprise three tables:

1. Widgets

2. Functions

3. WFJunctions

The Widgets table will comprise three fields:

| **Field** | **Data Type** |

| Widget Unique Identifier | Long |

| Widget Category | Char |

| Widget Description | Text of unlimited length |

The Functions table will comprise two fields:

| **Field** | **Data Type** |

| Functions Unique Identifier | Long |

| Functions Description | Text of limited length |

The WFJunctions table will comprise four fields:

| **Field** | **Data Type** |

| WFJunctions Unique Identifier | Long |

| Widget Unique Identifier | Long |

| Functions Unique Identifier | Long |

| Widget Usefulness | Boolean |

? Each widget will be linked to at least four functions.

? Each function will be linked to at least one widget.

? The usefulness of the widget in the performance of each of its functions will be recorded as a boolean in the WFJunctions table.

? For development purposes, the length of the Widget Description field can be limited to 500 characters and the length of the Functions Description field can be limited to 250 characters.

The bidder will provide an application which contains:

? At least 10 items in the widget table.

? At least 50 items in the functions table.

The application will have the following functionality:

**Display Functionality:**

The user will be able to filter the widgets selected for display on the basis of the widget category. Once this filter has been set, the user will be able to view a description of each widget together with a description of each of its associated functions.

The usefulness of each function (in the context of the widget) will be indicated by a check box.

This window will include a navigation interface with, at least, <First>, <Last>, <Next> and <Previous> functionality.

**Edit Functionality:**

An editing function which permits the user to change the content of each field in the display window will be provided.

The user will also be able add or delete relationships between the widgets and functions tables by adding or deleting items in the WFJunctions table

**Add Functionality:**

The user will be provided with the ability to add new widgets to the Widgets table together (optionally) with new functions to the functions table.

When a new widget is added, a validity check will be made to confirm that at least four Widget-Function relationships have also been defined in the WFJunctions table.

**Delete Functionality:**

The user will be provided with the ability to delete widgets from the Widgets table. Deletion will also remove all items which contain the corresponding Widget Unique Identifier from the WFJunctions table, together with those items in the Functions table which are **only** related to the deleted widget item.

**Commenting:**

The developer will include verbose comments within the code.

Habilidades: Android, Blackberry, Engenharia, iPhone, Mobile App Development, Gestão de projetos, Arquitetura de software, Teste de Software

Ver mais: simple mobile number change, programming boolean, boolean programming, permits, m2m, confirm remove, performance engineering, simple tables ipad, simple programming ipad, field development project, implementation database category, filter widget, ipad project management, ipad simple interface, ipad data management, project management ipad, ipad application table view, ipad linked database, simple widget development, display data table ipad, display table ipad application, data management ipad, ipad application development project, simple ipad database, display data ipad

Acerca do Empregador:
( 11 comentários ) Sydney, Australia

ID do Projeto: #3002843