5330916-27921900-541111-28747300 COMPUTER-BASED LOGISTICS INFORMATION SYSTEM FOR JUNER ENTEPRISES A CAPSTONE PROJECT Presented to the Faculty of the College of Computer Studies of Capitol University Cagayan de Oro City In Partial Fulfillment of the Requirements for the Degree Bachelor of Science in Information Technology byWAHLENLOU C

5330916-27921900-541111-28747300
COMPUTER-BASED LOGISTICS INFORMATION SYSTEM
FOR JUNER ENTEPRISES
A CAPSTONE PROJECT
Presented to the Faculty of the
College of Computer Studies of Capitol University
Cagayan de Oro City
In Partial Fulfillment
of the Requirements for the Degree
Bachelor of Science in Information Technology
byWAHLENLOU C. OBA-OB

APPROVAL SHEET
This Capstone Project entitled: ERP SYSTEM FOR THE JUNER ENTEPRISEs” prepared and submitted by WAHLENLOU C. OBA-OB in partial fulfillment of the requirements for the degree BaCHELOR OF SCIENCE in Information Technology, has been examined and is recommended for Oral Examination.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

GLENN A. BALDELOVAR
Adviser
PANEL OF EXAMINERS
Approved by the Committee on Oral Examination with a grade of ________.CYRIL JANE C. RANIDO, MIT, MIM
Chair
MILO S. CAGANDAHAN
Member
NELSON G. LIWANEN ALLEN JAMES C. GOMEZ
Member MemberApproved and accepted in partial fulfillment of the requirements for the degree Information Technology.

CYRIL JANE C. RANIDO, MIT, MIM
Dean, College of Computer Studies
March 9, 2017
(Date of Final Defense)
Acknowledgement
I would like to thank for all the support in making our capstone done specially our adviser Sir Glenn Baldelovar for guiding and advising us doing our capstone and also to.Sir Benzar Grepon in giving some tips in our documentation and also my group(Bea Montejo, Jemimah Bagabaldo, Mario Canas, Garfunkel Palasan, Rotsen Glodove) making our the system for Juner Enterprises and also to juner enterprises for allowing us to do a research and the offer for the computer based system in there transaction and also to our Dean which very patient and kind to us.

Abstract
Logistics information system is a system of records and reports used to aggregate, analyze, validate and display data (from all levels of the logistics system) that can be used to make logistics decisions and manage the supply chain.

Logistics Information System handles delivery information first starts by accepting the orders from the sales and the billing will billed the client order. Logistics will accept the billing statement information along with the order delivery information once the order is going to be delivered it will now indicate the actual delivery time and date to Sales Information System & Billing Information System. Delivery Status will indicate that the order has been delivered if the product has been damage the Billing will get the billing id and quantity damage and deduct the amount paid. All the Information that is connected to logistics will be shown in the reports.

Juner Enterprises is doing a manual transaction in there company and they been doing it many years, we have a problem with their transactions and we proposed a study in there company to create a computer based system which help their company for faster transactions and easy to use. They have been in the business for around 19 years selling of Nata de Coco, Kaong and Seaweeds. They cater to supermarkets like Gaisano and Ororama and all over Mindanao. With this strategy, security and safety of the records are still being compromised due to misplacement of data or loss of data that would be very difficult to find. This study will give the company a great benefit by developing a computerized-based information system especially in logistics information system with delivery information/billing information, delivery status and delivery reports including the damaged product which would help the company for the transaction more securely by storing their data on a database server.

TABLE OF CONTENTS
Page
TITLE PAGE APPROVAL PAGE ACKNOWLEDGEMENT ABSTRACT TABLE OF CONTENTS LIST OF TABLES LIST OF FIGURES CHAPTER 1 THE INTRODUCTION Introduction Statement of the Problem General Objectives Specific Objectives Significance of the Study Scope and Limitations of the Study Definition of Terms 2 REVIEW OF RELATED LITERATURE AND STUDIES Enterprise Resource Planning(ERP) Logistics Information System 3 RESEARCH METHODOLOGY The Research Design Requirement Gathering/Specification Analysis and Design Development Testing Maintenance User Acceptance Test (UAT) System Evaluation 4 RESULTS AND DISCUSSION Requirement Analysis Requirement Specification Development User Acceptance Test Deployment Evaluation 5 SUMMARY, FINDINGS, CONCLUSION, AND RECOMMENDATION Summary Findings Conclusion Recommendation REFERENCE APPENDICES Appendix A: Questionnaire Appendix B: User Acceptance Test (UAT) Matrix Appendix C: System Usability Scale for Evaluation Appendix D: Implementation Document Appendix E: Billing and Cashiering Information System Screenshots Appendix F: User Manual Appendix G: Letter Appendix H: Certificate of Appearance CURRICULUM VITAE Chapter 1
Introduction
Logistics information system is a system of records and reports used to aggregate, analyze, validate and display data (from all levels of the logistics system) that can be used to make logistics decisions and manage the supply chain.

Logistics Information System is an ERP TEAM Enterprise Resource Planning System that this specifically made for the company’s transaction. The function of logistics information system records delivery information first starts accepting the orders from the sales and the billing. Delivery information module is the main process of the transaction that will accept all information along with the billing statement information, order delivery. Delivery Status will indicate that the order has been delivered if the product has been damage the Billing will get the billing id and quantity damage and deduct the amount paid. And the owner can monitor the Logistics reports.

The Proposed Study entails the computer-based Logistics information system which design and develop for Juner enterprise in improving their logistics process this help the company to have fast and easy transaction these logistics are reflected in creating new, competitive positions, and achieving a certain dependency differentiation in operations, as well as in better results of all the logistics functions within the organization
The Juner Enterprise have eight employees from productions down to delivery and they started their business since 1998 but first she was not interested in doing a business so their relatives is a business minded they encourage her to do a business and they started in first product which is nata candy and she decided to sell nata de coco in small store and food carts and she decided to attend some seminars in how to make nate de coco, kaong, seaweeds and how to manage a business.

And their company delivered like Gaisano mall in all Mindanao, also they have to provide their customers a good quality of products but the company also have a problem like late delivery they experience weeks delays and time-consuming in disseminating the delivery for the reason that the employees were too busy because in ordering the products its first come first serve bases and theirs a time that there was to many orders is coming up. Juner Enterprise needs a system for the faster transaction.

General Statement of the Problem
This part of the documentation contains the reasons why the researchers made an information system. The general problem of this research is that the company’s current system of storing their Logistics Information has been storing manually that lead delayed for some products because of redundancy of data, unorganized data for the customers and products and the absence of filtering that can trap order directly into logistics department which will then be updated in the sales to inform the delivering status.
That has been their practice for 18 years and as 18 years goes by technology and business has been working hand-and-hand.

Specific Problems
Factors can be improved in the Logistics Information System; that the Company encounter following specific problems: delivery information records, disorganize delivery information, delivery records redundancy, inaccurate delivery reports
First Specific problem is Delivery Information Records pile of paper records could be difficult to search since the owner encountered. Due to re-recording records of the client or delivery information.

Second Specific Problem Disorganize Delivery Information difficulty in customer records.

Third Specific Problem Redundancy of the Data because the owner encountered recording a delivery transaction. Due to absence of filtering that can trap the ordering record of the data redundancy and would prompt that transaction is already recorded.

Fourth Specific Problem Inaccurate Delivery Report and Damage Report, there was a time the owner encounter of an inaccurate report due to reposting records.

Objectives of the study
General Objective
The aim of this research describes what the researchers want to expect or to achieve in this project. The general objective is to focus on the general problem would be providing an information system that would fit on the business goal into manual storing and retrieve into the computerized-based system and would provide an information system made specifically for the client’s business and to transform the manual storing and computer-based. In this information will be based on their process how their transactions work by transforming into computer-based.

The guide questions that would aid the researcher for this study; What are the possible challenges the Logistics Information System developed would encounter? What are the purposes of Logistics Information System?
Once the system is being tested, the developer will give instruction and user manual to guide the client or user on how to operate the Logistics Information System for Juner Enterprise.

Specific Objectives
 Identifying the possible challenges of the developed Logistics Information System would encounter in the present and the near future
With the use of the computer-based system, this helps to maintain the ways of how to handle possible challenges in process change being encountered by the company. The features are the following: organize the stored Delivery information records, filtering of delivery records to avoid redundancy, accurate delivery report and damage report.

The first specific objective Delivery Information Records, all information will be stored to avoid misplacing paper. The solution of the researcher is to use a computerized based system helps to avoid misplacing and losing data, which the client or the user can easily search, data.

The second objective Organize Delivery Information organizes of delivery information records. This is easy to handle the details of the delivery information of the customer that can filter directly through delivery status of the logistics. Moreover, computerized system helps to avoid misplacing and losing data.

The Third objective Centralize Data filtering of delivery records to avoid redundancy to avoid data redundancy in the database system; the database sets primary key of a unique key generated whenever the user or client for delivery of the transaction for order. The primary key will be a great help to avoid data redundancy for the customers which is to help the awareness of the records and transaction.

The Fourth objective Accurate Delivery Report and Damage Report, to avoid inaccurate reports of delivery and damage product The computerized-based report transaction of a system can manipulate computerized Delivery and Damage Report with the details of status in delivery and how many has been damaged during delivery.
1.4 Significance of the Study
This project will benefit the following group; the client (which is Juner Enterprise), the researchers, the College of Computer Studies, the future researchers with the same topic, and to the future entrepreneurs.
The project is developed for the benefit of the company (Juner Enterprise). With the improved system, they can keep track of their delivery of the client, logistics deadlines, delivery status, and if there is damage of the product the logistics will update the billing about the damage
The project will also benefit the employees to make their work much easier upon making transaction in delivery of the product
The researchers will also benefit from this study as this is an ERP project it will help develop their skills as a group, share diverse perspective and pool knowledge to help each other coming up with solutions to a problem that could prove challenging doing on their own.

This study will also benefit the College of Computer Studies as it will showcase to the future students who will take the same topic and gave them idea how an ERP system works.

The future researchers will benefit from this study as they can use it for reference on working their own system. This study will show and give the idea on how ERP system are made, what starts the process, the relationship of each system and how they affect each business transactions.

To the future entrepreneurs, this study will show them the benefits of having a computer-based system especially to those who are still using manual transactions. This study will give the idea of how they can improve their business.

Scope and Limitations of the study
The coverage of this system is custom made of the clients the system function as logistics information system first is the billing will send the billing statement of the client and the logistics will record the route, delivery, date of delivery and the sales will update the delivery date of the product and after it delivers the logistics will input the delivery id and the receive and the time received and billing and sales can be updated by the time the product is received if there is damage product the logistics will input what product is damage and how many and damage reports will update the billing
The limitation of this system is that it is not web based and no tracking system to track the delivery vehicle, route and the product can’t be track so the user will enter the when the product arrives. It cannot convert to active pickup with email confirmation and the shipment history cannot be sent to customer via email and it does not access history information for both customer and carrier performance
Definition of Terms
Information System. (IS) is an organized system for the collection, organization, storage, and communication of information.

ERP. Enterprise resource planning is business process management software that allows an organization to use a system of integrated applications to manage the business and automate many back office functions related to technology, services, and human resources.

Data. Data is a set of values of qualitative or quantitative variables
Computerize. A system that is operated or controlled by computer
Logistics information system. is a system of records and reports used to aggregate, analyze, validate and display data (from all levels of the logistics system) that can be used to make logistics decisions and manage the supply chain.

Chapter 2
REVIEW OF THE RELATED LITERATURE
Enterprise Resource Planning (ERP)
Economic globalization and internationalization of operations are essential factors in the integration of suppliers, partners and customers within and across national borders, the objective being to achieve integrated supply chains. In this effort, implementation of information technologies and systems such as enterprise resource planning (ERP) facilitate the desired level of integration. There are cases of successful and unsuccessful implementations. The principal reason for failure is often associated with poor management of the implementation process. This paper examines key dimensions of implementation of ERP system within a large manufacturing organization and identifies core issues to confront the successful implementation of enterprise information system. A brief overview of the application of ERP system is also presented and in particular, ERP software package known as SAP R/3, which was the ERP software package selected by (Rolls-Royce) plc. The paper takes an in-depth look at the issues behind the process of ERP implementation via a case study methodology. It focuses on business and technology as well as cultural issues at the heart of the ERP implementation. ()The case study also looks at the implementation timescales and assesses the benefits from the project both tangible and intangible.             ERP systems are integrated information systems which can be used to manage all information, resources, and function of an organization from a shared database. These systems attempt to integrate all information into one central database, then users at different organizational positions are allowed to monitor different information levels ( Dechow & Mouritsen, 2005 ).             
ERP systems are most commonly used in a distributed and often widely scattered manner. When the researchers talk of ERP buildup, there are two types of basic groups. Typical two-tier architecture, the server handles both application and database duties. The clients are in charge of presenting the data and passing user input back to the server. While there may be multiple servers and the clients may be divided across several types of local and wide area links, this distribution of processing burden remains the same, (Eresource 2016).

ERP Systems are software applications that merge data and or fuse the functionality of classical separate software systems. Examples of software systems that ERP software might replace or fuse data from include accounting software, product stockpile software and many others. Usability First, (2016). About ten years ago, ERP systems were basically used by huge corporations. In the era of cost-effective age Web utilizations, many smaller businesses are finding that they can save costs by enforcing a light ERP system to carry out product sniff out, invoicing, and accounting practices Techtarget Groupware (2016),( AL-Sawaie B., et al. 2015).

Logistics Information System
A logistics management information system (LMIS) is a system of records and reports – whether paper-based or electronic – used to aggregate, analyze, validate and display data (from all levels of the logistics system) that can be used to make logistics decisions and manage the supply chain. LMIS data elements include stock on hand, losses and adjustments, consumption, demand, issues, shipment status, and information about the cost of commodities managed in the system.

An effective logistics management information system (LMIS) should ensure that adequate quantity and quality of health commodities are always available at the point of service to meet patient demand. The eLMIS must provide integrated access to: Accurate, timely & routine consumption data Real-time logistics management capabilities covering the point of origin to point of consumption Demand forecasting, capacity planning & modeling based on consumption.( Lisa Hare, John Snow 2012)
Converting data to information, portraying it in a manner useful for decision making, and interfacing the information with decision-assisting methods are considered to be at the heart of an information system. Logistics information systems are a subset of the firm’s total information system, and it is directed to the particular problems of logistics decision making. (https://scm.ncsu.edu/scm-articles/article/logistics-information-systems) The inputs are data items needed for planning and operating logistics system obtained from sources like delivering the products to the customers, Logistics automation features such as integration to your commodities via your ERP system.

A well-designed information system is a key element of logistics in the chain of managing, organizing and operating in both profit and nonprofit organizations.(PK Bagchi,1992) The advantages of applying strategic management in the development of information technologies contribute to the positive development of logistics functions in an organization or institution as a whole. A prerequisite for successful logistics management is a systematic gathering of required business information. (Sveuèlište J)Today it is no longer possible to run a successful operation without a working information system. A fully constructed information system contributes essentially to an organization’s competitive advantage. These advantages are reflected in creating new, competitive positions, in cost reduction and achieving a certain dependency differentiation in operations, as well as in better results of all the logistics functions within the organization. The basic goal of an information system within logistics management is to make successful connections between suppliers, consumers, and competitors. Depending on the logistics management decision, the mode of making these connections can be offensive or defensive(D Dorcak, 1992). The basic aim is to achieve comparative advantages through logistics. If logistics management is objective, this will lead to decision making that will contribute to: respectability of the purchasing function, competitive advantage in the supply chain, possible associations of suppliers, connecting logistics with consumers, determining the contribution of logistics to the organization’s competitiveness (Kate Iviae). The information system of logistics functions plays a role in making a correct interpretation of the company’s performance as well. Strategic options of generators for the logistics information management need to be continuously monitored, and usage of new options can improve the overall logistics functions within an organization.

According to studies the function of coordinates the physical supply of raw materials and distribution of the finish product on raw material side involves follow up the issue of raw material and inventory control (Arthur Wasik, 1992). The computerized data is rapid, prompt and error free and gives large volume of information for accurate analysis and decision making researcher give analysis and information from the client and the movement control of raw materials (YR Perdana,2012), finished products involves the transportation of goods warehousing and material handling the move towards higher levels of customer service to defend market share has come at a time when the economic climate need to reduce logistics costs (Arthur, 1992)
Chapter 3
Methodology
Research Design / Approach
The systems development life cycle (SDLC), using waterfall also referred to as the application development life-cycle, is a term used in systems engineering, information systems, and software engineering to describe a process for planning, creating, testing, and deploying an information system. SDLC aims to produce a system to meet customers’ needs based on the requirements needed by Juner Enterprises and determine what methodologies to use. in the requirements, we have to gather data from the clients and design for the computer-based system and the implementation which are integrated in phase and each system tested with the functionality of the system.

The waterfall development model we used in this study since the project will be developed; each process will be done step by step, phase by phase. Each phase must be done in order to move to the next phase. The Waterfall is each progress is seen as flowing steadily downwards through this phases of requirement analysis, design, development, testing, and maintenance. Each phase must be finished because turning back phase is possible it would be very hard to correct due to committed to the data that already established.  

Requirement the first phase involves understanding what need to be design and what the function is, purpose here the specifications of the input and output or the final product are studied. System design the requirement specification from the first phase are studied in this phase and system design is prepared. The system design helps in specifying hardware a system requirement and also helps in defining overall system architecture. Development of system once the functional and non-functional testing is done; the product is deployed in the customer environment or released into the market. Testing all the units developed in the implementation phase are integrated into a system after testing of each unit the software design needs to go through constant software testing to find if there are any flaw or error. Testing is done so that the client does not face any problem during the installation of the software. Maintenance this step occurs after installation and involves making modification to the system or an individual component to alter attributes or improve performance. These modifications arise either due to change request initiated the customer or defects uncovered during live use of the system. Client is provided with regular maintenance and support for the developed software.

Requirement Gathering/ Specification
In these criteria, the researcher focuses on the problem background, business goal and success criteria for the project. The researcher of this study has two ways in gathering data. Through RRL (Review of Related Literature) and through client and advisor interview, for the RRL it is for us to search for published or implemented works of other people related to our study for us to be able to benchmark on their work and then how to get an idea through creating our information system. Another way has gathered the data and conceptualizes each of transaction through interview of the client. The researcher will prepared questionnaire for the interview with the client and gathered partial data. The researcher set a date as to where and when to meet our client, depending on their availability. The information gathered from the client will help us to create the information system. Also, we interview our adviser for the advice and clarification of the transaction of our creating information system.

Analysis and Design
To analyze and design the system it uses structured techniques using Data Flow Diagram (DFD) and Entity Relational Diagram (ERD) is the technique for this study context diagram is a data flow diagram that only shows the top level, known as Level 0. At this level, dfd (https://www.visual-paradigm.com) is a traditional visual representation of the information flows within a system. A neat and clear DFD can depict a good amount of the system requirements graphically. It can be manual, automated, or combination of both.Entity Relational Diagram (http://searchcrm.techtarget.com) is a graphical representation of an information system that shows the relationship between people, objects, places, concepts or events within that system. An ERD is a data modeling technique that can help define business processes and can be used as the foundation for a relational database.

Development
Discuss what are the programming language IDE, server, and database used in developing this system.

The actual coding and development are done in this phase. The programming language used in this development Microsoft Visual Studio 2010 C# Programming this is running for a windows7, Windows 8 and Windows 10. The Microsoft Visual Studio 2010 is satisfied on this program which in order to build layouts and customize are required on this features of the transaction and the program. In order to store, query and manipulate the data in the MySql and Wamp Server use for the Database. The Mysql connector version 6 for connecting the both of Microsoft Visual Studio 2010 and for Wamp server to store the data used for the program.

Testing
Testing would require the networking configuration used the hotspot. The database will be accessed wirelessly through a hotspot and by using a client-server connection. The Testing of accessing the server simultaneously will be simulated to identify with both database and the systems, and other possible problems that will be encountered.

 In this phase the testing system together with ERP team to test the program of each phase of the transaction tested by the client the observation result of the testing. The owner test how the work of the module system of the ERP, by the testing happen the owner will open-minded of the possible problem will be encountered of the transaction to change and added transaction of the system.

Maintenance
Maintenance of the system, it will be based on the client issue if there some bugs of a program or other issue that it is not functional in the system. The researcher will assist the system of the client.  Also, the maintenance will also depend on developer give, if there is free maintenance of month or year then after the free maintenance they have to pay to sustain the possible issue on the program.

User Acceptance Test
The system is to be tested by the owner and another employee that is assigned to them for their day to day task. And the person should know how to use the system with the training to be conducted. The training is conducted by their company which is the owner tested the system
The researchers used this type of testing because of how reliable for them to be able to know what are the necessary changes. And the things we need to add to our system, to properly meet the customer need. This will also be used to show if the system that we developed is user-friendly.

System Evaluation
The system evaluation of the system it examines the program and involves with analyzing information about the program and the outcomes of the system to improve. Analyzing information about a program’s characteristics, and outcomes of our system. Its purpose is to make judgments about a program, to improve its effectiveness, and/or to inform programming decisions
Chapter 4
Results and Discussions
Requirements Analysis
The Juner Enterprise uses the manual transactions but they want a computer-based system that could improve their transactions fast and easy. This system will plan to implement the system in Juner enterprise to make their works efficient and easy the purpose of this is to identify the possible needs of their needs in their company.

Requirements Specification
Non-Functional Requirements:
A system has properties to emerge from the combination of its parts. These emergent properties will surely be a matter of accident, not design, if the non-functional requirements, or system qualities. The functional concepts and discusses capturing of non-functional requirements in such a way that they can drive architectural decisions and be used to validate the architecture.

1.    Performance – The system can perform faster than the traditional record keeping. For queries, for example, it is estimated to respond immediately
2.    Usability – The features and qualities of the system have been met with the clients’ requirements. The intended features were fit and are usable for the client.

3.    Reliability – The system can produce reliable and accurate data. The calculations, for example, are already being set and errors are unlikely to arise.

4.    Security – To provide security with the information of the clients’ business, the system is provided with user logins and passwords in the login forms.

5.    Maintainability – With the systems being completely developed, it will be maintained based on the clients’ choice of type of maintenance when problems in the future arise.

Functional Requirements
The following are the lists of functional requirements of the Logistics Information System.

Delivery Information Form
In this part of delivery information form the owner handles the delivery product information which is ready to deliver, Also the Billing will send the bill of the client together with the delivery information, the sales and billing will also be updated by its actual delivery of the product.

Delivery Status Form
Delivery status will display the product that has been delivered by the client and also the pending which to inform that this order is delivered, including sales and billing will be updated by date and time of arrival of the product
Delivery Report
In the summarized reports, it contains two reports for Delivery information Reports/ Status and Damage Report.

Delivery information report which displays all the data of Delivery related to the billed clients and displayed specified name, route, date, time, status.

Damage reports contain the damaged product of the nata de coco, seaweeds and kaong if there is a damaged product will display to the billing form for deducting bill of the client.
Hardware Requirements:
Item Minimum Value
Processor Type 32 bit
Processor Speed 2.0 GHz
RAM 2 GB
Hard Drive 250 GB
Table1: Hardware Requirements
Software Requirements:
Item Minimum Value
Operating System Windows 7
Browser Mozilla Firefox 3.5 and above, and or Google Chrome 1.0 and above
WAMP 2.5 32 bit
Table 2: Software Requirements
User Requirements:
Title Description
Client Managers The owner of the company, or any authorized user of the system.

Software Developers The ones that created the system. For maintenance of the system.

Design
The following diagrams: context diagram, data flow diagram and entity relationship diagram are used to graphically present the system. The following diagrams will show the flow of data throughout the system and the relationship of the tables in the database.

Figure 2: Context Diagram

Discussion
In this context diagram it shows the flow of the system the flow start when the sales and after the billing information system will update by the sales that there is new order and the billing statement will send to the Logistics Information System and Logistics will update the billing that the payment is fully paid or balance and also the sales will update if the product has been delivered and if there is a damage the Logistics send a damage report to the Billing, that report now is saved to the Deduction database
Figure 3: Data Flow Diagram

Discussion:
In This diagram (Figure 3) DFD show in the detailed data flow of the system. Which is each progress of the system has to be followed for the transaction and each part of the structure will be connected phase by phase of the system.

The flow starts of the billing statement which is connected from the Billing and Cashiering Information System since the sales has been receiving an order and the client has been billed. Second, Client Delivery Information which is to gathered data of the delivery id, billing id, route id, driver, vehicle, date, time, status, record entry it will be stored in the delivery information database. Third, product delivery status which is the owner will check the product if it is delivered. Fourth, Product Damage since the product has been delivered if there is any damage product it will put a status. Fifth, Deducted bill of the product that has been damage the Last is the Reports since the owner handles the all the Logistics Reports
Figure 4: Entity Relationship Diagram

Discussion:
In this diagram shows that each entity of relationship diagram or ERD table has connected with another table of the database of the group; we should have primary key or foreign key to indicate the prioritized of the table, each of table has primary key, the prioritize of each table it will not redundant the id on the table. The tbl_billing is connected to the tbldelivery once the order has been delivered it connect to tbldeliverystatus, tbldeliveryreports if the order has damage the billing will be updated for the deduction.

Development
The development method used Microsoft Visual Studio C# language which each of the progress of the development is documented and programmed in need of the system. In order to store the data the researcher used a database or MySQL server. The following is the codes to develop the Logistics Information System. In the codes of the sales and ordering information system there are types of functionalities which is saving, updating, searching, and searching between dates of the report which all functionalities are basically needed for the system. 
CODE:
namespace LIS{
public partial class Form1 : Form{
MySqlConnection con = null;
MySqlCommand cmd = null;
MySqlConnection con2 = null;
MySqlCommand cmd2 = null;
MySqlDataReader rdr;
MySqlConnection con3 = null;
MySqlCommand cmd3 = null;
MySqlConnection con4 = null;
MySqlCommand cmd4 = null;
String ccon = “data source=192.168.43.145;database=dbcoconat;user id=wahlen;password=capstone”;
String ccon2 = “data source=192.168.43.145;database=dbcoconat;user id=wahlen;password=capstone”;
String ccon3 = “data source=192.168.43.145;database=dbcoconat;user id=wahlen;password=capstone”;
String ccon4 = “data source=192.168.43.145;database=dbcoconat;user id=wahlen;password=capstone”;
public Form1()
{
InitializeComponent();}
public void load(){
con = new MySqlConnection(ccon);
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
MySqlDataAdapter da = new MySqlDataAdapter();
string sql = “SELECT * from tbldelivery”;
da.SelectCommand = new MySqlCommand(sql, con);
DataTable table = new DataTable();
da.Fill(table);
BindingSource bSource = new BindingSource();
bSource.DataSource = table;
dataGridView2.DataSource = bSource;
}
public void update()
{
con2 = new MySqlConnection(ccon2);
con2.Open();
cmd2 = new MySqlCommand(“update tbl_billing set Delivery_Status = ‘Delivered’ where Billing_ID = ‘” + textBox13.Text + “‘”, con2);
cmd2.Connection = con;
cmd2.ExecuteReader();
con2.Close();
MessageBox.Show(“Succesfully Saved”);
}
private void Form1_Load(object sender, EventArgs e)
{
load();
delivery();
loadreport();
route();
loadstatus();
billing();
billing1();
damage_combo();
}
private void button4_Click(object sender, EventArgs e)
{
if (textBox1.Text == “” || comboBox3.Text == “” || textBox1.Text == “”)
{
MessageBox.Show(“Please fill all required information”);
}
else{
try{
con = new MySqlConnection(ccon);
con.Open();
String query = “insert into tbldelivery_reports(report_no,Billing_ID,prod_id,damage_quantity,remarks)values(‘” + dateTimePicker5.Text + “‘,'” + textBox9.Text + “‘,'” + textBox6.Text + “‘,'” + textBox1.Text + “‘,'” + textBox3.Text + “‘)”;
cmd = new MySqlCommand(query);
cmd.Connection = con;
cmd.ExecuteReader();
comboBox3.Text = “”;
textBox9.Text = “”;
comboBox3.Text = “”;
textBox1.Text = “”;
textBox3.Text = “”;
con.Close();
MessageBox.Show(“Succesfully Saved”);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
loadreport();
}
}
public void loadreport()
{
con = new MySqlConnection(ccon);
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
MySqlDataAdapter da = new MySqlDataAdapter();
string sql = “SELECT * from tbldelivery_reports”;
da.SelectCommand = new MySqlCommand(sql, con);
DataTable table = new DataTable();
da.Fill(table);
BindingSource bSource = new BindingSource();
bSource.DataSource = table;
dataGridView3.DataSource = bSource;
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox2.Text == “” || comboBox2.Text == “”)
{
MessageBox.Show(“Please fill all required information”);
}
else{
try{
con = new MySqlConnection(ccon);
con.Open();
String query = “insert into tbldeliverystatus(trackn,Billing_ID,recievedid,recieveby,datere,timere)values(‘” + comboBox2.Text + “‘,'”+textBox8.Text+”‘,'” + dateTimePicker2.Text + “‘,'” + textBox2.Text + “‘,'” + dateTimePicker4.Text + “‘,'” + dateTimePicker1.Text + “‘)”;
string q2 = “update tbl_billing set Actual_Arrival_Date = ‘”+dateTimePicker4.Text+”‘ where Billing_ID = ‘” + textBox8.Text + “‘”;
string q3 = “update tbl_savedorder set actual_Arrival_Date = ‘”+dateTimePicker4.Text+”‘ where order_id = ‘” + textBox10.Text + “‘”;
string q4 = “update tbl_billing set Deadline_of_Payment = date_format(DATE_ADD(STR_TO_DATE(Actual_Arrival_Date,’%m/%d/%Y’), INTERVAL 15 DAY),’%m/%d/%Y’) where billing_id = ‘” + textBox8.Text + “‘”;
cmd = new MySqlCommand(query);
cmd2 = new MySqlCommand(q2);
cmd3 = new MySqlCommand(q3);
cmd4 = new MySqlCommand(q4);
cmd.Connection = con;
cmd2.Connection = con;
cmd3.Connection = con;
cmd4.Connection = con;
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
cmd3.ExecuteNonQuery();
cmd4.ExecuteNonQuery();
con.Close();
MessageBox.Show(“Succesfully Saved”);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
loadstatus();
}
}
public void loadstatus()
{
con = new MySqlConnection(ccon);
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
MySqlDataAdapter da = new MySqlDataAdapter();
string sql = “SELECT * from tbldeliverystatus”;
da.SelectCommand = new MySqlCommand(sql, con);
DataTable table = new DataTable();
da.Fill(table);
BindingSource bSource = new BindingSource();
bSource.DataSource = table;
dataGridView1.DataSource = bSource;
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
{
try{
con = new MySqlConnection(ccon);
con.Open();
cmd = new MySqlCommand(“select * from tbldeliveryinfo where Delivery_ID like ‘%” + dateTimePicker6.Text + “%'”, con);
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
dataGridView1.Rows.Clear();
while (rdr.Read() == true)
{
dataGridView2.Rows.Add(rdr0, rdr1, rdr2, rdr3, rdr4, rdr5, rdr6);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, “Exit”, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox13.Text == “” || comboBox4.Text == “”)
{
MessageBox.Show(“Please fill all required information”);
}
else{
con = new MySqlConnection(ccon);
con.Open();
String query = “insert into tbldelivery(Delivery_ID,Billing_ID,routeid,Driver,Vehicle,Date,Time,status,recordEntry_status)values(‘” + dateTimePicker6.Text + “‘,'” + textBox13.Text + “‘,'” + comboBox4.Text + “‘,'” + textBox16.Text + “‘,'” + textBox15.Text + “‘,'” + dateTimePicker8.Text + “‘,'” + dateTimePicker7.Text + “‘,’Delivered’,’unrecorded’)”;
string q2 = “update tbl_billing set Delivery_Status = ‘Delivered’ where Billing_ID = ‘” + textBox13.Text + “‘”;
string q3 = “update tbl_savedorder set actual_Delivery_date = ‘” + dateTimePicker8.Text + “‘ where order_id = ‘” + textBox7.Text + “‘”;
cmd = new MySqlCommand(query);
cmd2 = new MySqlCommand(q2);
cmd3 = new MySqlCommand(q3);
cmd.Connection = con;
cmd2.Connection = con;
cmd3.Connection = con;
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
cmd3.ExecuteNonQuery();
con.Close();
MessageBox.Show(“Succesfully Saved”);
dateTimePicker6.Text = “”;
textBox13.Text = “”;
comboBox4.Text = “”;
textBox16.Text = “”;
textBox15.Text = “”;
dateTimePicker8.Text = “”;
dateTimePicker7.Text = “”;
load();
}
public void billing()
{
try{
con = new MySqlConnection(ccon);
con.Open();
cmd = new MySqlCommand(“select * from tbl_billing”, con);
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
dataGridView4.Rows.Clear();
while (rdr.Read() == true)
{
dataGridView4.Rows.Add(rdr0, rdr1, rdr2, rdr3, rdr4, rdr5, rdr6);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, “Exit”, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dataGridView4_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int indexRows;
indexRows = e.RowIndex;
DataGridViewRow row = dataGridView4.RowsindexRows;
textBox13.Text = row.Cells0.Value.ToString();
textBox4.Text = row.Cells4.Value.ToString();
textBox7.Text = row.Cells1.Value.ToString();
}
private void button5_Click(object sender, EventArgs e)
{
con = new MySqlConnection(ccon2);
con.Open();
cmd = new MySqlCommand(“update tbl_billing set Delivery_Status = ‘Delivered’ where Billing_ID = ‘” + textBox13.Text + “‘”, con2);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
con2 = new MySqlConnection(ccon2);
con2.Open();
cmd2 = new MySqlCommand(“update tbl_savedorder set delivery_status = ‘Delivered’ where order_id = ‘” + textBox7.Text + “‘”, con2);
cmd2.Connection = con2;
cmd2.ExecuteReader();
con2.Close();
load();
MessageBox.Show(“Succesfully Updated”);
}
public void damage_combo()
{
con = new MySqlConnection(ccon);
con.Open();
String query = “select * from tbl_products “;
cmd = new MySqlCommand(query);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
while (rdr.Read() == true)
{
String product = rdr.GetString(“prod_name”);
comboBox3.Items.Add(product);
}
}
private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
{
con = new MySqlConnection(ccon);
con.Open();
String query = “select * from tbl_products where prod_name='” + comboBox3.Text + “‘”;
cmd = new MySqlCommand(query);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
while (rdr.Read() == true)
{
String product = rdr.GetString(“prod_id”);
textBox6.Text = product;
}
}
public void route()
{
con = new MySqlConnection(ccon);
con.Open();
String query = “select * from tblassign “;
cmd = new MySqlCommand(query);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
while (rdr.Read() == true)
{
String product = rdr.GetString(“route_id”);
comboBox4.Items.Add(product);
}
}
private void comboBox4_SelectedIndexChanged(object sender, EventArgs e)
{
con = new MySqlConnection(ccon);
con.Open();
String query = “select * from tblassign where route_id='” + comboBox4.Text + “‘”;
cmd = new MySqlCommand(query);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
while (rdr.Read() == true)
{
String product = rdr.GetString(“plate_number”);
String driver = rdr.GetString(“driver”);
textBox16.Text = product;
textBox15.Text = driver;
}
}
public void billing1()
{
try{
con = new MySqlConnection(ccon);
con.Open();
cmd = new MySqlCommand(“select * from tbl_billing”, con);
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
dataGridView5.Rows.Clear();
while (rdr.Read() == true)
{
dataGridView5.Rows.Add(rdr0, rdr1, rdr2, rdr3, rdr4, rdr5, rdr6);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, “Exit”, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dataGridView5_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int indexRows;
indexRows = e.RowIndex;
DataGridViewRow row = dataGridView4.RowsindexRows;
textBox8.Text = row.Cells0.Value.ToString();
textBox10.Text = row.Cells1.Value.ToString();
}
public void delivery()
{
con = new MySqlConnection(ccon);
con.Open();
String query = “select * from tbldelivery “;
cmd = new MySqlCommand(query);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
while (rdr.Read() == true)
{
String product = rdr.GetString(“Delivery_ID”);
comboBox2.Items.Add(product);
}}
}}
2. Registration of the route
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text==””||textBox2.Text==””)
{
MessageBox.Show(“Please fill all required information”);
}
else{
try{
con = new MySqlConnection(ccon);
con.Open();
String query = “insert into tblroute(routeid,route,allowance)values(‘”+dateTimePicker1.Text+”‘,'”+textBox1.Text+”‘,'”+textBox2.Text+”‘)”;
cmd = new MySqlCommand(query);
cmd.Connection = con;
cmd.ExecuteReader();
textBox1.Text = “”;
textBox2.Text = “”;
con.Close();
MessageBox.Show(“Succesfully Saved”);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
load();
}}
public void load()
{
con = new MySqlConnection(ccon);
con.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
MySqlDataAdapter da = new MySqlDataAdapter();
string sql = “SELECT * from tblroute”;
da.SelectCommand = new MySqlCommand(sql, con);
DataTable table = new DataTable();
da.Fill(table);
BindingSource bSource = new BindingSource();
bSource.DataSource = table;
dataGridView1.DataSource = bSource;
}
3. Registration for the vehicle
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text==””||textBox2.Text==””)
{
MessageBox.Show(“Please fill all required information”);
}
else{
try{
con = new MySqlConnection(ccon);
con.Open();
String query = “insert into tbldriver(driver_name,license)values(‘”+textBox1.Text+”‘,'”+textBox2.Text+”‘)”;
cmd = new MySqlCommand(query);
cmd.Connection = con;
cmd.ExecuteReader();
textBox1.Text = “”;
textBox2.Text = “”;
con.Close();
MessageBox.Show(“Succesfully Saved”);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
load();
}}
Assign Route and Vehicle
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text==””||comboBox2.Text==””)
{
MessageBox.Show(“Please fill all required information”);
}
else{
try{
con = new MySqlConnection(ccon);
con.Open();
String query = “insert into tblassign(route_id,plate_number,driver)values(‘”+comboBox1.Text+”‘,'”+comboBox2.Text+”‘,'”+comboBox3.Text+”‘)”;
cmd = new MySqlCommand(query);
cmd.Connection = con;
cmd.ExecuteReader();
comboBox1.Text = “”;
comboBox2.Text = “”;
comboBox3.Text = “”;
con.Close();
MessageBox.Show(“Succesfully Saved”);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
load();
}}
5. Reports
private void Delivery_Status_Load(object sender, EventArgs e)
{
this.tbldeliverystatusTableAdapter.Fill(this.Delivery_Status_Reports.tbldeliverystatus);
this.reportViewer1.RefreshReport();
}
private void Delivery_Report_Load(object sender, EventArgs e)
{
this.tbldeliveryTableAdapter.Fill(this.Delivery_Reports.tbldelivery);
this.reportViewer1.RefreshReport();
}
private void Damage_Report_Load(object sender, EventArgs e)
{
this.tbldelivery_reportsTableAdapter.Fill(this.DamageReports.tbldelivery_reports);
this.tbldeliverystatusTableAdapter.Fill(this.Delivery_Status_Reports.tbldeliverystatus);
this.reportViewer1.RefreshReport();
}
Deployment
The system is installed in a local computer. Once the customer will order and the sales and order writing information system will request to manufacturing if there’s an available stocks of products and the billing information system will bill the orders of the customers and logistics information system will assign to the delivery of the products to the customers and after receiving the products it will update the actual delivery of the product and arrival date to the billing and sales and order writing. During our deployment in the company that we install our system in their laptops and we are using Wi-Fi for the connection of our system
Chapter 5
SUMMARY, FINDINGS, CONCLUSIONS AND RECOMMENDATIONS
This chapter provides the overview study of ERP System Cagayan de Oro City, its findings, conclusions and recommendations.

Summary
The Juner Enterprise uses the manual transaction but we don’t have a problem with their existing transactions uses manual but we propose a computer based system that will improve their transaction fast and easy https://ideas.repec.org these logistics are reflected in creating new, competitive positions, and achieving a certain dependency differentiation in operations, as well as in better results of all the logistics functions within the organization. Which they encountered of misplacing of records and data loss because of the papers works and other transaction; the researcher aims to minimize the process such as loss of data, misplacement of records, longer time to search for records, and in making reports. The system goals are to lessen the work since it is computerized by a system, though the members of the company must operate collaboratively under effectiveness business management directions. Dependency differentiation in operations, as well as in better results of all the sales and order writing information system functions.

Findings
With the help of ERP system where the transactions made easier. The program will perform logistics information system. That has been developed for juner enterprise
This will perform delivery information, delivery status, delivery reports. The logistics information developed through C#. The system can register vehicle, route, and assigning vehicle and the drive. During the employment of the system, we find the user interested and it helps the company faster transactions. ERP Team has found several problems in the middle of creating the system. The researcher encountered wrong interpretation of concept from the data gathered. Some of the members found it hard to communicate while some found it hard to understand the functionalities, transaction and sharing ideas about data analysis and requirement specification. Each progress must be careful and suitable on every transaction on the program for Juner Enterprises. The most crucial part of development is the data gathering. A successful development is the completely gathered and finalized of the concept of the transaction.

Conclusions
The ERP system is a challenging things to work since it is connected to every module the company uses manual we want to make a computer based systems which is easier to use because it only requires computers the system can managed by the assign personnel. The success of this system relies to user’s satisfaction and the understanding of the system. The goal of this system in order to help and make their transaction fast. In this study this aim to help their company and also their day to day transactions.

Recommendations
The system is highly recommended to the following:
To the owner of Juner Enterprises, it will greatly help their business since the system shows the advantages through a process and reports are easier to use the system. Furthermore, it also shows the improvement of the process that needed to be changed and added for. To the other business companies that still use the traditional transactions; this will lessen the works of the employee since this process is automated. To the computer studies students, since this is first time to create a computer-based system, this will serve as a guide for information in creating a system. To the future researchers, since this will serve as a reference for creating a system and also to improve the system. To ERP System, this will guide for the improving the transaction system.

 For the ERP System, the researcher would recommend proper connection in which the switches have to avoid a delay and slow transactions and devices need a compatible connection for avoiding slow and limited connection of the system. While testing the system, the ERP TEAM uses a wireless hotspot which makes the connection slow and limited to one of the module systems has to disconnect before the system processed. The system recommendation of Logistics employees want to have simple user manual of the system to instruct the user of the unfamiliar functionalities or areas process of the system.

References
Internet
https://ideas.repec.orghttp://searchcrm.techtarget.comhttps://scm.ncsu.edu/scm-articles/article/logistics-information-systemshttp://healthmarketinnovations.org/sites/default/files/electronic%20Logistics%20Management%20Information%20System%20%28eLMIS%29%20Supplementary%20Information.com
https://search.proquest.com/openview.comhttps://www.slideshare.net/mobile/togar/logistics-information-systemhttps://www.emeraldinsight.com/Logisticshttps://carrierlogistics.com/solution/trucking-software-logisticshttp://www.sciencedirect.com/science/article/pii/S0378720601001343http://www.tandfonline.com/doi/abs/10.1080/00207540410001671679.http://onlinelibrary.wiley.com/doi/10.1111/j.1540-5915.2002.tb01658.x/fullhttp://www.slideshare.net/Logistics Information System
http://www.ieeexplore.org/logistics information in production
PDF
http://www.sciencedirect.com/article/logistics information system for supply chain/pdfAPPENDICES *
APPENDIX A
QUESTIONNAIRE
How many days of shipping?
Did they accept delivery fee?
What are the processes for shipping?
If there is a damage product what will they do?
Who will access the system?
What can other system access in logistics information system?
What places do they cover in their business?
What will be the process of logistics information system?
If there is a damage product do they deduct the product or replace the product that been damage?
In the delivery of the product is there a specific time or date to deliver?
APPENDIX B
LOGISTICS INFORMATION SYSTEM USER INTERFACE

APPENDIX C
LETTER

APPENDIX D
CERTIFICATE OF APPEARANCE

Appendix E

User Manual
Delivery Information Form
The system process starts by receiving billing statement made by billing and cashiering information system by clicking the grid to another grid and after clicking it will start by filling all information needed by the delivery.

And after filling all information that is needed in the delivery of the product the sales information system and the billing information system will be updated in actual date of delivery
Delivery status Form
The other grid will show if there is product that has not been delivered yet and if the product is delivered the user will start filling up the delivery status if it is delivered and the date received of the product.

And there will be a hidden textbox if the user will save all the data of delivery status the billing information system and the sales information system will be updated that the product that has been delivered to the client.

Delivery Report
In this form, if there is a damage product this report will update the billing that some of the product has been damage while delivery and the billing will deduct the product that has delivered.

APPENDIX F
USER ACCEPTANCE TEST MATRIX

APPENDIX G
SYSTEM USABILITY SCALE EVALUATION

CURRICULUM VITAE
420179552197000
WAHLENLOU C. OBA-OB
Gaabucayan Ext Agora, Cagayan de Oro City
[email protected]
PERSONAL DATA
Date of Birth: March 29, 1996
Place of Birth:Cagayan De Oro City
Citizenship:Filipino
Civil Status:Single
EDUCATION BACKGROUND
Tertiary:Bachelor of Science in Information Technology (2017)
Capitol University
Corrales – Osmena Ext., Cagayan de Oro City 9000
Secondary:Misamis Oriental General Comprehensive (2013)
Velez Street, Cagayan de Oro City
Elementary:City Central School (2009)
Velez Street, Cagayan de Oro City
TECHINICAL SKILLS
System Development, Database Design, Web Programming, Graphic Arts, and Video Editing
Language and Software:
C#, VB.Net, HTML, CSS, and PHP
Netbeans, Microsoft Visual Basic, Sublime Text, and WAMP
Adobe Photoshop

x

Hi!
I'm Heidi!

Would you like to get a custom essay? How about receiving a customized one?

Check it out