Our team, High Five, has built a new and improved database for a small, local pharmacy. The database was built to help improve the filing and dispensing of prescriptions. It will collect patient, doctor, drug, and dispensing information which will then be put together as prescription files. The database will also help keep records of all customer prescription files and exact information pertaining when a prescription was dispensed.
Our project will help the pharmacy keep track of their inventory and know what drugs are most used and which aren't very popular. Knowing this information will prevent the pharmacy from over stocking and will allow them to purchase popular drugs in bulk possibly from different manufacturers in order to save money. Along with saving money, this database will also help increase the quality of the service. The information in our database has specific input masks, unique primary keys, and a specific design in order to prevent entering any irrelevant or wrong data and will help avoid any duplicate information. By decreasing errors with prescriptions and having very exact information about the dispensing of a prescription, the customers will gain trust toward the pharmacists and be much more satisfied with the services. This will help keep the customers with our pharmacy and help us attract new ones.
A very common and dangerous issue that our team focused on improving in our new database is the dispensing of controlled substances in pharmacies. Controlled substances can be very strong and dangerous to people who aren't meant to take them, which is why pharmacies have to be very careful when filling and dispensing such drugs. The new proposed database helps very precisely track exactly who, what day, and at what time picked up a prescription. This information is also linked to all the information about the prescription, including the drug and quantity. This will result in increasing the safety and accuracy of dispensing medications and easily accessing dispensing information if a customer had misplaced their prescription or it was picked up by a different family member previously.
Our proposed database is specifically designed for the use of the pharmacy staff, including the pharmacist, the technician, and the cashier. The system as a whole will help dispense prescriptions more efficiently and safely to help increase business value and increase the trust of current customers, as well as attract new customers.
Our project will help the pharmacy keep track of their inventory and know what drugs are most used and which aren't very popular. Knowing this information will prevent the pharmacy from over stocking and will allow them to purchase popular drugs in bulk possibly from different manufacturers in order to save money. Along with saving money, this database will also help increase the quality of the service. The information in our database has specific input masks, unique primary keys, and a specific design in order to prevent entering any irrelevant or wrong data and will help avoid any duplicate information. By decreasing errors with prescriptions and having very exact information about the dispensing of a prescription, the customers will gain trust toward the pharmacists and be much more satisfied with the services. This will help keep the customers with our pharmacy and help us attract new ones.
A very common and dangerous issue that our team focused on improving in our new database is the dispensing of controlled substances in pharmacies. Controlled substances can be very strong and dangerous to people who aren't meant to take them, which is why pharmacies have to be very careful when filling and dispensing such drugs. The new proposed database helps very precisely track exactly who, what day, and at what time picked up a prescription. This information is also linked to all the information about the prescription, including the drug and quantity. This will result in increasing the safety and accuracy of dispensing medications and easily accessing dispensing information if a customer had misplaced their prescription or it was picked up by a different family member previously.
Our proposed database is specifically designed for the use of the pharmacy staff, including the pharmacist, the technician, and the cashier. The system as a whole will help dispense prescriptions more efficiently and safely to help increase business value and increase the trust of current customers, as well as attract new customers.