Denise2020
Member
- Local time
- Today, 15:04
- Joined
- Mar 31, 2020
- Messages
- 82
Hi everyone, I am a complete newbie who had to create a database for work. I am wondering how to deal with this issue and keep changing my mind on the right way to deal with it. My problem is that it is a database which documents physical files in an archive. Each file has one object, but each object can have many, many names, as well as abbreviations, and all must be searchable. My question is how do I properly (thinking of the rules of normalisation) document all alternative names and abbreviations for each object. Right now, my very clumsy solution has been to have Object Name (Alternative name, alternative name, alternative name, abbreviations, etc) in the Object name field, just so that it is searchable. Is there a more elegant solution to this problem?
I haven't given much information about the database here, not really knowing how much detail you need. I am happy to provide more information I am able if you need it to help with my problem. Thanks in advance!
I haven't given much information about the database here, not really knowing how much detail you need. I am happy to provide more information I am able if you need it to help with my problem. Thanks in advance!