Newbie working on the DB design

Discussion created by footie11 on Apr 2, 2013
Latest reply on Apr 2, 2013 by gcatnine

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.