Database Answers Printer Cartridge and Pyramid

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Tracking Printer Cartridges 

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
About Us Contact Us