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