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
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
Step by step
Solved in 3 steps