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
-
1. Radiative forcing of greenhouse gases (20 points) The radiative forcings AFCH4 and AFN20, in W/m, caused by changes in the atmospheric concentrations of methane and nitrous oxide are sometimes...
-
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.
-
Y takes on the value 2 with probability 1. Show that this is the case with a = 0 as in Theorem 7.3. What happens when you try to compute the correlation? Explain why (think of correlation as...
-
A process involving an ideal gas is carried out in which the temperature changes at constant volume. For a fixed value of T, the mass of the gas is doubled. The process is repeated with the same...
-
(Adjusting prices to splits) Here are the stock price and split data for HeavySteel corporation. a. Calculate the split-adjusted returns for each year and its statistics (mean and standard...
-
Transferred-in costs, FIFO method (continuation of 17-33). Refer to the information in Problem 17-33. Suppose that Larsen Company uses the FIFO method instead of the weighted-average method in all of...
-
Lei Corporation's bonds have a 30-year maturity, a 10% semiannual coupon ($50 coupon payments are made every six months), a face value of $1,000, and cannot be called. The going nominal annual...
-
Photo Tonight, a film-developing and camera-repair franchise, began business on January 1, 20X1. In the process of beginning operations, it incurred the following capital expenditures: Developing...
-
Utah Company currently produces a component that it uses in making some of its products. Utah has calculated the following costs for making the component: Unit-level costs Materials Labor Overhead...
-
Currently a mutual fund has a NAV of $ 6 7 . 8 0 and a market price of $ 6 5 . 2 4 what is the percentage premium or discount af which the fund is trading?
-
Mercury Ltd has developed a new product the" Mexta" details of product specifications and the planned level of activity for their first month of production are as follows Planned Production 1,800...
-
Amman Company has three production lines, Production Line 1, Production Line 2 and Production Line 3. The management of the company has decided to close Production Line 3 from company's operations...
-
Your company currently spends $10,000.00 per year to rent a light commercial shop facility. This cost inflates by 2% per year. For a nominal return rate of 6%, what is the real present value of the...
-
Evaluate the integral. 49e-7 7x sin 7x dx -7x 49e sin 7x dx =
-
Georgia Corporation's balance sheet and income statement appear below: Comparative Balance Sheet Ending Beginning Balance Balance Assets: Cash and cash equivalents $ 40 $ 30 Accounts receivable 57 53...
-
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...
-
Research evidence suggests that, in practice, a cost-plus approach influences many pricing decisions. Required: What is meant by cost-plus pricing and what are the problems of using this approach? E-1
-
Jerry and Co. is a large computer consultancy business that has a division specialising in robotics. Can you identify three non-financial measures that might be used to help assess the performance of...
-
What are the reasons for holding inventories? Are these reasons different from the rea- sons for holding cash? R-3
Study smarter with the SolutionInn App