Forums

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?

#141231
__
Participant

>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


@jurotek
, note that we discussed this earlier:

>will every URL+title combination be unique?
–@traq

.
>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.
–@ChrisBurton

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.