| That doesn't work.
How do you determined which ad displayed for which keyword? With your design, you could not determine the keyword id related to each log entry. The only logical relationship is log1 -> companyID, which is useless. You need to reference Log 1 to Company ID and Keyword ID. In this instance, keyword ID could be any of over 1,000,000 entries.
Yes it allows you to reference keywordID faster, but it completely limQits the other uses of the database. |