Question
Module 05 Content This week for your course project assignment you will demonstrate your knowledge of the data and the logical relationships of entities that
Module 05 Content
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started