A PRACTICAL TRAINING DIARY
on
Advanced Software Engineering Virtual Experience
AT Walmart USA
Submitted to
KIIT Deemed to be University
In Partial Fulfillment of the Requirement for the Award of
BACHELOR’S DEGREE IN
COMPUTER SCIENCE AND COMMUNICATION ENGINEERING
BY
ADITYA CHAKRABORTY 2029184
SCHOOL OF COMPUTER ENGINEERING
KALINGA INSTITUTE OF INDUSTRIAL TECHNOLOGY
BHUBANESWAR, ODISHA - 751024
JULY 2023
Training Diary - June 2023:
June 1st:
- Completed Task 1: Advanced Data Structures.
- Implemented the "Power of Two Max Heap" data structure in Java.
- Tested the heap with various values of x, ensuring the heap property and
performance.
- Prepared the code for submission.
June 5th:
- Started Task 2: Software Architecture.
- Drafted a UML class diagram for the data processors in the pipeline.
- Designed the processor's configuration method and the process method
based on the given requirements.
- Defined the abstract methods for different databases (Postgres, Redis,
Elastic) for insertion and validation.
June 12th:
- Completed Task 2: Software Architecture.
- Double-checked the class diagram for accuracy and clarity.
- Made sure the processor's behavior aligns with the provided requirements.
- Prepared the design for submission.
June 15th:
- Started Task 3: Relational Database Design.
- Drafted an ERD for the normalized relational database based on the given
requirements.
- Defined entities for pet food, pet toys, pet apparel, animals, manufacturers,
customers, transactions, and Walmart locations.
- Created the appropriate relationships between entities.
June 19th:
- Completed Task 3: Relational Database Design.
- Reviewed the ERD to ensure proper normalization and associations.
- Ensured all given requirements were fulfilled, such as product associations,
manufacturer links, customer and transaction data storage, and shipment
tracking.
- Prepared the ERD for submission.
June 22nd:
- Started Task 4: Data Munging.
- Forked and cloned the repository containing the relevant data for the
shipping department's spreadsheets.
- Set up the SQLite database for data insertion.
June 26th:
- Continued with Task 4: Data Munging.
- Wrote a Python script to read, extract, and munge the data from the
spreadsheets.
- Successfully inserted the data from Spreadsheet 0 into the SQLite database.
June 29th:
- Completed Task 4: Data Munging.
- Processed and inserted the data from Spreadsheet 1 and Spreadsheet 2 into
the SQLite database.
- Ensured the data was properly combined, and quantities were accurately
calculated for each product in the shipment.
- Prepared the Python script and the SQLite database for submission.
July 1st:
- Submitted all tasks to the project lead for review.
- Provided the implementation of the "Power of Two Max Heap" data
structure in Java (Task 1).
- Submitted the UML class diagram for the data processors (Task 2).
- Shared the ERD for the relational database design (Task 3).
- Provided the Python script for data munging and the populated SQLite
database (Task 4).