Explain the importance of mapping source and destination fields.

“This week for your course project assignment you will demonstrate your knowledge of the data and the logical relationships of entities that will be used in the database. The dataset you will used for this assignment is the Excel file for Rasmussen Company provided in Module 01. In a minimum of 3 full pages provide a report that includes the following:
Describe how the business requirements can be mapped into data fields in a database.
Explain the importance of mapping source and destination fields.
Review the dataset from the sample file and describe some of the data cleansing that may need to be done.
Discuss the benefit of developing an Entity Relationship model for your project.
Using the Excel file for Rasmussen Company provided in Module 01, create a graphical Entity-Relationship model to show the logical relationships of entities to be used in the database.