Is this data normalised?

[Lol999]

Hi, I'm trying to create a tool logging database where tools are logged out from and to stores to different locations. I would be looking to enable new tools to be entered in the system, tools to be booked out and reports generated.
I've attached the problem child for your consideration.

Thanks, Lol

 

[Ranman256]

i would put [ID_Location] on the tblProduct.
and fill that too when the tool is checked out.

if null the tool is back home on the shelf.
otherwise its in the tblLocation.ID_location

 

[plog]

Looks good. 2 questions related to the same thing:

1. Can a product be decommissioned and active?
2. Can a product not be decommissioned and not active?

Without understanding your data, it would seem that those things are essentially the same data.

 

[Lol999]

Hi Pat and everyone:

Yes I realise on re-examination my fields are lacking in some areas and duplicated in others so I need to look at that.
Unfortunately I am having to work in the evenings due to family pressures and to be honest I am often on the brink of exhaustion and not thinking clearly.
Pat: i considered a table for Location type but was planning on just entering the values in a combo box manually.
However, assuming I needed just one table would there be any need to link it to the rest? Surely a "stand alone" would do the job?

 

[Mark_]

Something to think through...
You have a "Date_Loaned". This doesn't seem to be the right term for what it is used for. "Dt_Transferred" would be more appropriate if you are using it to track From Store -> To van -> To site -> Back to van -> Back to stores. I would also use it as an actual date/time field rather than just date. This will help with "reasonable" questions that come up, such as "Is it reasonable that it takes 4 hours for them to get a shovel from here (store) down the street?" Depending on how granular you wish to be with process tracking you may want to also add Dt_Input to track when the transfer was recorded.

P.S. I use Dt in field names if I store both Date and time.

 

[Lol999]

Thanks for the advice everyone much appreciated.
I've been going through the tables and fields and still need to refine them slightly.
I've done away with the three-way primary key in Tbl_Current_Location and changed them to indexes instead.
Two things are certain:
1) I'll keep plodding on until it is finished
2) I'll be back for more help to understand.

Once again, may thanks.