Jwellary Shoping System ER Diagram

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.

Related Entity Relationship Diagram (ERD)

Library Application System ER Diagram

Library Application System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Application System Entity. The entity-relationship diagram of Library Application System shows all the visual instrument of database tables and the relations between Book, Address, Student, Supplier etc. It used structure data...
Computerized Examination System ER Diagram

Computerized Examination System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Computerized Examination System Entity. The entity-relationship diagram of Computerized Examination System shows all the visual instrument of database tables and the relations between Papers, Results, Exams, Questions etc. It used...
Crime Reporting System ER Diagram

Crime Reporting System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Crime Reporting System Entity. The entity-relationship diagram of Crime Reporting System shows all the visual instrument of database tables and the relations between Criminal, Department, Case, Complaint etc. It used structure data and...
Examination Management System ER Diagram

Examination Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Examination Management System Entity. The entity-relationship diagram of Examination Management System shows all the visual instrument of database tables and the relations between Examinations, Courses, Students, Faculties etc. It used...
Marrige Buero Management ER Diagram

Marrige Buero Management ER Diagram

This ER (Entity Relationship) Diagram represents the model of Marrige Buero Management Entity. The entity-relationship diagram of Marrige Buero Management shows all the visual instrument of database tables and the relations between Registration, Photograps, Partners, Multipile Types etc. It used...
Telephone Billing Payment System ER Diagram

Telephone Billing Payment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Telephone Billing Payment System Entity. The entity-relationship diagram of Telephone Billing Payment System shows all the visual instrument of database tables and the relations between Customers, Tarrifs, Bills, Payments etc. It used...