Developing a Database Management System for Coolblog Branch Company

This project focuses on developing a database management system (DBMS) for a Coolblog branch company. The system is designed to enhance data management, improve business operations, and reduce costs by providing a centralized platform for storing, organizing, and managing data. The project details the implementation of features like user authentication, upload and download capabilities for staff certificates, and data digitization processes. The digitization process includes seven phases: instigation, material selection, preparation, conversion, editing, delivery, and support. These phases ensure the secure and efficient management of stock records, employee data, and product information. The project also highlights the importance of certificate digitization for organizational efficiency and the steps involved in scanning, editing, and delivering digital certificates within the system. The system is designed for easy access and use by both managers and staff, enabling efficient stock management and informed decision-making.

Introduction
System software is a kind of computer programme that is intended to run the hardware and
application programmes of a computer. The system software is the interface between the
hardware and user applications, if we think of the computer system as a layered model. The
best-known example of system software is the operating system. All the other programmes on
a computer are managed by the operating system. In this scenario, we develop a database
management system for our branch company. Why does this business need a framework for
database management? This database management system can effectively handle data and
enables users to easily perform multiple tasks. Within a single software application, this system
stores, organises and manages a large amount of information. Besides, use of this system
increases efficiency of business operations and reduces overall costs. Database management
systems are important because they provide a highly efficient method for handling multiple
types of data. Product records, scanning, storage, item and employee records are some of the
data that are easily handled in this form of system.
So, the system that will build is dedicated for manager and staff in manage the stock activities
in this Coolblog. This system is designed specifically for the use of Coolblog staff where an
ID number for each system login is allocated to them. So, the system can only login to those
with an ID number. And the higher quality data, helps to make good and quicker decisions in
our branch. For example, the employer may evaluate the things that the client favours with the
information collected in the system. Even the manager can upload something about Coolblog
product to their employees for easy viewing and monitoring by them. The information can also
be accessed by the employees and they can organise this system and they can also access the
specific upload button and the system download button. So, from that analysis, the employees
can check the amount of stock, the operations, and also know what manager is uploading
something to the systems.

Digitization process.
Digitization process in a company deals with techniques, approaches and technologies used to
capture, maintain, store, archive, and deliver information and documentation relevant to
organisational processes. It deals with tools and strategies which streamlines the unstructured
information of the organisation. Let start with the seven phases of digitization project life cyle:
Instigate Project
To ensure that all stock records systems are secured and can be easily monitored by the manager,
Coolblog record systems have been developed. The systems were then updated to the latest
features that are there to upload and download features. This functionality was updated with
regards to the staff certificate, but the new features are being developed because there are
several staff certificates that they were not aware about this. Another function was developed
to save the certificate's storage space. The certificate will therefore be more secure as it will
retain the validity of the certificate. Certificate digitization have made organisational
management more towards efficient and orderly.
Instigate project
Access and select
material for digitization
Prepare material for
digitization.
Digitize (or convert)
Edit
Deliver
Support

Access and select material for digitization
We then proceeded to the next step of accessing and choosing digitization materials. Accessing
online makes it easier for many others to access only through their connections and computers.
The workers can access this process because they can have this system organised, and they can
also access with used the upload button and the download button. For easy viewing and
handling by their staff, the manager can upload something about the Coolblog product to their
staff. The upload button can also be used by employees directly to track the stock Coolblog
records and can also download valuable documents about their company, suppliers and
customers. Among certificate that want in make digitization is certificate on company
registration, halal certification copies, cleanliness and others. This certificate is very important
because is main thing to be kept by management for future usage.
Preparing material for digitization.
The certificate is the material that must be in the digitization phase after the new features have
been produced. Collect all the physical certificates that they hold and ensure that all physical
certificates are in fine, clean and clear condition.
Digitize (or convert)
The most crucial process in which it is possible to convert the physical certificates to
digitization. Starting with the process of scanning the content, the process of transforming
before the materials can be accessed in the framework that was developed and the latest upload
and download features work well. Scanned by the Canon Scanner from the physical certificates
and turned to PNG format or changed to PDF format before being put on the produced systems.
That means staff don’t need worry about the security risk posed by certificate or another
document being misplaced. As document are store digitally, they can only have accessed by
those staff want to have access to them.

Editing
After the certificates have been scanned, the editing process begins with the crop and rotates
as needed to edit the certificate that has been digitised. The image or document that we scanned
must be through this multiple phase, such as adjusting brightness and contrast to improve
readability, adjusting colour balance to neutralise a colour cast on the pages, clearing or
whitening the background on dull documents and sharp images that are slightly out of focus
required to make the image certificate quality one fine quality and easy to read by employees.
The photos or documents were put in a folder after completing all the editing. The created
folder is put together in accordance with the types and activities of the certificate.
Deliver
After the completion of the whole process of image and pdf certificates, then the time to deliver
the certificate to the systems we have developed. Provide the system with all digital
certification for the Coolblog and other products for employees to use and access if needed.
Support
Finally, support ensures that the digitization phase of what you do on the physical certificate
can be used and works well. The button can be used exclusively for the method of uploading
and downloading. Make sure the process of uploading and updating can be handled by the
workers who use the systems.