Computer Applications in Pharmacy Hub
Web Technologies and Databases
By Arvind Sharma, B.Pharm, M.Pharm, Assistant Professor, MUIT
A2G ACADEMY
Smart Pharmacy Notes
Smart Pharmacy Notes
BP205T Unit 2 Notes – Web Technologies and Databases
Introduction
These notes cover Web Technologies and Databases according to BP205T Computer Applications in Pharmacy syllabus.
These notes are useful for:
- B.Pharm semester exams
- Viva preparation
- Practical preparation
Topics Covered
- Introduction to Web Technologies
- HTML
- XML
- CSS
- Programming Languages
- Web Servers
- Databases
- MYSQL
- MS Access
- Pharmacy Drug Database
Web Technologies
Web technologies are tools and techniques used to create and maintain websites.
Examples:
- HTML
- CSS
- XML
- Programming languages
HTML
HTML stands for HyperText Markup Language.
- It is used to create web pages.
- HTML uses tags to define structure of webpage.
Example Tags:
- <html>
- <head>
- <body>
- <p>
- <h1>
Uses of HTML
- Creating web pages
- Displaying text and images
- Creating tables and forms
XML
XML stands for Extensible Markup Language.
- It is used to store and transport data.
Features:
- User defined tags
- Structured data storage
CSS
CSS stands for Cascading Style Sheets.
- Used for designing web pages.
Uses:
- Changing colors
- Changing fonts
- Layout design
Programming Languages
Programming languages are used to create dynamic web pages.
Examples:
- JavaScript
- PHP
- Python
Web Servers
Web server is a computer that stores websites and delivers web pages to users.
Examples:
- Apache Server
- IIS Server
Database
Database is an organized collection of data.
Uses in pharmacy:
- Patient records
- Drug information
- Inventory management
MYSQL
MYSQL is a relational database management system.
Features:
- Stores large data
- Fast processing
- Secure data storage
MS Access
MS Access is a database software developed by Microsoft.
Uses:
- Patient database
- Drug database
- Reports
Pharmacy Drug Database
Drug database stores information about medicines.
Includes:
- Drug name
- Dose
- Side effects
- Uses
- Contraindications
Applications of Database in Pharmacy
- Patient record management
- Drug information storage
- Inventory control
- Billing system
Important Points for Exams
- HTML is used to create web pages.
- XML stores data.
- CSS designs web pages.
- Database stores information.
- MYSQL is database software.
- MS Access is used in pharmacy databases.
Download Notes PDF
Chapter Notes PDF:
Coming Soon
PDF Preview
Preview Notes:
Coming Soon
Related Notes
Complete Notes Portal
Keywords
- BP205T Unit 2 Notes
- Computer Applications in Pharmacy Notes
- Web Technologies Notes
- Database Notes
- B Pharm Computer Notes
PCI Verified Active 2 min read