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