Water Refilling Management System

Topics: SQL, Procurement, Database transaction Pages: 3 (257 words) Published: January 14, 2014
Customer information
ID
Name
Address
Contact Number
Type
Cash Balance
Container Balance
Description
Container information
ID
Type
Total Count
Unit Price
Description

Conceptual framework

The Conceptual framework shows the inputs and processes on how the customer and the management works’ within the system. Input refers to the data inputted by the customer and management. The data to be input first by the management are the customer and container information’s. The customer information contains id, name, address, contact number, type, cash balance, container balance and description of a customer, while the container information contains id, type, total count, unit price and description of a container. The system provides each the customer and container id automatically. Customer and container information are required to be in the system first to process transactions.

There are four types of transaction, namely: purchase order, delivery, payment and container return. Each of this transaction consists of required information referred in the table below. The customer id, name, type, cash balance, container balances, container type unit price of the specific customer and product are gathered by the system automatically.

Table 1.1 Transaction information
Purchase order
Delivery
Payment
Container return
Customer id
Customer name
Customer type
Container types
Unit prices
Container tracking id’s (optional)
Container count
Total amount
Comment
Customer id
Customer name
Customer type
Container types
Unit prices
Container tracking id’s (optional)
Container count
Total amount
Mode of payment
Comment
Customer id
Customer name
Customer cash balance
Payment amount
Comment
Customer id
Customer name
Customer Container balances
Container types
Return count
Comment

Level 0.
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Management System Essay
  • water refilling Essay
  • Essay about Performance Management systems
  • Waste Management in the Philippines (Water System) Essay
  • Management Info Systems Essay
  • MANAGEMENT CONTROL SYSTEM Controls for Essay
  • Management Information Systems Essay
  • Assignment Information System Management Essay

Become a StudyMode Member

Sign Up - It's Free