Water Refilling Station System Database Design

5
3034

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.

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 NameDescriptionTypeLength
Customer_id(PK)Number of Customerint11
FnameFirstName of Customervarchar50
LnameLastName of Customervarchar50
AddressCustomer Full addressvarchar50
AgeAge of Customerint2
DATEDATEvarchar11
TIMETIMEvarchar11

Table 2: DELIVERY

Field NameDescriptionTypeLength
DELIVERY_ID(PK)Delivery ID numberInt7
CUSTOMER_ID(FK)Customer ID Numberint11
PRODUCT_ID(FK) Product ID numberint50
CONTAINER_ID(FK)Container ID Numberint11
FIRST_NAMEFirst Name Of Customerint11
LAST_NAMELast Name Of customerVarchar50
ADDRESSAddress Of CustomerVarchar50
DATEDateVarchar11
TIMETimeVarchar11
CONTAINERSContainersVarchar11
PRODUCT_NAMEName Of The ProductVarchar50

Table 3:EMPLOYEE

Field NameDescriptionTypeLength
EMPLOYEE_ID(PK)Employee ID numberInt11
FIRST_NAMEEmployee Firstnamevarchar30
LAST NAMEEmployee Last Namevarchar30
LOCATIONLocation of Employeevarchar50
AGEAge Of Employeevarchar11
DATEDatevarchar11
TIMETimevarchar11
CONTACT_NOContact Number of employeevarchar11

Table 4: PRODUCT

Field NameDescriptionTypeLength
PRODUCT_ID(PK)Product ID numberInt11
PRODUCT_NAMEName of the Productsvarchar50
DESCRIPTIONDescription of Productsvarchar50
QUANTITYQuantity of productsint1
ON_HANDNot Availablevarchar11
UNIT_PRICEPrice of items           int1

Table 5: TYPES_OF_CONTAINER

Field NameDescriptionTypeLength
CONTAINER_ID(PK)Container ID numberInt11
CONTAINERS number of Contaninersint11
QUANTITYCustomer Suggested ORDERvarchar50
ON_HANDAvailable and Not AvailableVarchar30
UNIT_PRICEPrice Of Containersint1

Table 6: PAYMENTS

Field NameDescriptionTypeLength
PAYMENT_ID(PK)Payment ID numberInt11
CUSTOMER_ID(FK) Customer ID Numberint11
DATE_ORDERDate Of ORDERvarchar50
DATE_CLAIMDate Of Claimvarchar30
QUANTITYCustomer Suggested Orderint1
UNIT_PRICEPrice Of Order          int             11

 TABLE KEYS

sTable NameField NameKey Type
CUSTOMERCustomer_IDPK
EMPLOYEE Employee_IDPK
DELIVERYDelivery_IDPK
PRODUCTProduct_IDPK
TYPES_OF_CONTAINERContainer_IDPK
PAYMENTSPayment_IDPK
TRANSACTIONTransaction_IDPK

This project was created by JERIMYKIRK G. ERIMAN

Recommended Materials You like

 

Looking for more source code? Type your keyword here here!

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