💊 PharmacySystem

A comprehensive database solution for modern pharmacy management.

This repository provides a robust, normalized relational database designed to handle inventory, prescriptions, and sales transactions.

---

🚀 Environment Setup

1. Prerequisites

First, ensure you have the necessary Oracle environment installed:

• Engine: Oracle Database (Free Tier)
• GUI: SQL Developer or DBeaver

2. Connection Profile

Establish a connection as the SYSTEM user with the following parameters:

Parameter	Value
Username	system
Password	[Your chosen password]
Hostname	localhost
Port	1521
SID / Service	free / FREEPDB1

---

🛠 Database Deployment

Follow these steps in sequence to ensure data integrity and proper permission mapping.

Phase A: User Creation

Execute the Create_User.sql script.

Important

The user must be named C##PHARMACYSYSTEM. Ensure you grant all necessary system permissions (CREATE SESSION, CREATE TABLE, UNLIMITED TABLESPACE) to this user before proceeding.

Phase B: Schema Construction

1. Initialize Tables: Run the core PharmacySystem.sql to build the relational structure.
2. Initialize Views: Run AllViews.sql to set up the reporting and abstraction layers.

Phase C: Data Seeding

To populate the system for testing or demonstration, run the Generated_Data.sql script.

---

📊 System Architecture & Design

Relational Model & Data Flow

The system architecture follows a 3rd Normal Form (3NF) structure to ensure data consistency and efficient transaction handling.

Entity Relationship Diagram (ERD)

Data Flow Diagram (DFD)

---

💻 User Interface Preview

Authentication & Dashboards

Below are snapshots of the front-end implementation connected to this database.

Registration	User Dashboard	Admin Panel

---

📂 Project Assets

• Documentation: Data Analysis Deep-Dive
• Presentation: Project Overview Slide Deck
• External Logic: ERD Reference Guide

---