The chain of pharmacies "Recipes Rayos X" needs a system to manage the information of its operations, such as the purchase, sale and administration of medicines, in addition to the patients and who prescribed a medicine. The information that must be stored is the following: 1. Patients are identified by the RUT and the name, surname, date of birth, mail, address, various telephone numbers and pension system must be registered. 2. There are various health forecasts, both social and private, and they are correctly codified. 3. Physicians are identified by the RUT. For each doctor, the name, surname, date of birth, specialties and years of practice must be stored. 4. There are various specialties which are adequately codified. 5. Each pharmaceutical company is identified by a code, the name and a telephone number are stored. 6. For each medication, the trade name and formula must be registered. Each drug is sold by a given pharmaceutical company, and the trade name uniquely identifies that drug among that company's products. If a pharmaceutical company is deleted, there is no longer a need to track its products. 7. Each pharmacy has a code, name, address and telephone number. 8. Every patient has a GP. Each doctor has at least one patient. It could happen that over time a patient's GP changes. Therefore it is important to keep a record of the start and end dates of this medical supervision. 9. Patients can purchase medications with or without a prescription. 10. Each pharmacy sells several drugs and has a price for each of them. Each medicine can be sold in several pharmacies, and the price can vary from one to another. 11. Doctors prescribe drugs to their patients. Each doctor can prescribe one or several drugs to several patients, and each patient can get prescriptions from several doctors. Each prescription has a date and list of drugs and an amount associated with them. 12. Pharmaceutical companies have long-term contracts with pharmacies. Each pharmaceutical company can contract with several pharmacies, and each pharmacy can contract with several pharmaceutical companies. For each contract, you must save the start date, the end date and the full text. 13. Pharmacies appoint a supervisor for each contract. There must always be one supervisor per contract, but the supervisor of a contract can change during its validity period. Regarding the previous document: - Create the list of Entities and their attributes identified from the delivered statement, with a brief description of each entity and attributes

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

The chain of pharmacies "Recipes Rayos X" needs a system to manage the information of its operations, such as the purchase, sale and administration of medicines, in addition to the patients and who prescribed a medicine. The information that must be stored is the following:
1. Patients are identified by the RUT and the name, surname, date of birth, mail, address, various telephone numbers and pension system must be registered.
2. There are various health forecasts, both social and private, and they are correctly codified.
3. Physicians are identified by the RUT. For each doctor, the name, surname, date of birth, specialties and years of practice must be stored.
4. There are various specialties which are adequately codified.
5. Each pharmaceutical company is identified by a code, the name and a telephone number are stored.
6. For each medication, the trade name and formula must be registered. Each drug is sold by a given pharmaceutical company, and the trade name uniquely identifies that drug among that company's products. If a pharmaceutical company is deleted, there is no longer a need to track its products.
7. Each pharmacy has a code, name, address and telephone number.
8. Every patient has a GP. Each doctor has at least one patient. It could happen that over time a patient's GP changes. Therefore it is important to keep a record of the start and end dates of this medical supervision.

9. Patients can purchase medications with or without a prescription.
10. Each pharmacy sells several drugs and has a price for each of them. Each medicine can be sold in several pharmacies, and the price can vary from one to another.
11. Doctors prescribe drugs to their patients. Each doctor can prescribe one or several drugs to several patients, and each patient can get prescriptions from several doctors. Each prescription has a date and list of drugs and an amount associated with them.
12. Pharmaceutical companies have long-term contracts with pharmacies. Each pharmaceutical company can contract with several pharmacies, and each pharmacy can contract with several pharmaceutical companies. For each contract, you must save the start date, the end date and the full text.
13. Pharmacies appoint a supervisor for each contract. There must always be one supervisor per contract, but the supervisor of a contract can change during its validity period.

Regarding the previous document:
- Create the list of Entities and their attributes identified from the delivered statement, with a brief description of each entity and attributes

 

Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Data Modeling Concepts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education