Prompt: For this activity, you will analyze a provided scenario that outlines th
ID: 3755866 • Letter: P
Question
Prompt: 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.
Next, follow these instructions:
1. Review the scenario below to determine the correct color coding for the entities and attributes in thenarrative.
2. Copy and paste the scenario text into a Word document.
3. 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 entity’s attributes could all be colored green.
4. At the bottom of the narrative, create a list of each entity, its attributes, and the color used to distinguish this entity.
5. Once you are satisfied with your color-coding choices, post your proposed color-coded narrative and related tables to the group discussion topic as a Word document.
6. In your initial post, describe how you identified the entities and attributes, and explain your point of view.
7. Review the proposals of your group members 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 would like to begin tracking students’ participation in various clubs on campus to identify the most heavily used clubs. Each student’s ID number uniquely identifies a student. For each student, the department would also like to know the student’s 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 advisor’s 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.
Explanation / Answer
There are three entities in this scenario namely the Student,the Club and the Club Advisor.
The color coding chosen is done as students -Blue,clubs-red,clubadvisor-green. These three colors are being chosen to distinguish each entity easily.
Scenario
The student activities department would like to begin tracking students’ participation in various clubs on campus to identify the most heavily used clubs. Each student’s ID number uniquely identifies a student. For each student, the department would also like to know the student’s 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 advisor’s 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.
Entity
Attributes
Color
Student
Student ID number
Blue
Student Name
Year in school
Club they joined
Club
Club ID
Red
Club Name
Club Advisor
Advisor
ID
Green
Advisor First name
Advisor Last Name
Student
Student ID number
Name
Year in school
Club they joined
Student_Club
Student ID number
Club ID
Club
Club ID
Name
Advisor
Entity
Attributes
Color
Student
Student ID number
Blue
Student Name
Year in school
Club they joined
Club
Club ID
Red
Club Name
Club Advisor
Advisor
ID
Green
Advisor First name
Advisor Last Name
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.