For my major project i'm going to create a database driven website and the relational database design need to be normalised to 3rd normal form. I can see myself having over 20 database tables.
I can also see that in the web application i'm going to need to return data from more than one table.
To do this i can use join's and join on the primary key's. However this means my query string are going to be huge!
Is there a better method of doing this?