Back to the Data Model.
The Area being Modelled is :-
A Database to support the Tracking of Printer Cartridges.
Specifications have been provided by Tatenda in the following terms :-
"Hi
Thanks for your website! I am a beginner at programming.
I work for a school that uses a wide range of printers.
One of our challenges has been to keep track of stock levels and usage rates.
I then decided to design a database in MS Access (I had been using excel spreadsheets)
to keep track of all this info.
I have confused myself a bit and wanted to check with someone who knows what they are
doing to see if what I am doing below is on the right path?
Thanks for your help
Tatenda
My ideas look like this :-
Requests
User Entity
Printer Entity
Technician Entity
Cartridge Entity
Issues
Used By
· Technician name
· User ID
· User Name
· Customer Tel
· User Room
· Cartridge ID
· Cartridge Qty
· Cartridge Name
· Cartridge Type
· Cartridge Qty
· Printer ID
· Printer Name
· Printer Type
· Printer Location
© DataBase Answers Ltd. 2010
|