Database Design Project For Monitoring Management System

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.

Database Design Project For Monitoring Management System Document Here.

Leave a Comment