Pharmacy Prescriptions Case Study

Problem: The goal is to design a database of a pharmacy system.

Description:

Patients, or customers, in a pharmacy system, have prescriptions, written by

a doctor, and are served accordingly by the pharmacist.

Every patient in this system has a unique ID in addition to non$-$unique

personal data such as phone number, address, first and last name, and ID$.$

Using their IDs, the patient and the doctor are identified specifically for each

prescription. In the exact same way, doctors have a dataset table with their own

personal data and IDs.

Prescription medication information is kept in a separate table. In addition to

non$-$unique data like name, code, etc., each prescription has a unique ID$.$

Also, there are two categories of medication, the ones that are written in the

Prescription, and the ones that are in the stock. medication in the prescription

itself may include several data like $($Id$,$ Code, Name, and Cost$).$ On the other

hand, Medication in the stock $($in the pharmacy$)$ itself may include several data like $($Id$,$ Code, Name, Cost, Date Manufactured, Date Expired, Entrance Date,

and Manufacturer$).$

There are various number of payment methods for paying the Prescription

such as $($Visa$,$ PayPal, Check, or cash$)$

Criteria

$$ Patients $($customers$)$ can have many prescriptions, but each prescriptiononly relates to one patient.

$$ Each prescription is exclusive to a doctor. However, each doctor may

compose a large number of prescriptions.

$$ Each patient or doctor is assigned a distinct address. However, many

patients and doctors may have similar addresses.

$$ Prescription payments can be made using various methods with unique

IDs. Only one type of payment is accepted for each prescription.

$$ A patient's prescription may include multiple medications. However, each

prescribed medication is specific to one prescription.

$$ Although each medicine in stock has a unique ID$,$ it may be associated with

many prescriptions.

$$ In each prescription, the doctor may write several medications.