blacksaibot
Registered User.
- Local time
- Today, 10:38
- Joined
- Jan 20, 2010
- Messages
- 31
I need help putting this into technical terminology:
Our database "admin team" designed database to house survey questions. The problem is they gave every single question its own column and every single answer its own column. Essential an entire survey for one person is stored in a single data row.
I've seen survey databases before and each row represents a question and its response. I remember learning its better to have many rows rather than too many columns. I also know that the way they set this up is bad database design practice, but I don't know the technical terminology to describe this.
Can anyone help me out? Thanks
Our database "admin team" designed database to house survey questions. The problem is they gave every single question its own column and every single answer its own column. Essential an entire survey for one person is stored in a single data row.
I've seen survey databases before and each row represents a question and its response. I remember learning its better to have many rows rather than too many columns. I also know that the way they set this up is bad database design practice, but I don't know the technical terminology to describe this.
Can anyone help me out? Thanks