database design discussion assignment entities and attributes part 1

Get perfect grades by consistently using www.assignmentgeeks.org. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

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:

  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 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 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

"Is this question part of your assignment? We can help"

ORDER NOW
Writerbay.net

Need help with an assignment? We work for the best interests of our clients. We maintain professionalism and offer brilliant writing services in most of the fields ranging from nursing, philosophy, psychology, biology, finance, accounting, criminal justice, mathematics, computer science, among others. We offer CONFIDENTIAL, ORIGINAL (Turnitin & SafeAssign checks), and PRIVATE services using the latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and doctorate-prepared writers. Thank you in advance!

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper