Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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.

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
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:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter5: Advanced Data Modeling
Section: Chapter Questions
Problem 8C
See similar textbooks
icon
Related questions
Question
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.
Transcribed Image Text: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
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
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…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS