DHEN’Z Motorcycle Spare Parts Inventory Management System Database Design Project

DHEN’Z Motorcycle Spare Parts Inventory Management System Database Design Project

The purpose of the DHEN’Z Motorcycle Spare Parts Inventory Management System Database Design Project is to have an easier way to save information to the database and secure the information. This inventory management system is made to help the owner of the Dhen’z motorcycle spare parts to make their everyday transactions easily.

This inventory management system can also use to monitor the product quantity, the price entity, and the item to be ordered to the supplier of the motorcycle spare parts to have efficient stocks. It can also monitor what part of items is fast-moving, and to know which part of the items is still available. Most of all it can help monitor and retrieves information especially in the terms of income.

This system will keep the operations running smoothly to the user up to the transaction to the customer.   This system was built to prevent some problems in transaction to the customer and to monitor those products its availability, quantities, and amount.

Spare Parts Business Background

Since spare parts business is one of the most well-known businesses nowadays Mr. Jesus Naga Delagon plan to start a business since he like to customize motors thus their location is perfect for the planned business so he build spare parts business which is the Dhen’z Motorcycle Spare Parts. On December 2017 at Crossing  Tuguis , Pontevedra Negros Occidental he officially opens and starts operating manually.

Features of Inventory Management System Database Design Project

  • Manage user to Add, Update and Delete the transactions.

  • It helps to monitor the product quantity and product to be ordered to the supplier to have an efficient stock operation.

  • It can help to keep the security and information to the database.

  • To enhance sale productivity and easy to add, list, edit and organize the product.

  • It helps to monitor the product quantity and product to be ordered to the supplier to have an efficient stock operation.

Data Dictionaries of DHEN’Z Motorcycle Spare Parts Inventory Management System Database Design Project

            These tables below provide the entire database tables detail such as Field Name, Descriptions, data type, character lengths.

Table1. tblcostumer

Field Name   Description Type Length
Costumer_no(pk)   Costumer number Int 11
Costumer_id Costumer id   int 11
Firstname   First name varchar 50
Lastname   Last name varchar 50
Phone_number   Phone number varchar 50
Email   Email address varchar 50
Address   Address varchar 50

Table2. tblorder

Field Name   Description Type Length
Oder_id(pk)   Order id int 11
Product_id   Product id int 11
Quantity   Quantity int 11
Price   Price int 11
Subtotal   Subtotal int 11
Costumer_id   Costumer id int 11

Table3. tblproduct

Field Name Description Type Length  
Product_id(pk)   Product id int 11
Product_name   Product name varchar 50
Brand   Product Brand varchar 50
Quantity   Quantity varchar 11
Price      Price              int 11
           Subtotal Subtotal   int 11

Table4. tbltransaction

Field Name   Description Type Length
Transaction_no(pk)   Transaction number int 11
User_id   User id int 11
Costumer_id   Costumer id int 11
Date   Date Date 20
Quantity   Quantity varchar 50
Total amount   Total amount int 11

Table5. tbluseraccount

Field Name   Description Type Length
User_id(pk)   User id int 11
Username   User name varchar 50
Password   User password varchar 50

Table6. tbluserdetail

Field Name   Description Type Length  
User_id(pk)   User id int 11
First_name   First name   varchar 50
Last_name   Last name   varchar 50
Position   Position   varchar 50
Age   Age   int 11
Gender   Gender   varchar 20
      Contact_number   Contact number varchar 11
Email   email varchar 50
Add_id Address id   int 11

Entity Relationship Diagram

 Dhen’z Motorcycle Spare parts Inventory System Entity Relationship Diagram shows the system relationship in each entity and their supposed function in each relationship.

Figure1. Dhen’z Motorcycle Spare parts Inventory System Entity Relationship Diagram

DHEN’Z Motorcycle Spare Parts Inventory Management System Database Design Project Entity Relationship Diagram(ERD) are the entity of the Dhen’z Motorcycle Spare parts Inventory System database which is presented by tables, the tables are made be need the required specification of the system and provide any specific details of the entities within the system.

If you have any questions about DHEN’Z Motorcycle Spare Parts Inventory Management System Database Design Project, please feel free to contact us at our contact page or simply leave a comment below.

Related Database Design project you may Like

Leave a Comment