I'm currently working on my first DB!!! I can't get my head around one scenario.
I'm trying to track the equipment we sell and install on boats. Each boat has a shipID primary key and a Name as well as some other attributes. The problem I have is the "name" may change over time, so I've thought about adding another column as "exname"; so when the name changes I just update with new name an move original name to exname!
But.... Often a boat could have 3 4 5 exnames over time and this would break the "normal form" rules I've been reading about.
I need to be able to query a "name" and return shipID's for both current and exnames!
Also multiple shipID's could have the same "name"
Thank you in advance for any advice.