The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Other How to setup a database table? Re: How to setup a database table?


>Your table violates 2 NF and that is all about redundancy. If you read and want to record more than one title(article) which is published under same URL

, note that we discussed this earlier:

>will every URL+title combination be unique?

>Every URL and Title will be unique. The only way that they wouldn’t be is if I read the same article (title) from the same website (url) continuously. But Readability does not allow duplicate articles so that would be impossible.

The table, within the scope of its definition and usage, is perfectly normalized: the title is directly dependent on the url (one-to-one relationship), and no urls or titles will ever be duplicated.