Rasmussen College Entity Relationship Model Assignment
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 (attached). 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.
- Your paper should be a minimum of 3 full pages in length.
- You will need to include a minimum of 2 credible sources for your research, with 1 being an academic source, such as a book or an academic scholarly journal. Academic scholarly journals can be accessed through the Rasmussen Online Library. For business sources, ProQuest and EBSCO Host are helpful.
- Include an APA formatted title page and reference page.