ON-LINE CUSTOMER SERVICE FOR CARGO STORES OF SRI LANKA PORTS AUTHORITY

Abstract

Warehouse management was one of the main services provided by Sri Lanka ports authority, as the main port in Sri Lanka. Developing a warehouse management system for a selected warehouse, and online relevant data was important to make the working process more efficient. Therefore the software development process was done, by following the leaner sequential model. According to the model analysis was carried out by consulting relevant employees. And then in designing stage, relevant Data Flow Diagrams were designed relevant to the structured method and level them up to 3rd, also the database was designed j using relational model and the normalization was done up to 3 normal form. Further the user interfaces were designed using VB 6.0. The database was implemented using MS access. And DAO method was used to access the database through user interfaces. Further more for achieving the task of online, DSN was assigned to the database, so then server side scripting language like ASP was run on IIS web-server. The outcome of the software project was accepted by relevant employees of Sri Lanka Ports Authority, as a method of increasing the efficiency, and reducing corruption, as well as the best solution for the competitive modern world through online service.