Hi;
I am still working on my military database and would like some idea if this the correct (best) way of doing this. (don't have a clue what to call this)
For every chunk of data, I want to record where I found it. This can help find more pieces or figure out who is hedging. I’m not sure that I have all the fields or to many, but this is my position now. So the table are:
Remember that tblChanges got deleted last thread, so now need some method of linking lots of tables to this one. (haven’t really though it out yet).
tblRefSources RefSourceID ChangeFK SourceFK tblSources SourceID SiteFK BookFK Page/Locator 123 3 49 124 2 3rd Section OOB tblSites SiteID URL tblBooks BookID Title Author1 1stprinted Printed Version Printer Located Volume ISBN Language CallNumber URL
The questions are
- Is tblSources correctly setup?
- Should the Table include a rule that one (Site or Book) MUST be NULL?
- In tblSites and tblBooks any extra fields or missings?
- Is the normalization done reasonable?
Thanks for read and thinking about this: