Preparatory Instructions:

Please be sure to read Chapter 6 – Data Modeling (pp 187 – 213, Systems Analysis & Design text).

Entity Relationship Diagrams (known as ERDs) depict the data that will be used and created in a system and provides business requirements details such as the type and amount of each data element as well as the relationships between data entities.

This week we will practice creating ERDs. You will find that ERDs are very commonly used and can be a critical tool used during requirements analysis and design phases.

Objectives:

This week’s assignment is to apply each Normalization rule to the Inventory Order model to reach the 3rd Normal Form.

The system development team at the Wilcon Company is working on developing a new customer order entry system. In the process of designing the new system, the team has identified the following data entity attributes:

Inventory Order

Order Number (identifier)
Order Date
Customer Name
Street Address
City
State
Zip
Customer Type
Initials
District Number
Region Number
1 to 22 occurrences of:

Item Name
Quantity Ordered
Item Unit
Quantity Shipped
Item Out
Quantity Received
Example:
Entity Relationship Diagram for Music CD Information

Deliverables:
Apply each normalization rule in order (1 to 3) to reach the 3rd Normal form.

Apply first normal form rules and provide result as 1st normal form. Provide a brief description of what was applied to reach 1st normal form as well as the model in 1st normal form.
Apply second normal form rules and provide result as 2nd normal form. Provide a brief description of what was applied to reach 2nd normal form as well as the model in 2nd normal form.
Apply third normal form and provide result as 3rd normal form. Provide a brief description of what was applied to reach 3rd normal form as well as the model in 3rd normal form.
Submit your Entity Relationship Models (1st thru 3rd normal form) as Visio, Word or image files to Canvas

Overcoming Resistance to Change

Change can be difficult, even when it is inevitable. Therefore, change can often be met with resistance initially. Individuals resist change for many reasons, such as fearing the unknown, feeling overwhelmed, or believing a change will not last. However, once the resistance is overcome and a change grows into a habit or new baseline, most individuals will consider the effort worthwhile and may also do what they can to help others surpass the barriers they once faced. In this Discussion, you will consider a time when you resisted change and how you might use that experience to help a team overcome their resistance to changes.

RESOURCES

Be sure to review the Learning Resources before completing this activity.
Click the weekly resources link to access the resources.
WEEKLY RESOURCES
To prepare for this Discussion:
Think about a time when you needed to make a change, whether personal or professional, but were resisting it and what helped you overcome that resistance.
Also consider the role of a leader within an organization in helping individuals and teams overcome resistance to change.
BY DAY 3

Post your explanation of how to overcome resistance to change at the individual and organizational level, to include the following:

Describe a time when you needed to make a change, whether personal or professional, but resisted it.

Analyze what was holding you back initially from making the necessary change and what helped you to overcome your resistance to the change.
Now put yourself in the position of a team leader within an organization. If you were called upon to lead change within your team and you encountered resistance, summarize how you might apply those lessons learned from your own life experience to help that team overcome their resistance to change.

Refer to the Week 5 Discussion Rubric for specific grading elements and criteria. Your Instructor will use this grading rubric to assess your work.
Read some of your colleagues’ postings.

The paper must be typed in 7th edition APA format with a minimum of 1000 words (excluding first and references page) with a minimum of 4 evidence-based references. Make sure references are used according to 7-edition APA guidelines and electronic references must be from reliable sources.

 

After working at your first RN job for 6 months, you are asked to be part of the hiring committee that will interview and hire RNs for two open positions. Having vacancies on your unit means that everyone is working extra shifts and it is important that the positions be filled quickly. There are a dozen applicants. The top six are identified, and interviews are scheduled. There will be four people from the committee at each interview.

Interviews go well and the committee has determined the top two candidates who are equally qualified. When discussing the two candidates, at a meeting of the hiring committee, your supervisor feels that you should not hire one of the candidates because she alluded to the fact that she has diabetes and people with diabetes get sick a lot. She feels the candidate will be unreliable and unable to do her share of the work on the unit.

QUESTIONS:

1.How do you feel about your supervisor’s suggestion?
2.What are the ethical implications?
3.Are there any legal implications?
4.What are your personal feelings?
5.Do you agree with your supervisor?
The top two candidates accepted the positions offered them and were hired immediately. Both were a good fit for the unit, and after orientation was complete, they were able to reduce the strain the staff was feeling from the extra shifts. One of the new employees was diabetic and had been since she was 11 years old. She was very knowledgeable and had very good control of her diabetes. She became a resource for the entire unit related to diabetes education and care. The other new employee had relocated to take this position. Her personal situation was very complicated, and she was often late to work or would have multiple personal phone calls during the shift. She was a good nurse but had difficulty focusing on her job when things in her personal life seemed to be out of control. Within 6 months, she quit and moved back to the town from which she had relocated.

QUESTIONS:

1. In this situation, the nurse with diabetes was managing her disease well. If that were not the case what could the nursing supervisor do to work with the nurse to help her be successful in her new position?
2. Personal bias could have prevented the hiring of a nurse that turned out to be an asset to the unit. What personal biases do you have that may prevent you from interacting fairly with patients or coworkers?
3. How can you minimize the impact of these biases?

Should healthcare be considered a human right?

 

Discussion Thread: What is a Militia? The Second Amendment specifically mentions a “well regulated militia,” which has led some to claim that this Amendment protects the Rights of the military or a state’s National Guard to possess firearms. Explain the meaning of a militia in the context of the Founders’ time period and whether or not that definition has a modern comparison. Discuss the protection of Rights in the Bill of Rights, as they relate to individuals or groups.