I need help on this newbie things.
I know how to build a database when you need lot of rows. (Eg. Movies. You will have tons of rows with different moves. So, you create these columns: Movie name, Director name, Rating, etc).
BUT, when in you app you need for like Data with only one row, how is the best approach to build the database?
The idea is I will create a page to input those app default values, and changes time to time. After that call it on different forecast scenarios when input fields has as Initial Value, the value inserted on that table.
Example, I need a central database with options, usually numbers: “Email revenue per year”, “% of unsubscribes”, etc
- Do you create the database named “Values”:
Field 1: “Email revenue per year” (type number)
Field 2: “% of unsubscribers” (type number)
Field 3: “Email % open rate”
Field 1: “Name of the value” (text)
Field 2: “Value number” (Number)
… and I create each row with the name of the option I need and his value.
What of both is the well done or better approach?
Thanks in advance"