Kia Motors Case

We conducted a research in KIA Motors, Marcos Highway Branch to know their system and what we can contribute to improve their processing of data. Because of manual type process of their transactions, KIA MOTORS cannot access and monitor their files easily. For example, the profile redundancy of their customers or the records has not been stored properly. Also, they cannot easily update the payments of their customers who purchased in the banks. As what sales manager told us, they always have this kind of problem in saving records of their applicants, Then after this study will be made, this will serve us their automated type of recording data and records.

COLLEGE OF COMPUTER STUDIES
http://csitolfuantipolo.socialgo.com

OUR LADY OF FATIMA UNIVERSITY

CONCEPTUAL FRAMEWORK
INPUT PROCESS OUTPUT

LOGIN MODULE Performs logon for basic or form authentication. You can use this login module to perform authentication with user ID and password. Displays the Administrator module ADMINISTRATORMODULE Maintain permanent historical training records for employees and/or customers of your products and services. Display the main module where the administrator can manage the interface SALES MODULE Add, edit , search transaction on clients View services and invoice of transactions of the company Also view reports regarding transactions SEARCH MODULE Validates entered data on the search box Display data what you have been searching like inventory, sales and records CAR STOCK ROOM MODULE Validates records of cars Displays the car models including overview of the cars, price and kits

COLLEGE OF COMPUTER STUDIES
http://csitolfuantipolo.socialgo.com

OUR LADY OF FATIMA UNIVERSITY

SYSTEM OBJECTIVES
The general objective of the study is to design and develop a program that will provide the company to use a computer generated system in transactions and daily task. The proposed system will be as follows: 1. The proposed system will store data of the customers properly. 2. The proposed system can monitor the transferring of files and inventory of the company. 3. The proposed system can easily updated their clients in connection with banks and paying centers. 4. Proposed system that can sort and filter the records and transactions of their clients. 5. Proposed system can easily update clients who transacts on their car shows.

STATEMENT OF THE PROBLEM
The proponents would like to answer the following problems of their company as follows:
1. Profile Redundancy
2. Difficult in searching records
3. Difficult in updating their clients
4. Loss of records
5. Difficult in monitoring the inventory of the company

COLLEGE OF COMPUTER STUDIES
http://csitolfuantipolo.socialgo.com

OUR LADY OF FATIMA UNIVERSITY

HYPOTHESIS
In the hypothesis of this project this will be the main system that KIA MOToRS will use for transacting with their clients. The proposed system will be accurate in every terms like looking for client personal information and this is also will be use any transactions will be made in their company. There will be Large capacity of storage for recording files or data in the system. SIGNIFICANCE OF THE STUDY

This proposed system is design to eliminate all the inconvenience and disadvantage of a manual system. Some businesses use manual system in all their business operations, but some are using automated to prevent loss of time and inconvenience .Disadvantage are the natural part of manual system in operating the business. With this proposed automated and computerized version of the business system, it is expected to the transaction process for the customers to become more accurate and will aid in managing time especially for those seasons that the number of customers are at its peak. It also easily locate the transactions and records of their employees.

COLLEGE OF COMPUTER STUDIES
http://csitolfuantipolo.socialgo.com

OUR LADY OF FATIMA UNIVERSITY

SCOPES OF THE STUDY
The PROPOSED SYSTEM has a login form that can be accessed by the Manager, Sales Director, Sales and Marketing Manager. It has a program that can be monitor the inventory of the company, the transactions of their customers on their branch and also in banks. It has a record of their employee’s monitoring system of daily task and schedules. It also has a record of sales and finance report according to date and time.

LOGIN MODULE:
Performs logon for basic or form authentication. You can use this login module to perform authentication with user ID and password. USER ID: Input so that the system can validate who open the interface PASSWORD: use as an authentication, helps to maintain security of the data and records of the company.

ADMINISTRATOR MODULE
Business Unit: Along with different Business Unit Address Details with Taxation Related Details like VAT No. TIN No., PAN No. etc. to be stored in this form. Admin can create no. of Business Units under which the Company is Operating

Company Master: (Parent Company or Main Company)

Branch Master: Under Each Business Unit, various branches can be created along with their Address and contact details. Branch is mainly for creating multiple users in each branch and accordingly the users can be given the access rights. Current branch is displayed on the Main (Home) Screen and Change if Branch is also possible by a click of a button without logging off the system in a truly dynamic Tree Structure Environment. All reports and Ddata are Business Unit / Branch Wise and individual / cumulative analysis is also given. COLLEGE OF COMPUTER STUDIES

http://csitolfuantipolo.socialgo.com

OUR LADY OF FATIMA UNIVERSITY

Users: Here details of the Users can be saved along with their Username and Password and main business unit of the company to which he/she belongs to. Along with this Admin can give him the access to other Accessible Business Units which user can access in this system. Also user’s Primary branch can be selected here where he can login and user can change the Branch later as per his rights given by Admin. Also group to which a user belongs can be selected from this screen. Select Branch: All Business Units which the User has access, are shown here in the Tree Structure. User as per his access rights can switch from one Branch to another in different business units from this form. Advantage is that User doesn’t have to Logoff the System every time he wants to change the branch. Database Backup: Admin/Users can take a Regular Database Backup manually by clicking one Button and all data from the database will be saved as one file in a particular destination. Regular backup absolutely must to avoid any data losses in case of server crash EMPLOYEE: indicates the information about their employees. It is filtered by department so that the administrator can easily locate the information. It has a data that can manage the employees’ quotas in every month. SALES MODULE

Report: is a part of the proposed system that will show the reports in different departments such as customer information, employee record, inventory list, sales, salaries, payments and transactions. These reports are generated from date and time. Sales Services: If Sales Invoice is already made then this form is used to receive the Goods back from Client. This will effect Inventory as well as Accounts. Sales Invoice Return: If Sales Invoice is already made then this form is used to receive the Goods back from Client. This will effect Inventory as well as Accounts

COLLEGE OF COMPUTER STUDIES
http://csitolfuantipolo.socialgo.com

OUR LADY OF FATIMA UNIVERSITY

Sales Enquiry : All Enquiries coming from various sources can be entered in the system. Nature of Enquiry, Basic Client Details, and Product Details can be entered.  Quotation : Quotation of Individual Products or Finished Parts with Assembled Items can be made from the system by entering various details like Client Details, Terms and Conditions, Discount Structure etc.

Search: quickly helps the administrator or manager to find the records in the system. The system has its search box in order to easily locate the information needed regarding the records of transactions of their clients, inventories, sales and more. Also if the customer wants to know their record they will search a particular name to retrieve any information they need.
This module presents all the records that the user wants to locate.

help: will serve as an aid for the user to navigate and familiarize him/herself on the interface. Also, there will be a tutorial that will provide any important information regarding the system to guide new users across the interface.

About: serves as the information about the company and persons that make the system possible. Car stock room: will help the client to view car models and equipments offered by the company. It has a complete overview which helps the customers to see the inner and outer part of the car .This module also indicate the price or promos of the cars.

COLLEGE OF COMPUTER STUDIES
http://csitolfuantipolo.socialgo.com

OUR LADY OF FATIMA UNIVERSITY

DEFINITION OF TERMS

SAD
* Systems Analysis and Design (SAD) – is a generic term for describing methodologies for developing IT systems. The SAD technique is actually not limited to IT systems and can be used to create just about anything, from a family house to the international space station..

ERP
* Enterprise resource planning (ERP) is business management software that allows an organization to use a system of integrated applications to manage the business. ERP software integrates all facets of an operation, including product planning, development, manufacturing processes, sales and marketing.

SDLC
* SDLC (Software development life cycle) – is the process of developing information systems through investigation, analysis, design, implementation
and maintenance. SDLC is also known as information systems development or application development DFD

* The Data Flow Diagram (DFD) – is a graphical representation of the flow of data through an information system. It enables you to represent the processes in your information system from the viewpoint of data. The DFD lets you visualize how the system operates, what the system accomplishes and how it will be implemented. SYSTEM

* An organized, purposeful structure that consists of interrelated and interdependent elements .These elements continually influence one another to maintain their activity and the existence of the system, in order to achieve the goal of the system.

COLLEGE OF COMPUTER STUDIES
http://csitolfuantipolo.socialgo.com

OUR LADY OF FATIMA UNIVERSITY

INTERFACE
* A boundary across which two independent systems meet and act on or communicate with each other. SYSTEM ANALYST
* is the person who utilizes SAD principles to integrate technology into an organization. MODULARITY
* Dividing a system up into chunks or modules of a relatively uniform size. To Simplify the redesign and rebuild process

RESOURCE MANAGEMENT

* The process of using a company’s resources in the most efficient way possible. These resources can include tangible resources such as goods and equipment, financial resources, and labor resources such as employees. SYSTEM ANALYSIS

* is a process of collecting factual data, understand the processes
involved, identifying problems and recommending feasible suggestions for improving the system functioning.

FLOWCHART
* is a formalized graphic representation of a logic sequence, work or manufacturing process, organization chart, or similar formalized structure. The purpose of a flow chart is to provide people with a common language or reference point when dealing with a project or process. GANTT CHART

* is a visual representation of a project schedule. A type of bar chart, a Gantt charts show the start and finish dates of the different required elements of a project.

COLLEGE OF COMPUTER STUDIES
http://csitolfuantipolo.socialgo.com

OUR LADY OF FATIMA UNIVERSITY

DATA STRUCTURE
* is the Interrelationship among data elements that determine how data is recorded, manipulated, stored, and presented by a database.

PROTOTYPING
* is essential for clarifying information requirements. The design of a system must be finalized before the system can be built WATERFALL MODEL
* is a sequential design process, often used in software development processes, in which progress is seen as flowing steadily downwards through the phases of Conception, Initiation, Analysis, Design, Construction, Testing, Production/Implementation, and Maintenance.

SPIRAL LIFE CYCLE MODEL
* is a type of iterative software development model which is generally implemented in high risk projects. It was first proposed by Boehm. In this system development method, we combine the features of both, waterfall model and prototype model. In Spiral model we can arrange all the activities in the form of a spiral.

INFROMATION SYSTEM
* A combination of hardware, software, infrastructure and trained personnel organized to facilitate planning, control, coordination, and decision making in an organization.

PROJECT MANAGEMENT
* The planning and organization of an organization’s resources in order to move a specific task, event or duty toward completion. Project management typically involves a one-time project rather than an ongoing activity, and resources managed include both human and financial capital.

SYSTEM ADMINISTRATOR
* is responsible for maintaining a multi-user computer system, including a local-area network (LAN). He was the one who performs procedures when setting up accounts, installing software and configuring workstations.

COLLEGE OF COMPUTER STUDIES
http://csitolfuantipolo.socialgo.com

OUR LADY OF FATIMA UNIVERSITY

RESEARCHER
* the one who conduct interviews, survey and gathering of data to a company.

PROGRAMMING ANALYST

* Writes code to create single-threaded or user interface event driven applications, either stand-alone or those which access servers or services. Designs, implements, and tests database schemas. Uses source debuggers and visual development environments. Works with designers and content producers.