- Posted By: freeproject
- Comments: 0
Posted By freeproject on July 17, 2017
This ER (Entity Relationship) Diagram represents the model of Gift Shop Portal System Entity. The entity-relationship diagram of Gift Shop Portal System shows all the visual instrument of database tables and the relations between Customers, Inventory, Gifts, ##keyword6## etc. It used structure data and to define the relationships between structured data groups of Gift Shop Portal System functionalities. The main entities of the Gift Shop Portal System are Gifts, Customers, Sales, Inventory, Stocks and ##keyword6##.
Gift Shop Portal System entities and their attributes :
- Gifts Entity : Attributes of Gifts are gift_id, gift_name, gift_expeces, gift_type, gift_description
- Customers Entity : Attributes of Customers are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
- Sales Entity : Attributes of Sales are sales_id, sales_customer_id, sales_amount, sales_type, sales_description
- Inventory Entity : Attributes of Inventory are inventory_id, inventory_items, inventory_number, inventory_type, inventory_description
- Stocks Entity : Attributes of Stocks are stock_id, stock_items, stock_number, stock_type, stock_description
- ##keyword6## Entity : Attributes of ##keyword6## are ##AttributeList6##
Description of Gift Shop Portal System Database :
- The details of Gifts is store into the Gifts tables respective with all tables
- Each entity (##keyword6##, Sales, Stocks, Customers, Gifts) contains primary key and unique keys.
- The entity Sales, Stocks has binded with Gifts, Customers entities with foreign key
- There is one-to-one and one-to-many relationships available between Stocks, Inventory, ##keyword6##, Gifts
- All the entities Gifts, Stocks, Sales, ##keyword6## are normalized and reduce duplicacy of records
- We have implemented indexing on each tables of Gift Shop Portal System tables for fast query execution.
