Pharma Dbm Notes 5th Sem Top -

Manipulates the data inside the tables.

  • UPDATE: Modifies existing data.
  • DELETE: Removes data.
  • Tool checklist: Excel for forecasting, simple regression for trend, share-of-voice tracking.


    Defines the database structure.

  • ALTER: Modifies existing structure.
  • DROP: Deletes entire table/database.
  • 1. Data vs. Information

    2. Database

    3. Database Management System (DBMS)

    4. File Systems vs. DBMS

  • DBMS:
  • 5. DBMS Architecture

    6. Data Independence


    The primary route of elimination is the kidney.

    Renal Excretion Processes:

    Clearance (Cl): Volume of blood cleared of drug per unit time. Total body clearance Cl_total = Cl_renal + Cl_hepatic + Cl_other.

    Important: Creatinine clearance (CrCl) to adjust doses in renal failure (Cockcroft-Gault equation). pharma dbm notes 5th sem top

    This is the foundation. You cannot understand PK without absorption.

    Key Definitions:

    Important Factors Affecting Absorption:

    Exam Tip: Expect a short note on “pH-partition hypothesis” or “comparison of active vs passive transport.” Also learn the Buccal, sublingual, rectal, and transdermal absorption differences. Manipulates the data inside the tables

    Controls access.