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