Database Design Discussion Assignment: Entities and Attributes, Part 1

Content Type

User Generated

User

ZbqreaXengbf

Subject

Computer Science

Description

Hello

I need help with a discussion assignments for my database design course, here's the instructions and scenario provided:

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 entity’s 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 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.

Please review guidelines and rubric document for more details. Thank you

Unformatted Attachment Preview

IT 235 Module Four Small Group Discussion Guidelines and Rubric Entities and Attributes, Part 1 Overview: In this discussion, you will be assigned to a small group, although you will be working independently. The small group setup is designed to give you a more focused discussion, extra practice, and quicker feedback early in the week. Important: Although you will be working in a group, you will be graded on an individual basis. Also note that you will need to post first before you can see the posts of your classmates. This activity will provide you with a practice and feedback opportunity. It will also prepare you for the follow-up assignment in this module (Activity: Entities and Attributes, Part 2). Ultimately, this activity will ensure that you will be able to implement the ERD for the final project. You are required to post one initial post and to follow up with at least two of the members of your group. For your initial post, keep the following in mind:   Compose your initial post by Thursday at 11:59 p.m. of your local time zone. Take into consideration material such as course content and discussions from the current module and previous modules, when appropriate. For your response posts, keep the following in mind:    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. Complete your response posts by Sunday at 11:59 p.m. of your local time zone. Demonstrate more depth and thought than simply stating “I agree” or “You are wrong.” Guidance is provided for you in the prompt. 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. As a first step to completing this activity, watch this video: Entity Relationship Modeling (8:04). Next, follow these instructions: 1. Review the scenario below to determine the correct color coding for the entities and attributes in the narrative. 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 forum 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 at SNHU 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. Rubric Critical Elements Initial Post: Comprehension of Scenario Color Coding and Table/Legend Proficient (100%) Needs Improvement (55%) Not Evident (0%) Value Describes how entities and attributes were selected Describes how entities and attributes were selected, but description lacks clarity or is not supported Does not describe how entities and attributes were selected 50 Table/legend is presented with evidence and clarity Table/legend is presented but may include gaps or is unclear Does not support initial post with evidence 25 Response/Participation Provides at least two thoughtful responses to peers that promote continuous conversation Provides at least two responses, but responses do not promote continued conversation Does not provide at least two responses 25 Total 100%
Purchase answer to see full attachment

Tags: discussion post database design