How do you handle collection and storage of new data in an existing system? : <p>I am new to system design and have been asked to solve a problem.</p>

<p>Given a car rental service website, I need to work on a new feature.</p>

<p>The company has come up with some more data that they would like to capture and analyze along with the data that they already have.</p>

<p>This new data can be something like time and cost to assemble a car. </p>

<p>I need to understand the following:</p>

<p>1: How should I approach the problem, from API design perspective?</p>

<p>2: Is changing the schema of your tables going to do any good, if that is an option?</p>

<p>3: Which databases can be used?</p>

<p>The values once stored can be changed. For example, the time to assemble can reduce or increase, hence the users should be able to update the values.</p>
