Jwellary Shoping System ER Diagram

Subscribe our YouTube channel for latest project videos and tutorials Click Here

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of Jwellary Shoping System Entity. The entity-relationship diagram of Jwellary Shoping System shows all the visual instrument of database tables and the relations between Supplier, Sale, Customer, Stock etc. It used structure data and to define the relationships between structured data groups of Jwellary Shoping System functionalities. The main entities of the Jwellary Shoping System are Customer, Supplier, Purchase, Sale, Gross and Stock.

Jwellary Shoping System entities and their attributes :

  • Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Supplier Entity : Attributes of Supplier are supplier_id, supplier_name, supplier_mobile, supplier_email, supplier_username, supplier_password, supplier_address
  • Purchase Entity : Attributes of Purchase are purchase_id, purchase_customer_id, purchase_amount, purchase_type, purchase_total, purchase_recepit, purchase_bill, purchase_description
  • Sale Entity : Attributes of Sale are sales_id, sales_customer_id, sales_amount, sales_type, sales_description
  • Gross Entity : Attributes of Gross are gross_id, gross_title, gross_name, gross_type, gross_description
  • Stock Entity : Attributes of Stock are stock_id, stock_items, stock_number, stock_type, stock_description

Description of Jwellary Shoping System Database :

  • The details of Customer is store into the Customer tables respective with all tables
  • Each entity (Stock, Purchase, Gross, Supplier, Customer) contains primary key and unique keys.
  • The entity Purchase, Gross has binded with Customer, Supplier entities with foreign key
  • There is one-to-one and one-to-many relationships available between Gross, Sale, Stock, Customer
  • All the entities Customer, Gross, Purchase, Stock are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Jwellary Shoping System tables for fast query execution.
Jwellary Shoping System ER Diagram
Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Project Category

Related Entity Relationship Diagram (ERD)

KBC Quiz System ER Diagram

KBC Quiz System ER Diagram

This ER (Entity Relationship) Diagram represents the model of KBC Quiz System Entity. The entity-relationship diagram of KBC Quiz System shows all the visual instrument of database tables and the relations between Answers, Participants, Questions, Level etc. It used structure data and to define the...
Vehicle Management System ER Diagram

Vehicle Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Vehicle Management System Entity. The entity-relationship diagram of Vehicle Management System shows all the visual instrument of database tables and the relations between Driver, Vehicle History, Vehicle, Vehicle Type etc. It used...
Crime Record Management System ER Diagram

Crime Record Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Crime Record Management System Entity. The entity-relationship diagram of Crime Record Management System shows all the visual instrument of database tables and the relations between Complaints, Charge Sheet, Crime, Criminals etc. It used...
Super Market Management System ER Diagram

Super Market Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Super Market Management System Entity. The entity-relationship diagram of Super Market Management System shows all the visual instrument of database tables and the relations between Customer, Sales, Stores, Products etc. It used...
Image Gallery Management System ER Diagram

Image Gallery Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Image Gallery Management System Entity. The entity-relationship diagram of Image Gallery Management System shows all the visual instrument of database tables and the relations between Gallery, Downloading, Image, User etc. It used...
Social Networking Site ER Diagram

Social Networking Site ER Diagram

This ER (Entity Relationship) Diagram represents the model of Social Networking Site Entity. The entity-relationship diagram of Social Networking Site shows all the visual instrument of database tables and the relations between Friends, Shares, Users, Videos etc. It used structure data and to...
Helpdesk Ticketing System ER Diagram

Helpdesk Ticketing System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Helpdesk Ticketing System Entity. The entity-relationship diagram of Helpdesk Ticketing System shows all the visual instrument of database tables and the relations between Support, Client, Ticket, Track etc. It used structure data and to...
Company Canteen Management System ER Diagram

Company Canteen Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Company Canteen Management System Entity. The entity-relationship diagram of Company Canteen Management System shows all the visual instrument of database tables and the relations between Canteen, Sales, Company, Category etc. It used...
Electricity Bill Payment System ER Diagram

Electricity Bill Payment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Electricity Bill Payment System Entity. The entity-relationship diagram of Electricity Bill Payment System shows all the visual instrument of database tables and the relations between Customers, Units, Bills, Consuptions etc. It used...
Stores Manager Sales System ER Diagram

Stores Manager Sales System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Stores Manager Sales System Entity. The entity-relationship diagram of Stores Manager Sales System shows all the visual instrument of database tables and the relations between Customer, Sales, Stores, Supplier etc. It used structure data...
Call FreeProjectz WhatsApp FreeProjectz