Visit to the nearest chemist shop and collect the information about how they keep the track of all the medicines available in the store, their prices, name, batch number, manufacturing date, expiry date, company supplier, discount etc., and after collecting all these details, design a computerized database solution using MS-Access RDBMS and store at least 10 records in the database using the actual figures collected from the shop.
Answers
Answer:
How to get the information?
Once you go to this online pharmacy website mentioned above, it is easy to navigate through the site to search for the drug information. The following steps will get you the required information mentioned above.
1. Go to the home page/drug page of the above website
2. Look for “Rapid search by brand name”
3. Enter the brand name in the search box, then click on ‘submit’
4. You will get full details of the drug mentioned by you. Then you click on the “Active Ingredients (Generic)”
5. There you will get the details of generic name of the constituents of the drug. You then click on the “Matched brands with above constituents”
6. You will then get a full list of all brands of the same medicine with full details as mentioned in the above example.
Explanation: