Can I read Pharmacy Database Design Overview on EtoBox?
Pharmacy Database Design Overview by api-551332616 is a document available to read on EtoBox.
What is Pharmacy Database Design Overview about?
The document describes a database for a pharmacy with tables for patients and prescriptions. The patient table stores patient details with a primary key of MRN. The prescription table stores prescription details for each patient, including the medication name, directions, quantity filled, and refills, with a primary key of RxNum and a foreign key of MRN linking to the patient. A patient can have multiple prescriptions, representing a one-to-many relationship between the patient and prescription tables.
- Author
- api-551332616
- Language
- EN