Sabtu, 25 Juni 2011

CHAPTER IV
DISCUSSION

5.1 System Design
Electrical System Design Billing Information can facilitate in the calculation of billing KWH of electricity bills because the data already entered or previously entered first. so, if we want to find customer data or data items can press the button that has provided the data that we need will appear by itself.
Stage - the design phase of this system include:
a. determination Formulas
b. designing DataBase
c. designing interfaces


5.2 Determining the Formula
Before applying the code to the user interface System Information necessary to determine the formula for calculating kwh electricity bills, the formula - a formula that is used as follows:
a. KWH formula → 1 item
usage = Watts * hours of use
KWH = usage / 1000 * 30

b. Formulas KWH → 2 items or more
use of (a) = a * Watts goods usage hours a disposable item
usage (b) = b * Watts goods usage hours disposable goods b
KWH = (a + consumption goods consumption goods b) / 1000 * 30
5.2.1 Calculate Process
a. If KWH ≤ 30 then, pay = KWH * 169
b. If KWH> 30 to 60 then, pay = (30 * 169) + (KWH - 30 * 360)
c. If KWH> 60 then, pay = (30 * 169) + (30 * 360) + (KWH - 60 * 495)
Cost = power * 11
Total = (pay + expenses) * 1:04
5.2.2 Process Deviation
a. Max power consumption = 400 * / 1000
b. Min power consumption = 180 * / 1000


5.3 Design DataBase
In Designing Database Software required DBMS (Data Base Management System), which is used in the design of applications systems Billing Information Sepatan Electricity in the service area is Oracle.
This database consists of several tables contains a field - the field required in the design of Information Systems.

5.3.1 DFD (Data Flow Diagram)
DFD describes the data flow from the PLN as a source of data providers (input) to consumers PLN as the recipient of the data (output).
1. Context diagram

2.DFD Level 0


1   DFD Level 1 Process 1 Login
 






DFD Level 1 Proses 2 data processing goods
DFD Level 1 Proses 3 data processin customers
  DFD Level 1 Proses 4 usage calculate
5.3.2 normalization
Form Unnormal
Is a table consisting of all the fields that will be used in an Electric Billing Information System database

1NF
 
In each slice of the column and each row has a value of data - each.

  2NF
All fields depending on nomor_pelanggan, because nomor_pelanggan is as key

  3NF
At this stage of 3NF is eligible to be a relation scheme.

 SCHEME RELATIONSHIP

 Table structure
a. Customers table
Customers table contains all the objects owned by the Customer

5.3 Designing the interface
In making the user interface writers to use software tools for Microsoft Visual Basic 6.0 Implementation and design looks.
5.3.5 Design Input
Electricity Billing Information System design requires input that serves to incorporate customer data into the Computer System.


5.4 Implementation Results
The results of implementation contained in the Application of Electricity Billing Information System are as follows:
1. When Customer Complaints