SpentGeezer
Pure Noobism
- Local time
- Tomorrow, 05:31
- Joined
- Sep 16, 2010
- Messages
- 258
Greetings,
I am creating an assets database. Each asset has approx 100 fields, all 1:1. Should I make one table, or try to break it down into several tables linked by Asset ID? There are no 1:M relationships, so there is no real reason to make more than 1 table. Is the massive 100 field table poor design?
Thanks,
Josh
I am creating an assets database. Each asset has approx 100 fields, all 1:1. Should I make one table, or try to break it down into several tables linked by Asset ID? There are no 1:M relationships, so there is no real reason to make more than 1 table. Is the massive 100 field table poor design?
Thanks,
Josh