1. A color-coded Word document with each entity and its related attributes colored in a matching font. For instance, in the narrative, if you have a customer entity with name and address details, each of the words (attributes) related to this entity would all appear in the same colorperhaps blue. Another entity and its related attributes may all be colored red. Your first step will be to copy the scenario to a new Word document. Then you will adjust the font colors for each of the related words. Thus, for this part of the assignment, do the following: a. Copy and paste the scenario text into a Word document. b. Color-code the text of the narrative with each entity properly identified. c. For each entity in the narrative, identify and color-code each attribute with the appropriate color. d. For each entity, identify the primary key and any foreign keys. In a table beneath the scenario (see next step), note PK and FK after each primary key and foreign key, respectively. e. At the bottom of the color-coded narrative, create a table listing each entity by name, listing each entitys attributes, and finally listing the color used to highlight that entity. Include a bridge table, as described in the scenario. 2. A completed Visio entity-relationship diagram (ERD) in crows foot notation. (You may paste a screenshot of the diagram into the Word document created in step 1.) The ERD should use color coding and the entity/attribute list completed in step 1 as the basis for drawing each entity and its related attributes, along with primary and foreign key and relationships. Thus, for this part of the assignment, submit an ERD in which you do the following: a. Include each entity and its related attributes clearly listed on the ERD. b. For each entity, notate the primary key (PK) and any foreign keys (FK). Also identify and draw the relationships between each entity. Scenario

The intramural department at SNHU would like to begin keeping an inventory of students participating on an intramural sports team. Each student has a student ID number, which can be used to uniquely identify a student. For each student, the intramural department would also like to know the students name, age, gender, and which team they joined. There are multiple teams playing various sports; each sport will be assigned a unique sport ID and will include a short description of the sport, such as rugby, soccer, cricket, or basketball. Teams are reorganized and reformed every semester, and each team must come up with its own name. Semesters can be identified by their year and beginning month; thus, fall semester 2017 would be 201708, and winter 2016 would be 201601. Because a student can play on multiple teams, the student-to-team relationship is many-to-many. Please use a bridge table to link the relationship between these two tables.