I'm trying to decide if I should use multiple simpler tables in my data base, or combine those tables were possible into a single table. This either way better from a database design point? As an example, my work conducts test events. Each Test Event has a unique name and a set of unique Scenarios. These Scenarios have their own unique Parameters.
Should I create one table called Eventsand put every Test Event and Scenario with their Parameters in it, each as a field in that table? Or should create one table to contain all of the event names and another to contain the scenarios and their parameters?
Eventually employees will be running these test multiple times and I want to capture the data from each "run" and manipulate it.
Thanks in advance for your time and help,
Keith