Water Refilling Station System Database Design

0
133

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 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

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

water refilling station database design with tables
water refilling station database design with tables

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

Facebook Comments

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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