Interview question - c#
<p>I was tasked to conduct my first interview and would like to pose my question to this world for both their feedback on my question and also on their solutions.</p>

<blockquote>
  <p><strong>Question:</strong>
  I have a legacy system with users and
  files, the info of all files
  pertaining to a user are stored on a
  flat file. </p>
  
  <p>I want to upgrade this system by
  storing all info on a db, design
  tables, and create a C# system that
  will populate the new db as well as
  ftp the files to a new path.</p>
  
  <p>Define the desgin consideration and
  develop a prototype. </p>
  
  <p>Note: We are looking more for what
  design one would use and why rather
  than code that compiles. If it does
  then kudos to you and we will give it
  more weight.</p>
</blockquote>

<p>@Tim C,
I did show the interviewee the file:</p>

<pre><code>User1234.txt
UserID=1234
ParentPath=\\somewhere\nowehere\everywhere\1234
FileCount=20
File0=something0.ext
..
File19=something19.ext
</code></pre>

<p>@Tim C, I have never conducted an interview and I followed a script given to me by my senior developer who was absent.</p>
