Water Refilling Station System Database Design Description

Water Refilling Station system Database Design is created using MySQL database. This project will be programmed in java that can enable the user to record things that are being purchased by the client. The water refilling station management system in java is capable of viewing the item that is already delivered. Setting up a water refilling station whereby the station will cater to the reproduction of water through selling large and small amounts of volume.

Purpose

The purpose of this system is to help its clients for an easier and efficient management of stations without sacrificing costs or output. This system is custom made for water refilling stations only.

Basic Features

• MANAGE USERS (Add, List Update)
•  DELIVERY (CONFIRM , CANCEL)
• PRODUCT (ADD , UPDATE , DELETE

Entity Relationship Diagram

Water Refilling Station System Entity Relationship Diagram shows the system entity relationships in each entity and their supposed functions in each relationship.

Database Dictionaries

The water refilling station system database design tables are provided with the entire database details such as Field Name, Descriptions, data types, character lengths.

 

Table 1:CUSTOMER

Field Name	Description	Type	Length
Customer_id(PK)	Number of Customer	int	11
Fname	FirstName of Customer	varchar	50
Lname	LastName of Customer	varchar	50
Address	Customer Full address	varchar	50
Age	Age of Customer	int	2
DATE	DATE	varchar	11
TIME	TIME	varchar	11

Table 2: DELIVERY

Field Name	Description	Type	Length
DELIVERY_ID(PK)	Delivery ID number	Int	7
CUSTOMER_ID(FK)	Customer ID Number	int	11
PRODUCT_ID(FK)	Product ID number	int	50
CONTAINER_ID(FK)	Container ID Number	int	11
FIRST_NAME	First Name Of Customer	int	11
LAST_NAME	Last Name Of customer	Varchar	50
ADDRESS	Address Of Customer	Varchar	50
DATE	Date	Varchar	11
TIME	Time	Varchar	11
CONTAINERS	Containers	Varchar	11
PRODUCT_NAME	Name Of The Product	Varchar	50

Table 3:EMPLOYEE

Field Name	Description	Type	Length
EMPLOYEE_ID(PK)	Employee ID number	Int	11
FIRST_NAME	Employee Firstname	varchar	30
LAST NAME	Employee Last Name	varchar	30
LOCATION	Location of Employee	varchar	50
AGE	Age Of Employee	varchar	11
DATE	Date	varchar	11
TIME	Time	varchar	11
CONTACT_NO	Contact Number of employee	varchar	11

Table 4: PRODUCT

Field Name	Description	Type	Length
PRODUCT_ID(PK)	Product ID number	Int	11
PRODUCT_NAME	Name of the Products	varchar	50
DESCRIPTION	Description of Products	varchar	50
QUANTITY	Quantity of products	int	1
ON_HAND	Not Available	varchar	11
UNIT_PRICE	Price of items	int	1

Table 5: TYPES_OF_CONTAINER

Field Name	Description	Type	Length
CONTAINER_ID(PK)	Container ID number	Int	11
CONTAINERS	number of Contaniners	int	11
QUANTITY	Customer Suggested ORDER	varchar	50
ON_HAND	Available and Not Available	Varchar	30
UNIT_PRICE	Price Of Containers	int	1

Table 6: PAYMENTS

Field Name	Description	Type	Length
PAYMENT_ID(PK)	Payment ID number	Int	11
CUSTOMER_ID(FK)	Customer ID Number	int	11
DATE_ORDER	Date Of ORDER	varchar	50
DATE_CLAIM	Date Of Claim	varchar	30
QUANTITY	Customer Suggested Order	int	1
UNIT_PRICE	Price Of Order	int	11

 TABLE KEYS

sTable Name	Field Name	Key Type
CUSTOMER	Customer_ID	PK
EMPLOYEE	Employee_ID	PK
DELIVERY	Delivery_ID	PK
PRODUCT	Product_ID	PK
TYPES_OF_CONTAINER	Container_ID	PK
PAYMENTS	Payment_ID	PK
TRANSACTION	Transaction_ID	PK

This project was created by JERIMYKIRK G. ERIMAN

Recommended Materials You like

• Database Design for Clinic Management System
• Frozen Food Ordering System Database Design
• Water Billing System