- Personal Database Project for Kumon International Tuition Centre.
- Project is now in full use within one branch.
- Kindly be advised that all employee and customer information contained herein has been substituted with simulated data in accordance with the privacy policy of the British Computer Society. For further details, please refer to the document titled "Data Privacy Notice" available at the following link: https://www.bcs.org/media/7409/data-privacy-notice.pdf.
- The objective of this project was to develop a relational database that facilitates Kumon and its instructors in efficiently accessing and overseeing records of both existing and new customers.
- Upon commencing my tenure at the tuition center, it became evident that the management, predominantly consisting of senior individuals, relied on manual record-keeping using pen and paper for customer information. As the demand for our services surged, it became apparent that they were grappling with the arduous task of effectively managing customer data. Recognising this challenge, I took the initiative to introduce and implement the concept of a relational database, enabling seamless management of customer information. Furthermore, I provided comprehensive coaching sessions to familiarise the staff with the database, ensuring its smooth utilisation and maximising its benefits for the center.
- I developed a set of standard queries that were subsequently transformed into views for the database, enabling individuals of varying skill sets and computer proficiency to effortlessly utilise the database.
- MySQLWorkbench was used to create the database, tables and add records using SQL.
- DataGrip was used for writing queries and creating database views to store results to important queries.
- Lucidchart was used to create Entity Relationship (ER) Diagrams for clients to view and visualise their database. These diagrams were also used as part of comprehensive coaching provided to clinets.
- Git was used as a Version Control System (VCS) to maintain a history of the software project.
- GitHub was used to host and share code repositories with clients as agreed in the release & sprint planning meetings.
- An Entity Relationship (ER) Diagram was created to provide a clear and intuitive visual representation of the structure and relationships within the database which was used in sprint & release planning meetings.
