Pharmaceutical Industry ERD Design

As a Data Engineer, I designed and developed a comprehensive Entity Relationship Diagram (ERD) for a pharmaceutical industry database. The goal was to build a well-structured relational data model that ensures scalability, efficiency, and data integrity.

Key Contributions:

Requirements Analysis: Collected and analyzed business requirements for managing branches, staff, customers, suppliers, products, and orders.

Database Modeling: Designed normalized database schema to avoid redundancy and ensure consistency.

Entity Relationships: Defined logical connections between entities such as orders, products, suppliers, categories, and customers.

Primary & Foreign Keys: Established proper primary/foreign key constraints to maintain referential integrity across the database.

Pharmaceutical Context: Included domain-specific attributes such as dosage forms, expiry dates, suppliers, and product categories to tailor the model to pharmaceutical operations.

Scalability: Structured the database to support business growth, multiple branches, and complex order management.