SQL Pharmacy

SQL-database to store data of a pharmacy.

Entities

Articles (subdivided in drugs an ointments) Ingredients Customers Orders Deliveries DeliveryCompanies Drawer and Warehouses

The relationships are shown in two png-files (relations and logical model).

Create tables with pharmacy_createDropTable.sql // Be carefull. This creates empty tables. You will lose all prior stored data.
Use the file pharmacy_populateData.sql to fill the tables with example data.
Use pharmacy_showEverything.sql to output all data.
Use pharmacy_queries.sql to perform example queries on the stored data.

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
20201212 Logisches Modell.png		20201212 Logisches Modell.png
20201212 Relationales Modell.png		20201212 Relationales Modell.png
Apotheke.pdf		Apotheke.pdf
README.md		README.md
pharmacy_createDropTable.sql		pharmacy_createDropTable.sql
pharmacy_populateData.sql		pharmacy_populateData.sql
pharmacy_queries.sql		pharmacy_queries.sql
pharmacy_showEverything.sql		pharmacy_showEverything.sql