Normalization help please

[Guest]

I have a DB to create and would like some normalization help.
Tables are as follows:

Devices
Thin Client – (text)
PC – (text)
Printer – (text)
Other – (text)
Description – (text)
Model – (text)

Area
Facility – (text)
Hub – (text)
Location – (text)

Request
MessageID – (number)
MISNumber – (number)
PONumber - (text)
AccountNumber - (number)
ObCode - (number)
AnnRenew – (date)
Date – (date)
Requester – (text)
Vendor (text)


Cost
Quantity – (number)
Cost – (currency)
Unit of measure – (text)
Total – (currency)

There will be two different device reports, one for Thin Clients, and the
additional for all other devices. These reports will vary as to the facility
that has order which device to what devices were ordered by which facility.
All this data is collected via E Mail (message ID is the unique separator)

A third report will be for requisitions that are sent to us. We are
responsible for entering information to be sent onto another area as a
Requisition Form.

Please tell me if this looks good. Thanks in advance.

 

[G. Vaught]

You have Model, does this apply to the PC? Printer? I would clarify.
Also since your table name is Devices, only list Devices. Specifics for each
device would be captured in a different table, such as the Description and
Model fields. The exception to this, is if there is only one PC per
location, but from your statement this is not the case.

Remember, only fields that relate to the subject should be in each table to
ensure atomomy.

Be sure to create Primary Keys and Foreign Key relationships to ensure your
database will be relational when all is said and done.

Table should be normalized to third normal form.

Access has a table analyzer wizard you can run to see if it has issues. You
can accept what it suggest or ignore it. Its worth a look.

 

[Guest]

I was going to use a subform with the PC, printer model.
I will take the description and model fields out. Thanks for you suggestions.