Database Design Project for PEPSI Monitoring Management System
This Database Design Project for PEPSI Monitoring Management System or PEPSI Distribution Monitoring Management System Database Design with ERD also takes the profit and expenses that they might also be written in a daily logbook and it is a hassle because you might come to an error that causes your own mistakes(Database Design for PEPSI Distribution Monitoring Management System with ERD and Tables).
Pepsi Cola is a big company based in a different country that has assigned a person or branch owner to distribute their product in assigned area. This kind of business needs a better system to use that can comply with their needs in an everyday transaction, monitoring and distribution of product to make easy for them to put the data of details in every transaction.
I made an effort to make this thing happen. I see the problem and the problem is until now the calculation of product sold is still manual and it takes more time to compute and put in the daily logbook of the product being distributed in a particular area assigned in every municipality or city.
Not only that, but I see the daily logbook of attendance of the employee of the said branch also still manual and the daily time record of the employees can be misplaced or can be broken because of human error.
That one is very important because they have a policy that no work no pay so if the logbook will misplace the payroll will be affected.
Added to this the human error can cost much money, to the business. I see the existing system in this branch that their system is only an inventory.
This management also needs to calculate the profit and expenses in every transaction.
Walk-in or distribution needs clear details in every transaction to prevent money loss and make this branch have a better income and away from debt(PEPSI Distribution Monitoring Management System Database Design with ERD ).
Pepsi distribution monitoring and management system often gives satisfaction to the user in terms of convenient time to calculate money of the branch , calculation payroll of employee, calculate profit and expenses of the branch , and the route of every vehicle in everyday distribution, added to this the easiest way to put data in a system through few typing in a text field, using Combobox to the other details of every transaction .
Database Design Project for PEPSI Monitoring Management System : FEATURES
- Monitored every transaction
- Safe to enter data
- Daily time record of the employee
- Money, profit and expenses calculation
Database Design Project for PEPSI Monitoring Management System : Data Dictionaries
These Database Design for PEPSI Distribution Monitoring Management System with ERD and Tables below provide the entire database tables details such as Field Name, Descriptions, data types, character lengths.
Table 1: tblclient
|Clnt_amount||Amount sold on product||Int||11|
|Clnt_date||Date of sales||varchar||30|
Table 2: tblemployee
|Empl_id||Employee ID Number||Int||11|
|Empl_salary||Salary per week||Int||11|
Table 3: tblprodsold
|Pros_product||Kinds of product||varchar||30|
|Pros_amount||Amount of product sold||int||11|
|Pros_client||Name of client||varchar||30|
|Pros_date||Date of sales||varchar||30|
Table 4: tbldelivery
|Del_amount||Amount sold on product||Int||11|
|Del_date||Date of delivery||varchar||30|
Table 5: tblproductinput
|Prdin_quantity||Quantity of product||Int||11|
|Prdin_date||Date of input||varchar||30|
ER Diagram for Database Design Project for PEPSI Distribution Monitoring Management System
Pepsi Distribution, Monitoring And Management System Entity Relationship Diagram shows the system entity relationships in each entity and their supposed functions in each relationship.
Figure 1: Proposed Pepsi Distribution, Monitoring and, Management System
Figure 1 shows the proposed Pepsi Distribution, Monitoring And Management System Entity Relationship Diagram are the entity of the proposed Pepsi Distribution, Monitoring, And Management System database, which are presented by tables; the tables are made to meet the required specification of the system and provide a much more specific details of each entity within the system(Database Design for PEPSI Distribution Monitoring Management System with ERD and Tables).
For More Database Design Examples
- ER Diagram for Sales and Inventory System Database Design
- Ordering System Database Design with ERD
- ER Diagram for Water Refilling Station System Database Design
If you have any question or suggestion about this Database Design Project for PEPSI Distribution Monitoring Management System. please contact or simply leave a comment below.