Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The pharmacy management system, also known as the pharmacy information system, is a system that stores data and enables functionality that organizes and maintains the

The pharmacy management system, also known as the pharmacy information system, is a system that stores data and enables functionality that organizes and maintains the medication use process within pharmacies. These systems may be an independent technology for the pharmacy's use only, or in a hospital setting, pharmacies may be integrated within an inpatient hospital computer physician order entry system. This software is usually purchased readymade or provided by a medicine wholesaler as part of their service.

Task:

Create an e-medical store software. The store will have an admin site and a seller site. Admin site is for the manager/owner/administrator of the medical store. From the admin site the manager should be able to manage all the tasks of medical store mentioned below. Seller site is for the authentic seller to sell medicines and able to manage tasks mentioned below. Please keep in mind you have to develop all of these modules and all of the mentioned functions in bulleted lists i.e. You have to develop all types of CRUD (Create, Read, Update and Delete) operations of these two modules.

Admin Site

  1. An Admin will have proper Interface to sign in / Sign Out.

  2. An admin can update password and username.

  3. An Admin can add medicines with name, type, description, price, quantity (i.e total no of

    availability), usage, Company name, dose etc.

  4. An Admin can delete Medicine.

  5. An Admin can update Information.

  6. An Admin can Read Medicine information.

  7. An Admin can add seller.

  8. An admin can remove, read, update sellers information.

  9. An admin can check history of total medicines sold on a specific date.

Seller Site.

  1. A seller will have proper interface to Sign In / Sign out.

  2. A Seller can update password and username.

  3. A seller can check quantity/Availability of a medicine.

  4. A seller can also read Proper Detail of a medicine.

  5. A seller can also Search medicine by name.

  6. A seller can sell multiple Medicine to anyone with total bill generated at the end. All

    history will be saved to Database. Medicine Quantity will also affect after selling.

  7. Proper messages should be display to seller if medicine is not Available.

  8. A seller can check all the medicine of a specific company

Database PHP FILE

Database should be stored in a single file, database.php. You will create database variables and import them globally instead of defining variable for database connection repeatedly on every page. During viva database connection variables name and password will be changed and your whole program must run on that system.

Session handling

Every page must have proper session handling, if a person is not registered in session, he/she cannot access their page.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro PowerShell For Database Developers

Authors: Bryan P Cafferky

1st Edition

1484205413, 9781484205419

More Books

Students also viewed these Databases questions