Medical Store Management 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 Medical Store Management System Entity. The entity-relationship diagram of Medical Store Management System shows all the visual instrument of database tables and the relations between Medicines, Company, Medical Shop, Sells etc. It used structure data and to define the relationships between structured data groups of Medical Store Management System functionalities. The main entities of the Medical Store Management System are Medical Shop, Medicines, Stocks, Company, Inventory and Sells.

Medical Store Management System entities and their attributes :

  • Medical Shop Entity : Attributes of Medical Shop are medical_shop_id, medical_shop_medicine_id medical_shop_name, medical_shop_type, medical_shop_description, medical_shop_address
  • Medicines Entity : Attributes of Medicines are medicine_id, medicine_name, medicine_company, medicine_composition, medicine_cost, medicine_type, medicine_dose, medicine_description
  • Stocks Entity : Attributes of Stocks are stock_id, stock_items, stock_number, stock_type, stock_description
  • Company Entity : Attributes of Company are company_id, company_medicine_id company_name, comapny_type, company_description, company_address
  • Inventory Entity : Attributes of Inventory are inventory_id, inventory_items, inventory_number, inventory_type, inventory_description
  • Sells Entity : Attributes of Sells are sell_id, sell_name, sell_type, sell_sercription

Description of Medical Store Management System Database :

  • The details of Medical Shop is store into the Medical Shop tables respective with all tables
  • Each entity (Sells, Stocks, Inventory, Medicines, Medical Shop) contains primary key and unique keys.
  • The entity Stocks, Inventory has binded with Medical Shop, Medicines entities with foreign key
  • There is one-to-one and one-to-many relationships available between Inventory, Company, Sells, Medical Shop
  • All the entities Medical Shop, Inventory, Stocks, Sells are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Medical Store Management System tables for fast query execution.
Medical Store Management 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)

HRD Management System ER Diagram

HRD Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of HRD Management System Entity. The entity-relationship diagram of HRD Management System shows all the visual instrument of database tables and the relations between Trainings, Departments, Employee, Salary slip etc. It used structure data...
Computer Shop Management System ER Diagram

Computer Shop Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Computer Shop Management System Entity. The entity-relationship diagram of Computer Shop Management System shows all the visual instrument of database tables and the relations between Laptops, Customers, Computer, Repairs etc. It used...
Multiple Choice Quiz System ER Diagram

Multiple Choice Quiz System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Multiple Choice Quiz System Entity. The entity-relationship diagram of Multiple Choice Quiz System shows all the visual instrument of database tables and the relations between Examinations, Courses, Students, Results etc. It used...
Payroll Management System ER Diagram

Payroll Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Payroll Management System Entity. The entity-relationship diagram of Payroll Management System shows all the visual instrument of database tables and the relations between Salary, Appraisals, Payroll, Payments etc. It used structure data...
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...
Payment Management System ER Diagram

Payment Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Payment Management System Entity. The entity-relationship diagram of Payment Management System shows all the visual instrument of database tables and the relations between Bill, Account, Payment, Location etc. It used structure data and...
Library Information System ER Diagram

Library Information System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Information System Entity. The entity-relationship diagram of Library Information System shows all the visual instrument of database tables and the relations between Book Maintenance, Membership Management, Student, Member etc....
Hotel Booking System ER Diagram

Hotel Booking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Hotel Booking System Entity. The entity-relationship diagram of Hotel Booking System shows all the visual instrument of database tables and the relations between Booking, Hotel, Payments, Services etc. It used structure data and to...
Store Management System ER Diagram

Store Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Store Management System Entity. The entity-relationship diagram of Store Management System shows all the visual instrument of database tables and the relations between Product, Bill, Stock, Store etc. It used structure data and to define...
Student Evolution System ER Diagram

Student Evolution System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Student Evolution System Entity. The entity-relationship diagram of Student Evolution System shows all the visual instrument of database tables and the relations between Exams, Results, Student, Merit List etc. It used structure data and...
Call FreeProjectz WhatsApp FreeProjectz