![u8p4](/avatars/30736.jpg)
u8p4
10.12.2020 •
Computers and Technology
The Maisha bora Pharmacy have contracted you as a database developer for their integrated stock management systems with those of their suppliers to ensure that every drug has a reorder level upon which the supplier replenishes the stock. They get referrals from hospital for patients to purchase the drugs upon which the pay commissions to the hospital.
They require the following reports per month
1. Commission reports to facilitate payments to hospitals
2. Sales reports
3. Stock level reports
4. Stock profitability reports
5. Stock expiry reports
Required:
a) To identify the data will be necessary and sufficient to provide the above reports.
(10 Marks)
b) Draw the ER diagram (5 Marks)
c) Give a criteria that will assist you in purchasing the DBMS (10 Marks)
Using the scenario in question one how would you undertake the following in MySQL
a) create the Maishabora database (2 Marks)
b) create the tables above (5 Marks)
c) Write a function to increase prices of the items that they sell by 5% (4 Marks)
d) Write a trigger to give an alert when the price of a product or quantity is changed in the database (4 Marks)
e) Identify the risks/threats and mitigation measures if the system is web-based
(10 Marks)
Solved
Show answers
More tips
- S Style and Beauty Why is Sugaring Better than Waxing for Hair Removal?...
- W Work and Career Where can you learn to be a flight attendant?...
- G Goods and services How to Properly Calculate the Power of Your Air Conditioner?...
- F Food and Cooking Effective Methods to Organize Videos in your iPad According to Content...
- F Family and Home Parquet or laminate, which is better?...
- L Leisure and Entertainment How to Properly Wind Fishing Line onto a Reel?...
- L Leisure and Entertainment How to Make a Paper Boat in Simple Steps...
- T Travel and tourism Maldives Adventures: What is the Best Season to Visit the Luxurious Beaches?...
- H Health and Medicine Kinesiology: What is it and How Does it Work?...
- O Other How to Choose the Best Answer to Your Question on The Grand Question ?...
Answers on questions: Computers and Technology
- P Physics The diagram shows a forest food web. which organism is both a secondary and tertiary consumer A.rabbit B.fox C.grasshopper D.shrew...
- B Biology A disease causes a plant to produce big bright flowers that are infertile. overtime the disease affects fewer plants. what likely occurred in this population?...
- E English 1. My uncle Julio ___ be more than 90 years old. 2. But he __ lift more weight than my dad can. 3. He __ try to win a contest. 4. With his muscles, he __ win any contest! 5. If...
Ответ: