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 |
| 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.
- ER Diagram for Sales and Inventory System Database Design
- Ordering System Database Design with ERD
- ER Diagram for Water Refilling Station System Database Design
If you have any questions or suggestion, please feel free to contact us or you can leave a message below.