Database Design Project For Monitoring Management System
This Feeds Supply Monitoring Management System Database Design Project with ERD, Tables is designed for Final Year Requirements DBMS Mini projects.
The Feeds Supply was founded year 2010. Due to Boar Services that the family owns they decided to add another business that is related to their first business.
This supply management System is made to lessen their manual work especially on making big transactions to customers. This will secure all the data and information of customers as well as the transactions towards the client. If the item is unavailable the system will immediately notify the owner. This will help them a lot in monitoring their products because it is more convenient than using manual writing for the transaction. This will also avoid mistakes in monitoring your products. This will give you the exact number of products that are available and the products that were bought by your costumers.
Instead of computing everything through the calculator and encode the products that they bought by means of paper and ballpen this will you calculate and review each product. Each item has its own respective price located at the bottom of the product. This will avoid using a lot of time to find the exact price of each product.
Past transactions can browse too. If you want to review something about your clients or the products they bought the system will automatically flash past transactions according to the data you want to take.
As per the products the supplier price will be shown in the system and also the market price. This will determined their profit. This will help them monitor their products as well as their profit. Adding the transaction for supplier and the owner will be one of the features of this system.
Features:
- Monitor Products
- Monitor records of customer
- Monitor daily transactions
Data Dictionaries
TBL1:TBLCUSTOMER
| Field Name | Description | Type | Length |
| Customer_id | Customer ID number | int | 10 |
| Fname | First name of customer | varchar | 50 |
| Lname | Last name of customer | varchar | 50 |
| Address | Customer Address | varchar | 90 |
TBL2:TBLEMPLOYEE
| Field Name | Description | Type | Length |
| Employee_id | Employee ID number | int | 10 |
| Fname | Employee First Name | varchar | 50 |
| LName | Employee Last Name | varchar | 50 |
| Age | Age of Employee | int | 5 |
| Address | Address of Employee | varchar | 50 |
| Contact_number | Contact Number of Employee | varchar | 20 |
TBL3:TBLORDER
| Field Name | Description | Type | Length |
| Order_id | Order ID number | int | 10 |
| Product_id | Products ID number | int | 10 |
| Date_order | Date ordered of customer | varchar | 50 |
| Quantity | Customer suggested products | int | 10 |
| Price | Price of the products | int | 30 |
| Status | Available or not | varchar | 30 |
TBL4:TBLPRODUCTS
| Field Name | Description | Type | Length |
| Product_id | Product ID number | int | 10 |
| Product_name | Name of the product | varchar | 90 |
| Product_brand | Brand of Product | varchar | 90 |
| Quantity | Quantity of Product | varchar | 10 |
| Price | Price of the Product | varchar | 10 |
TBL4:TBLSUPPLIER
| Field Name | Description | Type | Length |
| Supplier_id | Supplier ID number | int | 10 |
| Product_id | Product ID number | int | 10 |
| First_Name | First Name of the Supplier | varchar | 90 |
| Last_name | Last name of supplier | varchar | 90 |
| Supplier_Address | Address of the Supplier | varchar | 90 |
| Contact_number | Contact number of the supplier | varchar | 30 |
| Received | Recieved date of Product | date |
Entity Relationship Diagram for Feeds Supply Monitoring Management System in Database design Project
Feeds Supply Monitoring Management System entity diagram show how the systems entity with and their function with each other.
Feeds Supply Monitoring Management System Database Design Project
Database Design Project For Monitoring Management System Document Here.