Database Design for Rice Sales and Inventory Management System

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.

Database Design for Rice Sales and Inventory Management System

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.

Leave a Comment