Answer the question according to the case study. 1. Explain data migration activities from old data stored in MsExcel files into the new database (MySQL).

Case study Sales application at UMKM PT A is appointed by a UMKM that sells agricultural products to create a Sales application. The project begins with the signing of a work contract. From the work contract, it is known that the application was built for 150 million, will be built within 22 weeks. The application module includes customer data collection, customer data search, item data collection, item data search, payment, delivery of goods, customer testimonials, creation of 5 reports, and customer product tracking. The work schedule can be seen in pict 5. UMKM Application. It can be seen that the project plan stages are carried out in 1 week, Design is carried out 4 weeks, Development is carried out 9 weeks but in realization, there is an additional 1 week, Testing tasks are scheduled for 16 weeks but in realization, the schedule becomes 14 weeks because UAT activities are not carried out During the last 2 years of operation, previous UMKM operational activities used MS Word and MS Excel. they requested that some data such as customer data and goods data recorded in the MS Excel file could be transferred to the new system in MySQL data. Testing activities are carried out at the unit test and system test stages by obtaining a satisfactory performance score with only 5% bug findings at each stage of the test and then the tester manager issues a system release document as evidence that the UMKM Sales application is ready to be implemented on the user server. 2 duration 1 2 WEEK 5 6 7 8 9 0 1 2 3 3 4 4 5 6 7 B 9 0 1 2 3 2 x 2 x 1 x x X 5 5 5 5 1 X X X x X x x x X x X unit sub task project plan project proposal document review analysis complete design design process design database interface design specification design design complete Design REAL development development system integration system development complete Dev REAL testing unit test system test UAT system release Testing complete Tesing REAL implementation installation training migration Imp REAL X X X x x x x x x x * * * x x x x X x x x 5 3 3 x X Pict 5 GANTT Chart UMKM Application