What takes more space? (1 Viewer)

[littlegod]

Hi everybody,

Amongst many other things i would like to be able to see which teams in our company have access to which database. We currently use up to seven!!! different Databases which makes for tremendous fun...just kidding.

Since every Team has access to more than one Database andevery Database obviously gets used by a multitude of Teams, i thought the best way to go would be a Junction Table. Whilst building this, however, it occured to me that i could have just created fields for each Database in the Team Table which then can be ticked.

So here's my question, is it more space consuming to create a junction table, it certainly appears to be more work right now...

Thank you very much,

Dan

 

[Pat Hartman]

It isn't a question of space. It is a question of proper design. Proper design will ALWAYS be easier to work with in the long run even if it seems to be more difficult to get going. So - build the junction table, don't devolve to a spreadsheet representation.

 

[littlegod]

Thank you, Pat,

Had a feeling that this would be the answer.

Thanks for taking the time to answer.

Dan