Boutique Management System Database Design
This Boutique Management System Database Design or Database Design Project for Boutique Management System with ERD, the machine will lessen the pen paper work that is managed by way of the owners of the store. It will help them to hold the data of the garments, customers, providers with outstanding ease(Boutique Management System with Tables Database Design Project). The stock of the clothes that are to be had ought to be updated from time to time. It can also help them in file era of the income that have taken region from time to time.
The proposed Boutique Store management system was made for the wants and affordable for the people.The systems consists of the clothes,inventory and sales etc.A boutique is a small store that sells stylish clothing jewelry or other luxury goods.
Boutique sales associate are exports within their stores.Each of these store works through its merchandising and to appeal to a certain customers.This project is designed to provide the easy access to maintain the the reports of boutique service.
Boutique service is necessary and important for the society.It gives the people an easy way to choose and buy the items or Goods that suit to their interest,and likes.It is also provides a very affordable piece that will surely make the people buy and support the products displayed in the boutique store.
The items like clothes and jewelries has many different types that will really attract and catch the attention of the people .Unlike the usual boutique we usually seen,this proposed boutique system has a lot of unique styles and properties on how to encourage the people to chose and buy its products.Indeed this proposed boutique system is usually suitable for the people.
Boutique Management System Database Design Features:
- Manage boutique
- Manage customer
- Monitor the In and Out of boutique
- Boutique inventory
Entity Relationship Diagram of Boutique Management System
Figure 8 The proposed Botique Store Management System Entity Relationship Diagram shows the system entity relationships in each entity and their supposed functions in each relationship(Boutique Management System with Tables Database Design Project).
Diagram of Boutique Management System
Based on figure 8, the proposed Botique Store System Entity Relationship Diagram are the entity of the proposed Botique Store 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 the each entities within the system(Database Design Project for Boutique Management System with ERD).
Table 8: tblboutique
|Botique_ID||Boutique ID number||Int||11|
|Owner_id||Botique Owner Id||Int||30|
|Name||Name of Botique||varchar||50|
|Type||Type of Botique||varchar||50|
|Description||Description of Botique||varchar||50|
|Place||Place of Botique||varchar||50|
Table 9: tblstock
|Stock_id(PK)||Stock ID number||Int||11|
|Stock_items||Items of stock||varchar||50|
|Stock_type||Type of stock||varchar||50|
|Stock_description||Type of description||varchar||50|
Table 10: tblproducts
|product_id(PK)||product ID number||Int||11|
|Product_customer_id||Product customer ID number||int||11|
|Product_items||Items of product||varchar||50|
|Product_type||Type of product||varchar||50|
Table 11: tblsales
|Sales_id(PK)||Sales id number||Int||11|
|Sales_customer_id||Sales customer id||Int||11|
|Sales_type||Type of sales||Varchar||50|
|Sales_description||Description of sales||varchar||50|
Table 12: tblinventory
|Inventory_ID(PK)||Inventory id number||Int||11|
|Inventory_items||Items of inventory||varchar||50|
|Inventory_type||Type of inventory||Varchar||50|
Table 13: tblcustomers
|customer_ID||customer ID number||Int||11|
|Customer_name||Name of customer||varchar||50|
|Customer_phone_num||Customer phone num||int||11|
|Customer_email||Email of customer||varchar||50|
|Customer_address||Address of customer||varchar||50|
This Boutique Management System project is for cloth store. The owners at the clothing stores discover it difficult to manage all of the jewelry that take place inside the boutique. So to lessen the pen paper work this is involved, this boutique control application will be of first rate help.
The client details, garment details, provider details, sales, billing and file generation can be maintained via this application. This may be one in all the beneficial initiatives for the proprietors of the clothing shops in maintaining all the jewelry of their shops in a properly organized way and with awesome ease.
Related Database Design project you may Like
- Database Design for Restaurant Reservation System Project
- Laundry Management System Database Design
- Database Design Project for Inventory Management System
- Database Design Project for Bakery Management System
- Resort Management System Database Design with ERD
- Database Design for Auto parts Income Monitoring System