Bolaloy’s Rice Milling Management System Database Design

Bolaloy’s Rice Milling Management System Database Design

The Bolaloy’s Rice Milling Management System Database Design is a database design system that makes the work of a cashier or a user easy. This kind of system is having an attribute of what you called, saving the data where you entered the information of customer in the said system. This system is also having automatic computing of the cost of a product or item.

The Rice Milling Management System is easy to use. Like for instance, the user will fill-up the form according to or based on the information and identification of the customer. And it has a solution provided or guide for you to be not lost in the procedure. And talking to the quality of a system, the efficiency, learnability, and effectiveness are used in creating in this system.

Bolaloy’s Rice Milling Management System Background and Features

Background

Bolaloy’s Rice Milling Management System is installed in Brgy Rumirang Municipality of Isabela Negros occidental. The name of the System is derived from the last name of the owner.

 Features

  • Manage customer
  • Save Personal information
  • Computing cost
  • Check remaining stocks

            

Data Dictionaries

These tables below provide the complete database tables details such as Field Name, Descriptions, data types, character lengths.

Table 1:    tblStocks

Field Name Description Type Length
Stocks_id Stocks number int 11
Co_id Customer id Int 11
Co_fName Customer-first name Varchar 50
Co_lName Customer Last name Varchar 50
Job_id Job title Varchar 50
Phone_no Customer contact Varchar 50
RiceCode Rice_Code Int 7
RiceVariety Rice_Name Varchar 50
SackQty Rice_count Int 11
Date_Stored Date of when Stored Date 10

 

 

Table 2:    tblcustomer

Field Name Description Type Length
Customer_id Customer number int 11
fname Customer-first name Varchar 50
lName Customer last name Varchar 50
Address Customer address Varchar 50
Job_id Job title Varchar 50
Contact_No. Customer contact Varchar 50

 

Table 3:    tblemployee

Field Name Description Type Length
emp_id Stocks number int 11
First_name Customer-first name Varchar 50
Last_name Customer last name Varchar 50
Email Customer Email Varchar 50
address Address Varchar 50
contact_no Employee Contact no Varchar 50
hire_date Hire date Date 11
Job_id Job title Varchar 50
Monthly_salary employee salary Int 11

 

Table 4:    tblricehistory

Field Name Description Type Length
Customer_id Customer number int 11
r_Code Rice code Varchar 50
r_Variety Rice Variety Varchar 50
r_qty Rice quantity Int 50
r_Price Rice price Int 50
r_Total Rice total Int 50
Amount Amount Int 11
Change Change Int 50
historyDate History Date Date 11

 

 

            Table 5:    tblRecords

Field Name Description Type Length
Costumer_id customer information Int 7
cFname Customer-first Name Varchar 50
cLname Customer last name Varchar 50
Address CustomerLocation Varchar 50
Contact_no Customer No. Int 11
Rice_id RiceInformation Varchar 50
Rice_Code Rice Code Int 11
Variety Rice Name Varchar 50
Rice_Volume Rice Quantity Int 11
Price_per_sack Rice Price Per Sack Int 11
SubTotal Overall total cost int 11
storedDate Date when Stored Date 11

 

 

Entity Relationship Diagram

Bolaloy’s Rice Milling and Sales System Entity Relationship Diagram show the system entity relationships in each entity and their supposed functions in each link.

Figure 1. Bolaloy’s ER Diagram for Rice Milling Management System 

 

 

The proposed Bolaloy’s Rice Milling Management System Entity Relationship Diagram are the entity of the proposed Bolaloy’s Rice Milling Management System Database Design, which are presented by tables; the tables are made to meet the required specification of the system and provide much more specific details of each entity within the system.

Download the full documentation of Rice Milling Management System Database Design PDF here. lastCommitBolaloy

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 Comment