Aqua Water Refilling Management System Database Design

0
354

Aqua Water Refilling Management System Database Design

The purpose of Aqua Water Refilling Management System Database Design is to overcome difficulties in manual operation in refilling station. The difficulty in the manual system is one of the reasons why the efficiency in availing services of the clients is not satisfying and keeping of records is often misplaced and not secure.

This system will be programmed using java that can enable the user to record things that are being purchased by the clients and it is created using MySQL database.

 

This system manages to display the data to be filled by the user according to the information of the customer in organize manner, such that their personal details, and the services they want to avail as well as the payment on the transaction they purchased. The system keeps the information of the customer and the details of what they purchased.

The system coordinates the arrangement on the delivery of products. It consists all the records for the location of the clients, date of transaction, schedule of delivery, contact number and the person assigned to deliver and the payment of customer to the quantity of product that about to deliver.

The system also views the information about the availability of the products as well as the containers. The system views the available containers to provide stocks again.

This system also manages the information of the employees that a refilling station must have just like a front liner, cashier, technical assistant, and delivery an. It stores the information in organizing so that it easy for the owner to access the detail of his/her employee.

Upon having this system, it will provide the capacity to the owner and clients to transact without spending time and effort.

Basic features:

  • Manage user (add, list updates)
  • Delivery (confirm, cancel)
  • Products (add, delete, update).

 

DATA DICTIONARIES for Water Refilling Management System Database Design

The table below provides the entire database tables details such as field names, descriptions, data type and character length.

TABLE 1. EMPLOYEE

FIELD NAMESDESCRIPTIONTYPELENGTH
EMPLOYEE_ID(pk)EMPLOYEE ID NUMBERINT11
F_NAMEEMPLOYEE FIRST NAMEVARCHAR50
M_NAMEEMPLOYEE MIDDLE NAMEVARCHAR50

 

L_NAMEEMPLOYEE LAST NAMEVARCHAR50
AGEAGE OF EMPLOYEEVARCHAR11
ADDRESSLOCATION OF EMPLOYEEVARCHAR50
CONTACT_#NUMBER OF employeesVARCHAR 

11

 

Table 2. Customer

FIELD NAMESDESCRIPTIONTYPELENGTH
CUSTOMER_ID(PK)CUSTOMER ID NUMBERINT11
F_NAMECUSTOMER FIRST NAMEVARCHAR50
M_NAMECUSTOMER MIDDLE NAMEVARCHAR50

 

L_NAMECUSTOMER  LAST NAMEVARCHAR50
ADDRESSLOCATION OF CUSTOMERVARCHAR50
CONTACT_#NUMBER OF customersVARCHAR 

11

DATEDATE OF TRANSACTIONDATE TIME11

 

TABLE 3. PRODUCT

FIELD NAMESDESCRIPTIONTYPELENGTH
PRODUCT_ID(PK)PRODUCT ID NUMBERINT11
PRODUCT_NAME

 

PRODUCT NAMEVARCHAR50
QUANTITY

 

QUANTITY OF PRODUCTSINT11

 

UNIT_PRICE

 

PRICE OF PRODUCTSVARCHAR50
DATEDATEDATE11

 

TABLE 4. DELIVERY

FIELD NAMESDESCRIPTIONTYPELENGTH
DELIVERY_ID(PK)

 

DELIVERY ID NUMBERINT11
CUSTOMER_ID(FK)

 

CUSTOMER ID NUMBERINT11
PRODUCT_ID(FK)

 

PRODUCT ID NUMBERINT11

 

TRANSACTION_IDTRANSACTION ID NUMBERINT11
QUANTITYQUANTITY OF PRODUCTSINT11
DELIVERY_MANDELIVERY MANVARCHAR50
DATE_DELIVER

 

DATE TO DELIVERDATE TIME11

 

TABLE5.CONTAINERS

FIELD NAMESDESCRIPTIONTYPELENGTH
CONTAINER_IDCONTAINER ID NUMBERINT11
CONTAINER_NO

 

CONTROL NUMBERINT50
QUANTITYQUANTITY ORDER OF CUSTOMERINT20
ON_HAND

 

AVAILABLE CONTAINERSVARCHAR50
UNIT_PRICEPRICE OF CONTAINERSVARCHAR11

 

TABLE 6.PAYMENT

FIELD NAMESDESCRIPTIONTYPELENGTH
PAYMENT_IDPRODUCT ID NUMBERINT11
CUSTOMER_ID

 

CUSTOMER ID NUMBERINT50
TRANSACTION_ID

 

DATE OF TRANSACTIONDATE TIME11

 

TOTALTOTAL OF PURCHASED PRODUCTINT11
AMOUNT_RECEIVED

 

AMOUNT RECEIVEDINT11
CHANGEDCHANGEDINT11

 

TABLE 7.TRANSACTION

FIELD NAMESDESCRIPTIONTYPELENGTH
TRANSACTION_IDPRODUCT ID NUMBERINT11
PRODUCT_ID

 

PRODUCT ID NUMBERINT50
TRANS_TYPE

 

TYPE OF TRANSACTIONVARCHAR11

 

UNIT_PRICEPRICE OF PRODUCTVARCHAR50
QUANTITYQUANTITY OF PRODUCTINT11
TOTAL

 

TOTAL COST OF TRANSACTIONINT11
DATEDATEDATE11

 

ENTITY RELATIONSHIP DIAGRAM

Figure 1 Proposed ER Diagram for water refilling management system shows the system entity relationship in each entity and their supposed function in each relationship.

Figure 1.Aqua Water Refilling Management System Entity Relationship Diagram

Based on figure 1, the proposed ER diagram for water refilling management system show the entity of the proposed Water Refilling Management System Database Design, which is represented by tables, the tables are made to meet the required specification of the system and provide any specific details of each entity within the system.

Download AQUA Water Refilling Management System Database Design Document pdf. WATER REFILLING SYSTEM

For another free material on database design.

If you have any questions or suggestion, please feel free to contact us or you can leave a message below.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.