Thread: Inventory Database
03-31-13, 04:41 #1Registered User
- Join Date
- Mar 2013
Unanswered: Inventory Database
Iam trying to do an inventory DB for a government ministry to track all their drug & equipment distributions to various health centers around the country, trouble is i dont know what should be written down as the entities and their attributes.
Its like this:
Page 2 of 4
Scenario: Inventory Database
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 centres 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 centres
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 centres. This means that your database
should store information about the items distributed to the hospitals and health centres from the
Every week, the Chief Pharmacist will request the database for a report of distribution of supplies to
each hospital and health centre. Every month the database should generate a report on the amount of
supplies currently available.
A database designer has started the design process and the following business rules have been
identified by the designer:
1. Each item (drug or equipment) is supplied by exactly one supplier, but each supplier can
supply no or many items.
2. Each item has one or many invoices (purchases), and each invoice can list one or many
3. Each item has one or many shipments (distributions), and each shipment can contain
one or many items.
4. Each shipment is sent to exactly one health centre or hospital, but each health centre or
hospital can receive one or many shipments.
You are free to use these business rules or design your own. You will need to identify additional
business rules for the case study.
thanks for any kind of helphttp://www.dbforums.com/db_images_v3/images/smilies/confused.gif
03-31-13, 05:33 #2Moderator
Provided Answers: 14
- Join Date
- Mar 2009
It looks like a homework to me.Have a nice day!
03-31-13, 17:27 #3Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
Do you reckon?
Linq ;0)>Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007