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 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 |
| 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.