Medical Store Management System ER Diagram

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)

Medical Diagnostic System ER Diagram

Medical Diagnostic System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Medical Diagnostic System Entity. The entity-relationship diagram of Medical Diagnostic System shows all the visual instrument of database tables and the relations between Tests, Doctors, Medical Reports, Employees etc. It used structure...
internet Banking ER Diagram

internet Banking ER Diagram

This ER (Entity Relationship) Diagram represents the model of internet Banking Entity. The entity-relationship diagram of internet Banking shows all the visual instrument of database tables and the relations between Credit, Fund Transfers, Banks, User etc. It used structure data and to define the...
 Training Management System ER Diagram

Training Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Training Management System Entity. The entity-relationship diagram of Training Management System shows all the visual instrument of database tables and the relations between Skills, Comapny, Training, Knowledge etc. It used structure...
Library Management System ER Diagram

Library Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Management System Entity. The entity-relationship diagram of Library Management System shows all the visual instrument of database tables and the relations between Books, Librarian, Student, Address etc. It used structure data...
Mobile Service Enqiry System ER Diagram

Mobile Service Enqiry System ER Diagram

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

School Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of School Management System Entity. The entity-relationship diagram of School Management System shows all the visual instrument of database tables and the relations between Students, Teachers, Schools, Registrations etc. It used structure...
Clinic Appointment System ER Diagram

Clinic Appointment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Clinic Appointment System Entity. The entity-relationship diagram of Clinic Appointment System shows all the visual instrument of database tables and the relations between Patient, Booking, Clinic, Doctor Schedule etc. It used structure...
Traffic Controller System ER Diagram

Traffic Controller System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Traffic Controller System Entity. The entity-relationship diagram of Traffic Controller System shows all the visual instrument of database tables and the relations between Routes, Traffic Polices, Traffic, Traffic Light etc. It used...
Property Management System ER Diagram

Property Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Property Management System Entity. The entity-relationship diagram of Property Management System shows all the visual instrument of database tables and the relations between Buyers, Property Type, Propetry, Registrations etc. It used...