Point of Sales and Inventory System Database Design

0
401

Point of Sales and Inventory System Database Design is a simple Database Design that will be used for creating a Java Application project. The system is built using the NetBeans IDE. A Sales and Inventory System is all about buying and selling of good computer stuff and products. This Sales and Inventory System database design consists of requirements which are needed for the system. It is easy to use program, user-friendly kind of system. This system is totally similar to the inventory or should I say that I put inventory system on it. The sales and inventory system will provide you the efficiency to look over your system and check them and also you can use it to monitor them.

My Sales and Inventory System gives you the ability to check on your products, add customers, manage suppliers, you can also modify them and more. The system does perform all the functions like ADD, DELETE, UPDATE, REGISTER ACCOUNTS, and many more. The system has also a dark and simple box line design for the “comfortability” of your eyes and it is also well organized for a user to use the program at ease. You will see that there is a graph which allows you to know the exact details of which of your product is getting more demands or details. You can check them accordingly to your own will, you can either check them daily, weekly or even monthly. And like I mentioned earlier that this sales and inventory system looks like an inventory system because you can look after your product and their details. And you can manage them.

Entity Relationship Diagram of Sales and Inventory System

sales and inventory system database
Sales and Inventory System Database Design

Data Dictionaries

 

Table 1: category

Fieldname Description Type Length
CATEGORY_ID category id number int 2
NAME category name varchar 50
DESCRIPTION description of the category varchar 100

 

Table 2: customer

Fieldname Description Type Length
CUST_ID customer id number int 11
FIRST_NAME customer first name varchar 50
LAST_NAME customer last name varchar 50
PHONE_NUMBER contact number of customer int 11

 

Table 3: employees

Fieldname Description Type Length
EMPLOYEE_ID employee id number int 11
FIRST_NAME employee first name varchar 50
LAST_NAME employee last name varchar 50
EMAIL email address of the employee varchar 100
PHONE_NUMBER contact number of the employee int 11
JOB_ID job id number int 11
HIRED_DATE date that employee hired. date
LOCATION_ID location id number int 11

 

Table 4: job

Fieldname Description Type Length
JOB_ID job in number int 11
JOB_TITLE title of job varchar 50
SALARY monthly salary int 50

 

 

 

Table 5: location

Fieldname Description Type Length
LOCATION_ID location id number int 11
PROVINCE location within a country varchar 50
CITY city of province varchar 50
STREET street of the city varchar 50

 

Table 6: manager

Fieldname Description Type Length
FIRST_NAME first name of manager varchar 50
LAST_NAME last name of manager varchar 50
LOCATION_ID location id number int 11
EMAIL email address of the manager varchar 50
PHONE_NUMBER contact number of the manager int 11

 

Table 7: product

Fieldname Description Type Length
PRODUCT_ID product id number int 11
NAME product name varchar 50
DESCRIPTION product’s description varchar 100
QTY_STOCK stock quantity of product int 50
PRICE price of the product int 50
CATEGORY_ID category id number int 11

 

Table 8: supplier

Fieldname Description Type Length
SUPPLIER_ID supplier id number int 11
COMPANY_NAME supplier’s company name varchar 50
LOCATION_ID location id number int 11
PHONE_NUMBER contact number of the supplier int 11

 

 

 

Table 9: type

Fieldname Description Type Length
TYPE_ID type id number int 11
TYPE type of user account registered varchar 50

 

 

Table 10: users

Fieldname Description Type Length
ID account id number int 11
FIRST_NAME first name of the user varchar 50
LAST_NAME last name of the user varchar 50
USERNAME username of the user varchar 50
PASSWORD password of the user varchar 50
TYPE_ID type id number int 11
LOCATION_ID location id number int 11
PHONE_NUMBER contact number of the user int 11

 

Table Keys

Table Name Fieldname Key Type
category CATEGORY_ID PK
customer CUST_ID PK
employee EMPLOYEE_ID PK
job JOB_ID PK
location LOCATION_ID PK
product PRODUCT_ID PK
supplier SUPPLIER_ID PK
type TYPE_ID PK
users ID PK
employee LOCATION_ID FK
employee JOB_ID FK
manager LOCATION_ID FK
product CATEGORY_ID FK
supplier LOCATION_ID FK
users TYPE_ID FK
users LOCATION_ID FK

 

 

Features of Sales and Inventory System Database:

  • INVENTORY CONTROL
    • The stocks level will be automatically updated when the sales and purchases are made.ove stock and inventory tracking through automatically updated stock levels whenever sales and purchases are made. You can manage your inventory across multiple suppliers.
  • INVENTORY OPTIMIZATION

Allows you to have the right amount of stock at the right time. Streamline your internal operations through automated demand forecasting, inventory optimization, and reorder points.

  • SALES REPORT

Access and generate accurate sales reports that offer insights for better business decisions, all in real time. My software allows you to generate sales history.

  • ORDER MANAGEMENT

Synchronize your orders with your inventory and increase your business efficiency from order creation to fulfillment.

  • CUSTOMER RELATIONSHIP

Keep all your customer and supplier data in one place.

  • PRICE LIST

Managing product prices is the key to running a business.

  • POINT OF SALE

Sell your product at Ease.

This Database design is Created by Prince Ly Y. Cesar

 

Facebook Comments

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.