Database Design for Rice Delivery Sales and Inventory Management System
The Database Design for Rice Delivery Sales and Inventory Management System is a product of DBMS mini project. This database design provides information about the customer; whoever uses the system can freely view the knowledge of the customer.
The network contains an inventory of the rice that is listed on its database. The system also manages the information and details of every rice listed and keeping track for the new delivery. It contains a functional database.
Tracking inventory as it is transported between locations. Receiving items into a warehouse or other area. Keeping track of product sales and inventory levels. Cutting down on product obsolescence and spoilage.
Features
The Rice Delivery Sales and Inventory Management System features
- Manage delivery
- Order Management
- Manage product
- Manage customer
Database Schema: Data Dictionaries
Table 1: customer
| FIELD NAMES | DESCRIPTION | TYPE | LENGTH |
| Customer_id | Customer id number | Int | 5 |
| Customer_fname | Customer first name | Varchar | 50 |
| Customer_lname | Customer last name | Varchar | 50 |
| Contact number | The contact number of customer | Varchar | 50 |
| address | Address of customer | Varchar | 50 |
Table 2: product
| FIELD NAMES | DESCRIPTION | TYPE | LENGTH |
| Rice_id | Rice id number | int | 5 |
| Rice_name | Name of the rice | varchar | 50 |
| price | Price of the rice | Double |
Table 3: transaction
| FIELD NAMES | DESCRIPTION | TYPE | LENGTH |
| Details_id | Details id number | Int | 5 |
| Rice_id | Rice id number | Int | 5 |
| Handler_name | Name of the handler | Varchar | 100 |
Table 4: type
| FIELD NAMES | DESCRIPTION | TYPE | LENGTH |
| Type_id | Type id number | int | 5 |
| Rice_age | Rice age number | Int | 5 |
| Rice_id | Rice id number | Int | 5 |
| class | Class name | Varchar | 50 |
Table 6: tbluser
| FIELD NAMES | DESCRIPTION | TYPE | LENGTH |
| User_id | The user id of the user | int | 5 |
| firstname | Firstname of user | Varchar | 50 |
| Lastname | Lastname of user | Varchar | 50 |
| username | Username of user | Varchar | 50 |
| Contact_number | The contact number of user | Varchar | 50 |
| address | Address of user | Varchar | 50 |
| password | Password of user | Varchar | 50 |
Entity Relationship Diagram
Based on Diagram, the Rice Delivery And Inventory Entity Relationship Diagram are entities of the database, represented as a table, are created and organized by providing connections within the database’s table with the idea of providing clear and decisive information to the user itself.
The proposed Database Design for Rice Delivery Sales and Inventory manage System ERD are the entity of the Rice Delivery Sales and Inventory management System database, 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.
This DBMS mini-project designed by ms. April May Gargarita.
If you have any questions or suggestion, please feel free to contact us or leave a comment below.
You can download here the inventory management systems pdf.