Orange and June7 has been helping me w/ my database project. I have several other threads on this so I won't go into much detail.
Unfortunately, its gotten more complicated, again. I've been told that not only do we need to store equipment information and the cabinets / rooms they're assigned to, but we also need to store which cabinets / rooms they've been assigned to in the past.
For an example, SwitchName ABC123 was in storage from 1/12/2014 until 3/09/2014. At which point its second location was BLDG "A", Room "100", Cabinet "." It was installed in that location on 3/09/2014 until it was moved into storage on 9/20/2015 because the user required a larger switch. Switch DEF123 was installed to replace ABC123.
So, I will need to store:
--All Equipment Information
--The building ID, room ID, and cabinet ID which equipment was installed in.
--The date equipment was installed
--The date equipment was uninstalled and reason (Equipment broken and replaced, user required upgrade, user no longer needed service)
--If equipment was replaced by another equipment, need to store which equipment replaced it.
--Allow for user to enter comments.
How exactly would this be done? I'm guessing perhaps a separate table which stores switch information, room information, cabinet information, dates, and comments and have this table automatically populated as data is filled into the other tables and then do not have anything from this table get deleted.
Am I on the right track?