BKAS3053: DATABASE MANAGEMENT SYSTEMS
SECOND SEMESTER SESSION 2018/2019 (A182)
DR ROSLI BIN MOHAMAD
Company Name: UUM Kachi Bundle Centre
Proposed System: Bundle Assembly System
Group Name: InvictusNO. NAME MATRIC NO.
1. MUHAMMAD LUQMAN HAKIM BIN JOHAR 255434
2. MOHAMAD AIMAN IQUAN BIN MOHAMAD AFANDI 256180
3. NURUL NAJWA BINTI RUSLI 256165
4. SITI ROGAYAH BINTI ISMAIL 256310
5. NUR AINA NABILA AZIZ 256312
TABLE OF CONTENT
The Proficiency of UUM Kachi Bundle Assembly System.
The mind of this enactment is to frame proficiency of bundle assembly as we ordinary divers complaints encircling labors supposing by UUM Kachi Parcel.
We sketch and unfold autonomous QR System. The QR Scheme must be choice to relief the customers to garner their bundles. To frame this a substance the plan get be documented as air-tight and as precisely as potential, thus providing after groups delay all the comprehension required to redeep the unfoldment of this scheme.
To confront out the deep amount of the running arrangement.
To mend the power labor of bundle assembly.
To curtail era of customers assembly.
To unfold the relationship delay customers
To be serviceserviceable to compose the powerful QR System.
To mend the guarantee of the bundle assembly.
To settle employment rules of UUM Kachi Bundle Centre.
To sketch Entity Relationship Diagram.
Uni Storage was recognized in 2009 as an Entrepreneurship -Techno Research at the School of Computer Science, Universiti Sains Malaysia, 11800 Penang, public as UniStorage Malaysia and open at Universiti Sains Malaysia, Master Campus, 11800 Penang, through the University’s Entrepreneurship Center (EPIC) .
UniStorage provides Mail and Herald labors through receiving, arrangementing, storage, packing and dispensation activities or acquiescence of learner aces and campus citizens conjuncture in the university. In abstracted, UniStorage provides distinct program of transport of comprehension through distinct programs including Training of Entrepreneurship Students, Agro Product E-Commerce, Workshop of Custom Affair such as Basic Course, and others delay Government and Non Government Departments Government (NGOs) such as the Malaysian Customs Senior Officers Association (PERKASA), national Communities to second Customs Customers’ Customs, specially wonderificance and ship-produce trading activities. Increased e-commerce shapeless university graduates is increasing from era to era.
UniStorage has a network of distinct national and interdiplomatic shipping and logistics companies. Through this network, UniStorage bridges customers delay industries through national trading. Distinct national and interdiplomatic companies are equipollent to closely 3,000 branches worldwide. There are as-well Departments and Non-Governmental organizations availserviceable to second these industrial activities to be realized in universities, specially in distinct Public Universities. UniStorage customers can purport their pleasure delay the labors offered.
UniStorage-UUM located at UUM Bundle Center, Universiti Utara Malaysia was working by Yg Berusaha Prof. Madya Dr. Hendrik Lamsali, Deputy Vice-Chancellor of Learner Affairs and Alumni, Universiti Utara Malaysia by oblation a difference of labors installed on mail and herald activities, liquidation contrarys, bus tickets, photocopies, contemplatening and others at UPC and its branches at Universiti Utara Malaysia. ‘Learn & Earn’ is a concept that is run in the UPC to mature cognizant agree in the national community
The customers can be disjoined into two types which is registered customer and unregistered customers. To be registered customers, they insufficiency to login UUM Bundle website and appoint the advice required such as email, spectry and matric estimate.
As Herald sent bundles to the UUM Kachi Bundle Centre, the staffs get key in facts such as customers matric estimate, spectry, IC estimate, tracking estimate, corporation of the chattels, continuance of apparition and types of the ace into Microsoft Excel. Then, staffs get quickly email the registered customer to instruct the apparition of their bundles. For unregistered customer, they can bridle by using tracking estimate.
Next, customer can garner their bundles at UUM Kachi Bundle Centre contrary by giving their matric estimate and tracking estimate. The staff get confront the bundles installed on that advice. Customers insufficiency to wonder the inventory spectry as the praise of receiving bundles. The staffs then get upcontinuance the bundles archivess that had been ordinary by the customers. Customer liquidation installed on abounding installed on the condition 1.1.
One staff can feel divers bundles
Each bundle can be feel by one staff
Each bundle has one bundle particular
Each bundle particular for each bundle
One customer can frame divers liquidation
Each liquidation can be performed by one customer
One customer can bear divers bundleFLOWCHART FOR CURRENT SYSTEM
UUM Kachi Bundle Centre use Microsoft Excel as their deep scheme to abundance facts that narrate to the customer and bundle. Staff get key in facts into Microsoft Excel and sculpture out as hardcopy. The hardobservation are solely use to identify which customer has extract up their bundle and which are not. As-well for softobservation facts. Staff get upcontinuance which bundle has been extracted.
The weaknesses of running scheme are the contrariant between registered and unregistered customer are solely installed on low liquidation abounding and admit email from UUM Bundle Centre of apparition bundle for registered customer. There is no unfair specialties for registered customers. Most of customers as-well complaints that they insufficiency to queue up and hold for a crave era until customers turns succeed. They as-well insufficiency to bridle their spectry in the inventory spectry which is one observation solely for a continuance of apparition bundles.
The coming limitation that we deficiency to intimate in enjoin to mend the bundle assembly scheme at UUM Kachi Bundle Centre is once the staffs ordinary bundles delivered by herald, the staffs get archives the facts ordinary on the bundle which are customers spectry and phone estimate. The staffs as-well get add another advice such as labors accuse for the bundle (installed on power) and the command of the bundle abundanced for entire bundle in QR Command devise. Then, the staffs get propagate QR Command for entire bundle and impel the missives to the customers encircling the apparition of their enjoined aces and join for QR Command representation by using customers phone estimate.
For the assembly, customers can garner their bundles as before-long as they admit missive and QR Command join from UUM Kachi Bundle Centre. Once the customers attain at UUM Kachi Bundle Centre, customers get contemplate the QR Command using QR Scanner supposing at the contrary. After the QR Command contemplatened, it get automatically inspection the facts of the bundle abundanced in QR Command devise. The staff get garner the bundle at the shelves and ignoring it to the customer. After that, the staff get admit the liquidation installed on the accuse decreed by UUM Kachi Bundle Centre. Then the staff get upcontinuance the changes in the standing of the bundle and archives the admitr spectry.
FLOWCHART FOR FUTURE REQUIREMENT SYSTEM
One staff can feel divers bundles.
Each bundles can be feeld by one staff.
Each bundle has one particular.
Each particular for one bundle.
Each bundle has one QR Code.
One QR Command point to one bundle.
One QR Command for one customer.
One customer can bear divers QR Code.
One customer can frame divers liquidation.
Each liquidation can be performed by one customer.