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.

Question: I have a legacy system with users and files, the info of all files pertaining to a user are stored on a flat file.

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.

Define the desgin consideration and develop a prototype.

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.

@Tim C, I did show the interviewee the file:

User1234.txt
UserID=1234
ParentPath=\\somewhere\nowehere\everywhere\1234
FileCount=20
File0=something0.ext
..
File19=something19.ext

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