Medical Store Management System ER Diagram

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

July 17 2017

Posted By: freeproject
Comments: 0

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)

Order Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Order Management System Entity. The entity-relationship diagram of Order Management System shows all the visual instrument of database tables and the relations between Order, update, Product, Product Quality etc. It used structure data...

Defect Tracking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Defect Tracking System Entity. The entity-relationship diagram of Defect Tracking System shows all the visual instrument of database tables and the relations between Register Bug, Project Manager, Bug, Quality etc. It used structure data...

Patient Care System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Patient Care System Entity. The entity-relationship diagram of Patient Care System shows all the visual instrument of database tables and the relations between Medicines, Treatments, Patient, Doctors etc. It used structure data and to...

Cheque Book Transaction System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Cheque Book Transaction System Entity. The entity-relationship diagram of Cheque Book Transaction System shows all the visual instrument of database tables and the relations between Account, Balance, Cheque Book, Customer etc. It used...

Bus Booking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Bus Booking System Entity. The entity-relationship diagram of Bus Booking System shows all the visual instrument of database tables and the relations between Booking, Sales, Bus, Operators etc. It used structure data and to define the...

Travel Agency Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Travel Agency Management System Entity. The entity-relationship diagram of Travel Agency Management System shows all the visual instrument of database tables and the relations between Customer, Bookings, Travel Agency, Payments etc. It...

Sales And Inventory Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Sales And Inventory Management System Entity. The entity-relationship diagram of Sales And Inventory Management System shows all the visual instrument of database tables and the relations between Customer, Sales, Inventory, Supplier etc...

E-Learning Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of E-Learning Management System Entity. The entity-relationship diagram of E-Learning Management System shows all the visual instrument of database tables and the relations between Students, Fees, Course, Training etc. It used structure...

E-Governace System ER Diagram

This ER (Entity Relationship) Diagram represents the model of E-Governace System Entity. The entity-relationship diagram of E-Governace System shows all the visual instrument of database tables and the relations between Petition, Customer, Bill, Government Services etc. It used structure data and...

Garment Inventory System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Garment Inventory System Entity. The entity-relationship diagram of Garment Inventory System shows all the visual instrument of database tables and the relations between Inventory, Garments, Brands, Customers etc. It used structure data...