How abonaeem657/pharmacy-database works
This repository is an Oracle pharmacy-database design and usage example, not an application service. Its documented workflow is to create the relational schema, load sample records, run queries to explore the data, and optionally perform updates. Separate capabilities include ER modeling, a salary-calculation PL/SQL procedure, and role-based access control. The README identifies these capabilities and run steps; no SQL excerpts were provided, so internal SQL dependencies are not inferred.
Main entry points: 1_create_tables.sql Pharmacy Schema · 2_insert_data.sql Sample Data · 3_select_queries.sql Query Examples · 4_update_queries.sql Data Updates
Components 9
Data Modeling
- ER Diagrams
ER-Diagrams
Oracle Database
- Pharmacy Schema
SQL-Scripts/1_create_tables.sql - Oracle Database
Database Operations
- Sample Data
SQL-Scripts/2_insert_data.sql - Query Examples
SQL-Scripts/3_select_queries.sql - Salary Procedure
SQL-Scripts/3_select_queries.sql - Data Updates
SQL-Scripts/4_update_queries.sql - Role Permissions
SQL-Scripts
Other components
- Database User
Connections 9
- Database User → Pharmacy Schema: executes first
README.md - Pharmacy Schema → Oracle Database: creates schema
README.md - Database User → Sample Data: executes next
README.md - Sample Data → Oracle Database: loads records
README.md - Database User → Query Examples: runs queries
README.md - Query Examples → Oracle Database: queries data
README.md - Database User → Data Updates: runs updates
README.md - Data Updates → Oracle Database: updates records
README.md - Salary Procedure → Oracle Database: calculates salary
README.md