- Problem
Our topic that we chose for this Database Systems Final Project is Inventory Control Management System. The reason behind why we chose this topic is that upon our group member’s experience and knowledge, many firms, especially new and smaller businesses, have trouble managing the accounting of their own products when running from day to day. This includes the calculation of their stocks (restocking and sales), removing/returning defective products, and even managing the available catalog. This leads to the inaccurate warehouse stocking reports, which may further lead to inaccurate financial reports, or even bad customer service (customers may be promised that their desired products are in stock but rather it’s out of stock or doesn’t fulfill the required quantity), as well as bad reputation to the company. Moreover, this becomes an even more sophisticated problem for businesses running on abundance of sales every single day.
2. Target Market
Our program is mainly made for wholesalers, supermarkets or other kinds of stores. Its ability to input and store multiple products, staff and multiple store branches make the program applicable for all of them. Not to mention, it can be used also for small businesses or any businesses that require inventory management systems.
3. Member’s Role
For this project, our group had agreed to appoint Sunny as our project manager. She is the main coder in our group, where we always brainstormed altogether via share-screen video calls while she was coding on her computer. (The reason why we came up with this plan was because working on a database project online causes a lot of unprecedented issues; according to Mario, Jeco, and Lukman, we have much trouble in accessing, managing, coding, and even testing the database program through our own computers. The situation may be otherwise if we were to work on this project offline, as we can reach out to hands-on help from others.) Since the program is also working perfectly on her computer, she also records the running program for the final project video. Altogether, we brainstormed and compiled our knowledge to create the final report together.
For the other members, Mario, Jeco, and Lukman, aside from brainstorming through video call for the program, our tasks are based on:
- Mario: coding java (share screen vid call), making final report, designing ERD and its relations, project idea & background & solution
- Jeco: coding java (share screen vid call), making final report, designing ERD and its relations, create & design presentations (proposal)
- Lukman: coding java (share screen vid call), create query for inventory system (save, delete, update, modify, add), making final report
As seen in the bulleted points above, most of the tasks are overlapping for each member, this is because we are mostly in charge of the assigned task.
Youtube link : https://youtu.be/A8QtFxYXK3A
