University of Basrah College of CSIT Database Management System ( IS 304) Pharmacy Prescriptions Case Study 1. Problem: The goal is to design a database of a pharmacy system. 2. 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) 3. Criteria ⚫ Patients (customers) can have many prescriptions, but each prescription- only 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.
University of Basrah College of CSIT Database Management System ( IS 304) Pharmacy Prescriptions Case Study 1. Problem: The goal is to design a database of a pharmacy system. 2. 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) 3. Criteria ⚫ Patients (customers) can have many prescriptions, but each prescription- only 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.
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....
Related questions
Question
Transcribed Image Text:University of Basrah
College of CSIT
Database Management System ( IS 304)
Pharmacy Prescriptions Case Study
1. Problem:
The goal is to design a database of a pharmacy system.
2. 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)
3. Criteria
⚫ Patients (customers) can have many prescriptions, but each prescription-
only 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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
