PastPaper.workedSolution
(a) Two organizational issues that may arise are:
1. User resistance to change: Staff who are accustomed to the old legacy software may find the new cloud system complex and resist using it, leading to decreased morale and operational delays.
2. Retraining costs and downtime: Employees will require training to use the new interfaces and features. Organizing these training sessions can cause a temporary loss of productivity.
(b) Direct Changeover vs. Parallel Running:
- Direct changeover involves turning off the old legacy system and immediately starting the new cloud system. It is cost-effective and immediate, but carries a high risk: if the new system fails, the warehouse operations could shut down completely, causing massive delivery delays.
- Parallel running involves running both systems simultaneously. This is highly secure because the legacy system serves as a backup, but it requires double data entry, which is highly inefficient for a fast-paced logistics environment and doubles the workload of the staff.
- Conclusion: For GreenTrack Logistics, parallel running is preferred despite the cost, as a complete system failure during direct changeover would be financially catastrophic.
(c) Role and Stages of a Data Migration Plan:
The role of the data migration plan is to guarantee that existing inventory data is transferred to the new database accurately, securely, without loss of information, and in a format compatible with the cloud system.
Three stages of data migration:
1. Extraction: Exporting the raw legacy data from the localized database.
2. Transformation: Cleaning, deduplicating, and reformatting the data to match the schema of the new cloud database.
3. Loading and Validation: Importing the transformed data into the new system and running verification tests (such as checksums or sample testing) to ensure data integrity.
PastPaper.markingScheme
(a) [4 marks]
- Award 1 mark for identifying an organizational issue and 1 mark for its explanation, up to 2 issues.
- Issues include: retraining requirements, staff resistance, temporary drop in efficiency, physical workspace reorganization.
(b) [5 marks]
- Award 1 mark for explaining direct changeover (immediate, high risk, low running cost).
- Award 1 mark for explaining parallel running (dual operation, low risk, high cost/effort).
- Award up to 2 marks for applying these methods specifically to the logistics context (e.g., impact of system failure on shipments, double-entry overhead for real-time inventory).
- Award 1 mark for a justified conclusion matching the context.
(c) [6 marks]
- Award up to 2 marks for explaining the overall role of the migration plan (e.g., maintaining data integrity, preventing data loss, structure mapping).
- Award 1 mark for each correctly identified and described stage (Extraction, Transformation, Loading/Validation) up to 3 marks.
- Award 1 mark for explicit technical detail of a stage (e.g., validation via check digit/checksum, data type casting).