Work Package

Work Package

Work Package id:

1.1.1.1. Customer Account Information

Package History:

Drawing back Work Package 3.1.1.1. Customer Account Information is part of sub work activity 3.1.1. Customer Information, activity 3.1. Knowledgebase Database, and project deliverable: 3. Executable Source Code of the project, Process and Communication Consolidation.

Description:

Work Package 3.1.1.1. is activity of building the database tables to collect the customer data and store in database. The tables should be designed with relationship for data search in the database.

Work Package, Customer Account Information is based on the activities as build database tables by gathering the information data and create relationship between the information tables and other database tables. Upon completion of building the database, populate the database with customer data.

Deliverables:

A populated database with customer information and with capability to search the data within the database and display all related information.

Activity ID | Activity Description | Predecessor(s) | Successor(s) | Number of People, type | Duration |

3.1.1.1.1 | Build Database Tables (referencing Data Dictionary) | 2.3.3.2. | 3.1.1.1.2, 3.1.1.1.3 | 1 Database Administrator, 1 Programmer | 10 days |

3.1.1.1.2 | Gather Customer Account Information Data | 3.1.1.1.1 | 3.1.1.1.5 | 1 System's Analyst | 21 days |

3.1.1.1.3 | Create Relationships between Account Information tables (referencing ERD) | 3.1.1.1.1 | 3.1.1.1.5 | 1 Database Administrator, 1 Programmer | 7 days |

3.1.1.1.4 | Create Table Relationships with other tables in database | 3.1.1.1.1 | 3.1.1.1.5 | 1 Databsae Administrator, 1 Programmer | 4 days |

3.1.1.1.5 | Populate Tables with Customer Data | 3.1.1.1.2, 3.1.1.1.3, 3.1.1.1.4 | end | 2 Database Administrator, 2 System's Analyst | 4 days |

Roles based on Skills:

Activity will require individuals with certain skillset who have knowledge of...