Here are comprehensive notes for Pharmaceutical Database Management Systems (PDBMS) for the 5th Semester (typically B.Pharm). These notes cover the core modules as per the PCI syllabus.
Subject: Pharmaceutical Database Management Systems (PDBMS) Semester: 5th Focus: SQL, ER Diagrams, Database Design, and Pharma Applications.
Unit 1: Introduction to Database Systems 1. Data vs. Information
Data: Raw facts (e.g., patient name, drug ID). It is unprocessed. Information: Processed data that has meaning (e.g., a report showing which patients need a refill). pharma dbm notes 5th sem top
2. Database
An organized collection of structured information or data, typically stored electronically in a computer system. Properties: Represents aspects of the real world, logically coherent, designed for a specific purpose.
3. Database Management System (DBMS)
Software that interacts with end-users, applications, and the database itself to capture and analyze the data. Examples: MySQL, Oracle, Microsoft SQL Server, PostgreSQL.
4. File Systems vs. DBMS
File System:
Pros: Simple, low cost. Cons: Data redundancy (duplication), data inconsistency, difficult access, isolated data, integrity problems.
DBMS: