Question: 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.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

festuskieru festuskieru festuskieru festuskieru festuskieru can you help with this question,......i will pay you more if you can help with this in parts............ Excel Project 3 - MS Excel Use the...

Need a help. I calculated the npv of both options that BTWpls useall the information provided in order to make the correct decision in regards to which DCF method to use.thx a lot Analysis of...

Case Study Duralock: Budgeting for Decision-Making BACKGROUND Lockitt, Inc., a small manufacturing company, produces a specialized sealant lock for hazardous chemical containers. It was founded by an...

Hi I need help with this excel assignment. The yellow cells are what I'm supposed to fill in to finish this assignment. I have to input formulas not just numbers. So please don't just put a number...

Using the case study below: Memo to the Project Sponsor. In the memo, outline the following: a. Recommendations for managing the project - should leverage the scope management plan and scope...

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published...

Can you please provide project activities list, dependencies and durations for the case study below. Thank you! PROJ6002 Case Study Property Condition Program Background The State Government...

please help with this Project 3 - Gantt Chart Due Feb 14 by 11:59pm Points 100 Submitting a file upload Please download the Word and Excel files and use them to create a Gantt Chart. Then, use those...

1 10 points 2011235 eBook Question 1-ch 3 HW- Intro to CVP-Connect Break-even point in units Break-even point in dollars Pearson Check m Campbell Corporation sells products for $32 each that have...

Heavenly Cookie Company has the following annual sales and costs for its current product line: Heavenly is thinking of adding Mississippi Mud brownies to the product line. The ultra-rich brownies...

Hello, please help me solve this problem! Prove that i = 1 n i 2 l n ( e + 1 i ) = ( n 3 )

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

How can the use of social media such as Facebook and Twitter-like applications benefit the performance management process?

According to Hofstede (in Table 15.2), the United States is low on power distance, high on individuality, high on masculinity, low on uncertainty avoidance, and low on long-term orientation. Russia,...

What do you think is the most important step shown in the model of the effective performance management process? Justify your answer.