Please do the task analysis and DB structure for the following requirement.

1. Need to upload data from excel to database in the DB 2. In the excel file there can be 10000 to 1 lakh records and records should be uploaded 3. Need to generate success file and error file to know how many records are processed and many are error

Product ------- product will have the following attributes

1. Product Name (Unique) 2. Product Code (Unique) 3. Category 4. Subcategory 5. Subservice 6. Price 7. Product Date 8. Sizes (comma seperator)

Output ------

1. Tasks preparation 2. DB Design 3. Which architecture we have to follow like BAL,WCF,WEB API 4. Flow document preparation 5. Validations 6. Technical implementation 7. Application should be implemented