PharmaChainDB

Project Overview

This repository contains the project aimed at designing and implementing a database to manage a chain of pharmacies. The project is divided into two parts:

Part 1: Relational Diagram

Design of a relational database for managing a chain of pharmacies. It includes essential details for pharmacies, employees, medications, laboratories, distributors, orders, and gift products.

File: relational_diagram.pdf

Part 2: Queries and Trigger

Implementation of SQL statements to create the schema, insert data, and write queries and triggers based on the relational schema.

Files:

• creation_tables.sql
• insertion_values.sql
• queries_and_trigger.sql