Question

In: Computer Science

Suppose that I have a relation with the following structure, where (EmployeeID, Department) is a composite...

Suppose that I have a relation with the following structure, where (EmployeeID, Department) is a composite primary key.

DEPARTMENT (EmployeeID, EmployeeName, Department, TotalSales).

Further suppose that the following functional dependencies exist

(EmployeeID, Department) → (EmployeeName, TotalSales)

EmployeeID → EmployeeName

True or False: The above relation is in 2NF.

True or False: A relation in second normal form is automatically in third normal form.

True or False: If PartNumber → PartWeight, then PartNumber will be unique in a relation.

Solutions

Expert Solution

A. The relation is in 2NF.

This is False because the relation contains partial functional dependency EmployeeID -> EmployeeName .

This is partial functional dependency since EmployeeID is primary key attribute. And partial functional dependency violates 2NF.

Therefore the given relation is not in 2NF.

B. A relation in second normal form is automatically in third normal form.

This is False.

When a relation is in 2NF, it still can contain transitive functional dependency. And transitive functional dependency violates 3NF

So the given statement is False.

When a relation is in 3NF , then it automatically is in 2NF.

C. If PartNumber → PartWeight, then PartNumber will be unique in a relation.

False.

PartNumber will be unique in a relation only if PartNumber is primary key for the relation. What if, partNumber -> partWeight is a transitive functional dependency. Then PartNumber can contain duplicate value.

If you have any questions comment down. Please just don't simply downvote and leave. If you are satisfied with answer, please? upvote. I really need it, Thanks...


Related Solutions

I have the following question, I have no relation to the study of Physics in any...
I have the following question, I have no relation to the study of Physics in any way, but the question has been teasing me for some time. Please accept my poor physical terminology. Here we go... When a solid ball is thrown in a given angle with sufficient force, that ball will move in a some path. The ball will move until the energy passed to it is no longer effective against other forces affecting its movement. I have the...
I would like to know the relation between theta changing the Philips curve relation. I have...
I would like to know the relation between theta changing the Philips curve relation. I have concluded the following situations: 1. When theta equals zero, we get the original Phillips curve, a relation between the inflation rate and the unemployment rate; 2. When theta is positive, the inflation rate depends not only on the unemployment rate, but also on last year's inflation rate; 3. When theta equals to 1, we get a modified Philips curve, and the relation becomes that...
Composite Viral Structure of a virus? Viral Attributes of a virus?
Composite Viral Structure of a virus? Viral Attributes of a virus?
I have a problem, and I have the answer but I don't know where the solution...
I have a problem, and I have the answer but I don't know where the solution comes from. ( I have to be able to solve these myself so please help me by answering the questions about the problem.) Here is the answer given to me by the professor: What is the density of SF4 vapor at 650 torr and 100 C? 650 torr (1atm/760 Torr)=0.855atm 100C=373K PV=nRT n/v=P/RT= 0.855atm/0.8206l-atm/molek) (373)=0.0279 mole/l M.W. of SF4=108.1 gm/mole Density=mass/volume 0.0279 mole/l(108.1gm/mole) Answer...
W hat is polarization in dielectric? Derive the relation where symbols have their usual meaning.
W hat is polarization in dielectric? Derive the relation where symbols have their usual meaning.
I have a project where i have to include solar cells and piezoelectric transducers in an...
I have a project where i have to include solar cells and piezoelectric transducers in an umbrella. They will be used to transform solar energy and energy from rain respectively into electrical energy. (stored in a lithium battery) I would like to know how i should build up the circuit. As in: 1. should i connect the solar cells in series? 2. How do i connect the piezoelectric transducers? what type of rectifying diode i need for this experiement. 3....
In a relation to ‘capital structure’ explain the relation between debt financing, equity financing and market...
In a relation to ‘capital structure’ explain the relation between debt financing, equity financing and market value of an organization. Then, provide two different examples of the relation.
hello everyone, i have this assignment to do and i dunno how to structure it as...
hello everyone, i have this assignment to do and i dunno how to structure it as i didnt have enough informations about the layout and the structure. please provide me with the structure starting from the introduction, excutive summary,...,.....,......,.......,conclusion and references. i need to fill up the paragraphs but i dunno what to layout. Assume your group comprises the Sydney City Council. In an effort to reduce inner city congestion, there is already a project to establish light rail. But...
I am not sure where, to begin with, this problem... "You have found the following historical...
I am not sure where, to begin with, this problem... "You have found the following historical information for DEF Company:                          Year1       Year 2        Year 3        Year 4 Stock Price        $46.29         $49.74          $54.55          $57.07 EPS                  $2.04 $2.9    $2.81    $3.78 Earnings are expected to grow at 8 percent for the next year. Using the company's historical average PE as a benchmark, what is the target stock price in one year?"
For each relation below, determine the following.(i) Is it a function? If not, explain why not...
For each relation below, determine the following.(i) Is it a function? If not, explain why not and stop. Otherwise, answer part (ii).(ii) What are its domain and image? (a){(x, y) :x, y∈Z, y- 2x}. (b){(x, y) :x, y∈Z, xy- 0}. (c){(x, y) :x, y∈Z, y-x2}. (d){(x, y) :x, y∈Z, x|y}. (e){(x, y) :x, y∈Z, x+y= 0}. (f){(x, y) :x, y∈R, x2+y2= 1}.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT