Is this better?

[hrenee]

Here's what I was originally given



And this is what I came up with today




I know that the Manufacturer Table could have more but frankly we don't need it in this DB and I can always add it if necessary later. Does it look like I've missed something major? I have indexed the Natural Keys to all the PK, hope that was the correct way to do that. Am I missing anything major? Stupid flaw somewhere?

[June7]

A circular relationship is indication of problems.

The second ERD is looking better.

I am not sure about tblMaintenance. What is it for?

[hrenee]

Because this place is run weird! Unfortunately nobody has normalized the assets for the business, and Maintenance has their own number for every piece of equipment. Frankly they have the best list, but nobody up high listens to them, so rather than making their list the primary list (like I would like to do) all I can do is tag it on the asset. The reason it's important is because maintenance has actually tagged the assets with their numbers. So when you are standing in the plant that Maintenance ID will be on the equipment. Making it easier for us bean counters to know exactly what the equipment is. I may not know what a chocolate enrober looks like, but if I have that Maintenance ID I can look it up and find out what the equipment is, and what it does.

[June7]

Okay, that makes sense. It's not tracking maintenance records in this db.

Think you are on better track with the revision.

[hrenee]

No just the random number they have assigned each piece of equipment.