Question: c ) Explain why the relation EMPLOYEE below does not satisfy 3 N F and decompose it into relations, which do satisfy 3 NF .

c) Explain why the relation EMPLOYEE below does not satisfy 3NF and decompose it into relations, which do satisfy 3NF. What advantages are gained by this decomposition?
EMPLOYEE
\table[[EMP_NO,NAME,ADDRESS,DEPARTMENTS,DEPARTMENT_MANAGER],[E1,Smith,Chez Nous,D1,E1],[E2,Brown,Mon Repose,D1,E1],[E3,Smith,Mon Repose,D1,E1],[E4,Jones,Sea View,D2,E9],[E9,Bloggs,The Nook,D2,E9]]
c) Explain why the relation EMPLOYEE below does not satisfy 3NF

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To determine why the EMPLOYEE relation doesnt satisfy the Third Normal Form 3NF and to decompose it ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

OUESTION 5 a ) Define the following terms: ( i ) Normalization. ( ii ) 2 N F ( iii ) Functional dependency ( i ) Identify and discuss each of the indicated dependencies. ( ii ) Create a database...

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

Q:

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

Q:

Suppose that R(A, B, C) is a relational schema with functional dependencies F = {A, B C, C B}. (i) Is this schema in 3NF? Explain. [2 marks] (ii) Is this schema in BCNF? Explain. [2 marks] (b)...

Q:

Prolog You are approached to compose a Prolog program to work with twofold trees. Your code shouldn't depend on any library predicates and you ought to expect that the mediator is running without...

Q:

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Q:

Give Correct ANSWERS Human-Computer Interaction (a) If you had been one of the original inventors of the WIMP interface, and engineers on the technical team had been sceptical about the advantages...

Q:

s1 educated (SSE) student for every three public school educated (PSE) students. Reasoning that students are not very dissimilar from threads, he suggests the following entry and exit routines be...

Q:

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

Q:

Gamma Distribution is building a new distribution center to supply five of its regional warehouses. These warehouses are located in cities in the eastern portion of the United States, which Gamma has...

Q:

Spreadsheets contain pitfalls for the unwary. (a) If cell A1 contains the value 5, what would you expect the formula = A1^2+A1^2 to give? (b) Using Excel, enter 5 in cell A1, enter = A1^2+A1^2 in...

Q:

Using a balloon to widen the wall of a blocked artery is referred to as

Q:

What skills and attributes set you apart from others? Explain in detail. 2 . What inspires you? How can you incorporate that into your personal brand?

Q:

2. If your boss is so demanding that you have to lie to protect family time, will you do it? For example, if you have to miss a staff meeting or refuse a business trip to fulfill the needs of your...

Q:

2. What steps do you believe the government should take to reinforce the viability of the Sarbanes-Oxley Law?

Q:

1. In the bright light of hindsight, most of us would probably say we would blow the whistle on these instances had we been a witness to them, especially because there was so much money involved. But...