Normalization

 

The table below represents employees working on various contracts.
empID |contractNo | hours|lastName |firstName | state |branchNo
1135 | C1024 | 16 | Smith | John |Illinois| 1
1057 | C1024 | 16 | Smith | Harry |Illinois| 1
1058 | C0006 | 20 | Simpson | Maggie |Illinois| 2
1068 | C1025 | 20 | Adler | Rachel |Maryland| 3
1135 | C1025 | 20 | Smith| John |Maryland| 3
1068 | C5321 | 40 | Adler | Rachel |Maryland| 3
1234 | C6651 | 15 | Potter| Harry |New York| 4
1234 | C5321 | 40 | Potter| Harry |Maryland| 3
_____________________________________________________________________
1. What is the primary key? _____________________________________________________________________
2. Please list all functional dependencies that violate 2NF? _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________
3. Please list all functional dependencies that violate 3NF?
________________________________________________________________________
________________________________________________________________________
________________________________________________________________________
________________________________________________________________________
4. Fix any 2NF violations and draw the new tables you have and their attributes. Fill in the rows. Remember to remove redundant rows. Specify the primary key by underlining the appropriate attribute(s) for each table.

 

 

 

5. Using the latest updated tables, fix any 3NF violations and draw the new tables you have and their attributes. Fill in the rows. Remember to remove redundant rows. Specify the primary key by underlining the appropriate attribute(s) for each table.

 

Sample Solution

ubordinates. It occurs when managers offer promotions to employees who exceed their goal. This leadership style is largely task-focused.
● Servant leadership: in this type of leadership leaders serve by ensuring that there follower’s highest priority needs are fulfilled.
● Authentic leadership: the main emphasis of this type of leadership is the authenticity of the leader.
● Charismatic leadership: it is a type of leadership that comes into play whenever there is a situation of distress, uncertainty or extreme enthusiasm among social relationships.

Difference between Leadership and Management
Generic leadership Generic Management
Leaders create visions for change and movement. Managers anticipate change and adapt to it but they don’t create it.
Leaders frequently seek to influence others Managers pursue order through control of standard operating procedures
Leaders create new pattern of action and belief systems. Managers protect stabilised pattern and beliefs.
Leaders mostly aim to shape ideas instead of responding to them. Managers mostly act to solve problems and limit choices.
Leaders are emotionally active and involved. Managers mostly have low emotional involvement.

Amin(2016) in his written journal of impact of natural born leader qualities on the performance of the project describes that some individuals encapsulates the qualities of being motivational leader naturally by birth. They can be in any situation and emerged as a leader by displaying their certain qualities which surprises everyone around them. There are certain qualities which are developed at their young page itself like awareness, lucidity in communication, direction, initiative and influencing skills by displaying which they are always emerged as Showstopper.

Figure 3: Proposed Model Exhibiting Relationship between Natural Born Leader Qualities and Project Team Performance by Amin (2016)
There are lot of researches done on how gender difference can impact

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.