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