Basically, we want many URLs. associated with many UserIDs. At the point that 4NF is achieved, the url_relations table holds unique relationships between users and their URLs.
Q: Is this a flawed design, since the database can become overwhelming when holding so many unique relationships between users and their URLs? Imagine if you have 100 users, each associated with 50 different URLID's. It's my understanding that this can lead to 5000 rows.
What is the best way to deal with this kind of situation?
Thanks in advance for your time and help. If my situation hasn't been explained well enough, I'll be happy to elaborate.