Originally Posted by
jzwp11
I see you had separate tables for startup, shutdown and verify procedures. The rule is that like data should be in 1 table. Since the are all procedures just of different types, we can put them in a table and we would add a field to distinguish each by type. I have done the consolidation in the attached DB for you. Thank you Very Much, that is above and beyond. I also replaced the 3 linking tables to the LOTO with 1 linking table between LOTO and procedures (tblLOTOProcedures). I included a sequence number (longSeqNo) field in that table so as to preserve the order of the procedures in each procedure type group.
As to whether the table structure is complete, let me ask a couple questions.
In the LOTO table, you have a field called panellocation. I see a lot of repeated location names. You could dump the names into a table and then reference a foreign key in the LOTO table. This will save you the trouble of having to type the location each time. Also, the breakerNo field has multiple values, that would suggest that you have a one-to-many relationship between the panel of the LOTO and the breakers, so technically each breaker should be a record in a related table. Now that might be taking normalization a little far, so I will leave that part to you. I think that I would be just a little bit of over kill, I have considered it in order to save the location of the panels with the Panel number however. Does/will a piece of equipment have only one panel? Yes they will only have one panel. I have a small format change that I need to make here. My facility does not have a central Buss Power system, we have a system of Panel Boards similar to what you would have in your home. the Power is sourced from an individual Panel Board to the machine, I have a separate Disconnect Switch at most of the Machines, Some will have to have the Power Isolated at the Originating Panel Board and then some will also Be connected by Cord and Plug so this type of Equipment will not have a Panel or a disconnect. g
I assume that you will be removing the ElectrialEnergyControlMeans field since you now reference the same info via the fkElectCntrlID field, correct? Yes that will now be removed
BTW, I took a quick look at your report and I think you will be able to come up with something similar although not exact. You still have a few table structure issues to decide on as indicated above.