Compatibility issues of merging the sales order data

Assignment Help Marketing Management

Reference no: EM13723272

BMW Bikeworks is the manufacturer of parts for BMW motorcycles. BMW Bikeworks recently purchased a small competitor. You are the project manager responsible for integrating the systems of these two companies. In this exercise, you will explore some of the data compatibility issues of merging the sales order data.

A. Using MS Excel, import the orderRecords data from the order1.accdb database. Import all of the rows and columns from this table. Rename the sheet to "orders1".

B. Using MS Excel, import the orderRecords data from the order2.accdb database. Import all of the rows and columns from this table. Rename the sheet to "orders2".

There are several data compatibility issues that may arise when BMW Bikeworks is merging the data from these two sources. Assume that ORDER1 is the BMW Bikeworks database and the ORDER2 data needs to be properly merged with ORDER1.

A. In MS Word, prepare a document that lists all of the data issues that you foresee concerning this project. Some of the issues are obvious; others take more analysis. List any and all of the issues you can determine.

B. Based on the list that you created above, address each of the issues and give your suggestions for resolving them.

Reference no: EM13723272

Questions Cloud

What is the internal rate of return irr : What is the net present value NPV, internal rate of return IRR, payback period PBP, discounted payback period DPBP, and profitability index PI of the proposed project?

Case study on paper2go : Calculate the financial impact of increasing order fill rates to 98 percent from 92 percent. Develop a strategic profit model of both the old system and the modified system that reflects the suggested adjustments.

What developments were swirling around the author : What events/developments were swirling around the author at the time the document was produced? Identify the basic features of the document.

How to provide effective help to end-users facing problems : ne of the most critical problems faced by the information technology department in virtually every organization is how to provide effective help to end-users facing problems with the technology

Compatibility issues of merging the sales order data : BMW Bikeworks is the manufacturer of parts for BMW motorcycles. BMW Bikeworks recently purchased a small competitor. In this exercise, you will explore some of the data compatibility issues of merging the sales order data

What is the sigificance of luis valdez in chicano theater : what is the sigificance of Luis Valdez in chicano theater? why do you believe chicano social issues are often presented in chicano artistic expression?

Concepts of the object-oriented programming paradigm : Review structured programming concepts - Describe the main concepts of the object-oriented programming paradigm.

What are the strengths and weaknesses of the rbs brand : What are the strengths and weaknesses of the RBS brand, Past Promotional Events: Analyze the effectiveness of past RBS consumer and trade promotions

Differentiate between ec and e-business : The Critical Analysis questions are designed to help you gain a deeper understanding of the subject matter, develop an increased ability to apply what you have learned and integrate this knowledge into a greater understanding and appreciation for ..

User Account

All Pages