The Prescriptions-R-X chain of pharmacies has offered to give you a free lifetime supply of medicine...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Prescriptions-R-X chain of pharmacies has offered to give you a free lifetime supply of medicine if you could fix their database design shown in the following figure. To fix this design you need to answer (in English, there is no need to re-draw the diagram) 1. In the current design, it says: "Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another". How would this design change if each drug must be sold at a fixed price by all pharmacies? 2. In the current design, it assumed that, if a doctor prescribes the same drug for the same patient more than once, only the last such prescription needs to be stored. How would this design change if the design requirements change as follows: If a doctor prescribes the same drug for the same patient more than once, several such prescriptions may have to be stored. name 0000 start_date end_date text supervisor ssn age address Pharmacy Contract name Patient address phone_num Sell price Pri_physician Prescription Drug Make Pharm co name phy_ssn name Doctor date quentity trade_name ----- formula phone_num speciality exp_years The Prescriptions-R-X chain of pharmacies has offered to give you a free lifetime supply of medicine if you could fix their database design shown in the following figure. To fix this design you need to answer (in English, there is no need to re-draw the diagram) 1. In the current design, it says: "Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another". How would this design change if each drug must be sold at a fixed price by all pharmacies? 2. In the current design, it assumed that, if a doctor prescribes the same drug for the same patient more than once, only the last such prescription needs to be stored. How would this design change if the design requirements change as follows: If a doctor prescribes the same drug for the same patient more than once, several such prescriptions may have to be stored. name 0000 start_date end_date text supervisor ssn age address Pharmacy Contract name Patient address phone_num Sell price Pri_physician Prescription Drug Make Pharm co name phy_ssn name Doctor date quentity trade_name ----- formula phone_num speciality exp_years
Expert Answer:
Related Book For
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff
Posted Date:
Students also viewed these accounting questions
-
The Prescriptions-R-X chain of pharmacies has offered to give you a free lifetime supply of medicine if you design its database. Given the rising cost of health care, you agree. Here's the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Modify BST to add a method size() that returns the number of key-value pairs in the symbol table. Use the approach of storing within each Node the number of nodes in the subtree rooted there.
-
The starships Picard and La Forge are traveling in the same direction toward the Andromeda galaxy. The Picard moves with a speed of 0.90c relative to the La Forge. A person on the La Forge measures...
-
Tina, a manager in a department with high turnover, must hire a new employee. Using the determine if the decision-making model or decision rules or policies and procedures should be used to make the...
-
The Nielsen family formed their corporation, N. Robert Nielsen, Inc., to conduct farming operations. Morre, Grider & Co. is a certified public accounting firm that has provided accounting, tax, and...
-
Zekany Corporation would have had identical income before taxes on both its income tax returns and income statements for the years 2011 through 2014 except for differences in depreciation on an...
-
3. A region has the peak-period electricity demand in MWh given by D(r) = { 40,008 rif r 64 104,000 1,000r if r64 6 Exercises for Markets Module by Metin akanyldrm where r is the wholesale price in...
-
(1) Implement, in a computer language of your choice, the method of local search for solving the following instance of the knapsack problem. Maximisez = 881 +1182 +983 +1284 + 1485 + 10s6+687 +788...
-
Illustrate the Distinctive characteristics of services (customer participation, simultaneity, perishability, intangibility, heterogeneity) for the United States Postal Service Operation.
-
How can communication barriers in health care teams, such as hierarchy, status, and other factors, be addressed in hospitals and other healthcare organizations? How can communication experts persuade...
-
Which of the following items affects the charitable deduction of an estate or complex trust? a. Rental income b. Dividends c. Interest d. Tax-exempt interest
-
Depression can be considered as a set of symptoms or as an interpersonal/ relational concern. What issues arise from considering depression from each perspective? Are there similarities and...
-
Describe fully how the Variance Inflation Factor for a variable can be determined.
-
Suppose I am obligated to buy a house from Mark in a year. I consider the obligation similar to a forward contract. The fair value of the house is $1 million today Assume that today is April 30,...
-
Suppose that a business sells 6-month subscriptions to its monthly magazine. On January 1, the company receives a total of $600 for 10 subscriptions. To record this transaction, the company debits...
-
Answer the following questions: 1. Describe how a typical lock manager is implemented. Why must lock and unlock be atomic operations? What is the difference between a lock and a latch? What are...
-
Notown Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database...
-
Explain the following terms briefly: attribute, domain, entity, relationship, entity set, relationship set, one-to-many relationship, many-to-many relationship, participation constraint, overlap...
-
Santinis new contract for 2019 indicates the following compensation and benefits: Santini is 54 years old at the end of 2019. He is single and has no dependents. Assume that the employer matches $1...
-
In 2019, Nina contributes 10 percent of her $100,000 annual salary to her 401(k) account. She expects to earn a 7 percent before-tax rate of return. Assuming she leaves this (and any employer...
-
In 2019, Nitai (age 40) contributes 10 percent of his $100,000 annual salary to a Roth 401(k) account sponsored by his employer, AY Inc. AY Inc. matches employee contributions to the employees...
Study smarter with the SolutionInn App