Unformatted text preview: The Canadian Drugs Database is intended for aiding the users conduct comprehensive research, selection, and prescription of drugs. The users of this database potentially include healthcare professionals and personnel who can use the database to find a specific drug based upon wide selection of criteria (such as active ingredients, drug identification number (DIN), or manufacturing company), or use it as an aid in recommending a specific drug based on information about the drugs usage and side effects. The customers for the database are medical patients and general public who are interested in improving the efficiency of Canadian Health Care sector by means of aiding the professionals access the required information in a quick and reliable manner. The database contains data about the drugs that are currently approved for use by Health Canada and gives up-to-date information regarding their Status, Manufacturer, Active Ingredients, and Usage for drugs. The Drugs table contains general information about all the drugs officially approved by Health Canada such as unique Drug Code, its brand name, drug identification number, class, GP flag, number of active ingredients(AI), AI group number, accession number and last update date of data, and is mainly useful specifically for healthcare professionals for simplifying indexing of all the medications in Canada. It allows to search for a specific drug, delete it, or update information about it. Manufacturer table contains information about companies that manufacture the drugs listed and can also have its data updated. In general, every table provides comprehensive possibilities for research and modification of the listings. Finally, Usage_Notes table can be updated at any point to include more detailed information. ...
View Full Document
- Winter '08
- Pharmacology, Health care provider, Pharmaceutical drug, Health Canada