database design example for income monitoring system

Database Design for Income Monitoring Management System

by

Database Design for Income Monitoring Management System

The Database Design for Income Monitoring Management System is a product of database design projects. This income monitoring system is developed to easily store information and monitor monthly income.

It shows the owner how to easily handle income without any difficulty as to manual monitoring. If he wants to know about how his monthly income sales and the product purchased, he can use and open it, so that he’ll know how his business works.

This database design for income monitoring system is a versatile business management software that seamlessly integrates all of your stock manager accounting and reporting processes in one day to use package.

It is also develop for customers and users satisfaction, then it is design to understand how your business works-and how to optimize your processes the advanced window based software is infinity adaptable. It can be configured to suit your individual business needs. This system is enjoyable to use, you will never become wearisome.

FEATURES:

Database Design Example for Income Monitoring Management System Features

  • Store Records (History) in which you can see the previous purchased product and the previous income.

  • Easy and faster monitoring

  • Easy and faster monitoring

  • Organized information

  • Accurate updates of information

Data Dictionaries

TABLE 1 USERS_TABLE

FIELD NAME DESCRIPTION TYPE LENGTH
USER_ID Id number of user Int 30
USERNAME Sure name of the user Varchar 50
PASSWORD Password Varchar 50
FIRSTNAME Name of the user Varchar 50
LAST_NAME Sure name of the user Varchar 50
GENDER Gender of the user Varchar 30
CONTACT Contact number Varchar 50
ADDRESS Address of the user Varchar 50
DATE Date Timestamp  

TABLE 2 TRANSACTION_TABLE

FIELD NAME DESCRIPTION TYPE LENGTH
USER_ID Id number of the user Int 30
COSTUMER_ID Id number of the costumer Int 30
PRODUCT_ID Id number of the product Int 30
COSTUMER NAME Name of the costumer Varchar 30
PRODUCT Name of the product Varchar 30
PRICE Price Int 11
QUANTITY Quantity Int 11
TAX Tax Int 11
TOTAL_PRICE Total price Int 11
AMOUNT_TENDERED Cash on hand Int 11
CHANGE Change Int 11
NET Net Int 11
DATE Date Timestamp  

TABLE 3 CUSTOMER_TABLE

FIELD NAME DESCRIPTION TYPE LENGTH
COST_ID Id number of the costumer Int 30
COST_NAME  Name of the costumer Varchar 50
COST_NUMBER Contact number of the costumer Varchar 50
COST_ADDRESS Address of the costumer Varchar 50

TABLE 4 INCOME_TABLE

FIELD NAME DESCRIPTION TYPE LENGTH
USER_ID Users id Int 11
PRODUCT_ID Products id Int 11
PRICE Price Int 11
QUATITY Quantity Int 11
TAX Tax Int 11
TOTAL_PRICE Total price Int 11
DATE Date Timestamp  

TABLE 5 PRODUCT_TABLE

FIELD NAME DESCRIPTION TYPE LENGTH
PRODUCT_ID Products id Int 11
PRODUCT_NAME Name of the product Varchar 50
PRODUCT_PRICE Price of the product Int 11

ENTITY RELATIONSHIP DIAGRAM

DATABASE DESIGN FOR LIMEN AUTOPARTS INCOME MONITORING MANAGEMENT SYSTEM
DATABASE DESIGN FOR LIMEN AUTOPARTS INCOME MONITORING MANAGEMENT SYSTEM

For More Database Design Examples

Leave a Comment