For this activity, you will analyze a provided scenario that outlines the business requirements and needs for a new database. As part of the process, you will use a color-coding technique to identify the various entities and related attributes required to process the scenario.

As a first step to completing this activity, watch this video: Entity Relationship Modeling (8:04).

Next, follow these instructions: Review the scenario below to determine the correct color coding for the entities and attributes in the narrative.

Copy and paste the scenario text into a Word document.

As you find entities and their related attributes in the narrative, change the font color for any words that are related to that entity so that they are a matching color.

For instance, in the narrative, if you have a customer entity with customer details such as name and address, all of the words related to that entity and its attributes could be colored blue. Another entitys attributes could all be colored green.

At the bottom of the narrative, create a list of each entity, its attributes, and the color used to distinguish this entity.

Once you are satisfied with your color-coding choices, post your proposed color-coded narrative and related tables to the discussion topic as a Word document.

In your initial post, describe how you identified the entities and attributes, and explain your point of view.

Review the proposals of other classmates and discuss their selection of attributes and related color coding. Be sure to support one another by making suggestions for corrections or revisions based on what you have learned.

Scenario The student activities department at SNHU would like to begin tracking students participation in various clubs on campus to identify the most heavily used clubs. Each students ID number uniquely identifies a student. For each student, the department would also like to know the students name, year in school, and which club they joined. Of course, there are many clubs on campus, but each club will have a club ID, an advisor, and the club name. Each advisor is identified by an advisor ID and the advisors first and last name. Since a student may be in many clubs, the student-to-club relationship is many-to-many. Use a bridge table to link the relationship between these two tables.

Important: Even though only two responses are required, you are encouraged to provide more responses and to watch for peers who may have not received a response.