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)

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...
Art Gallery Management System ER Diagram

Art Gallery Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Art Gallery Management System Entity. The entity-relationship diagram of Art Gallery Management System shows all the visual instrument of database tables and the relations between Customer, Order Update, Arts, Arts Stock etc. It used...
Login Authentication System ER Diagram

Login Authentication System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Login Authentication System Entity. The entity-relationship diagram of Login Authentication System shows all the visual instrument of database tables and the relations between Password, Changing Password, Username, Groups etc. It used...
Form Publishing System ER Diagram

Form Publishing System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Form Publishing System Entity. The entity-relationship diagram of Form Publishing System shows all the visual instrument of database tables and the relations between Publish, Email, Web Form, Login 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...
Attendance Management System ER Diagram

Attendance Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Attendance Management System Entity. The entity-relationship diagram of Attendance Management System shows all the visual instrument of database tables and the relations between Employee, Holidays, Attendance, Login etc. It used...
Employee Attendance System ER Diagram

Employee Attendance System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Employee Attendance System Entity. The entity-relationship diagram of Employee Attendance System shows all the visual instrument of database tables and the relations between Employees, Leave, Attendance, salary etc. It used structure...
Campus Recruitment System ER Diagram

Campus Recruitment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Campus Recruitment System Entity. The entity-relationship diagram of Campus Recruitment System shows all the visual instrument of database tables and the relations between College, Job, Student, Qualification etc. It used structure data...
Dental Hospital Management ER Diagram

Dental Hospital Management ER Diagram

This ER (Entity Relationship) Diagram represents the model of Dental Hospital Management Entity. The entity-relationship diagram of Dental Hospital Management shows all the visual instrument of database tables and the relations between Patient, Nurses, Dental Problems, Medicines etc. It used...
Financial Management System ER Diagram

Financial Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Financial Management System Entity. The entity-relationship diagram of Financial Management System shows all the visual instrument of database tables and the relations between Ledgers, Expenses, Accounts, Stock etc. It used structure...
Call FreeProjectz WhatsApp FreeProjectz