In this assignment, you will create a database for Fiji’s Ministry of Health to help the ministry manage data about distribution of supplies that is drugs and equipment, to the health centers and major hospitals around Fiji.
others
Description
Assessment Overview
In this assignment, you will create a database for Fiji’s Ministry of Health to help the ministry manage data about distribution of supplies that is drugs and equipment, to the health centers and major hospitals around Fiji.
Your database will store information about each item (drug or equipment) provided by the health
department - including its name, supplier, price, the number of units currently available at the
Government Pharmacy in Suva, and the number of units on order. For drugs, your system will store
information about dosages and side effects. Doctors and nurses will use your database to get
information about supplies and check on their availability.
Your database will maintain information about the quantities of specific items shipped to health
centers and major hospitals throughout Fiji. The main supply is in the Government Pharmacy in Suva.
Distribution clerks will use your database to record when supplies arrive at the main pharmacy. They
will also enter data about weekly shipments to hospitals and health centers. This means that your
database should store information about the items distributed to the hospitals and health centers
from the Government Pharmacy.
Every week, the Chief Pharmacist will request the database for a report of distribution of supplies to
each hospital and health center. Every month the database should generate a report on the amount
of supplies currently available.
What you need to do
_________________________________________________________________________________
As part of this assignment, you will create a Database Design Report, MS Visio file, and a MS Access
database. Only the MS Access database and the Database Design Report will be uploaded on Moodle
