Given the relation EMPLOYEE(ID#, LastName, ProjectID, ProjectName) and ProjectID can determine ProjectName, but not last name, the relation violates:
A) 1st normal form.
B) Mills normal form.
C) 2nd normal form.
D) 3rd normal form.
E) Olsen normal form.
D
Explanation: D) A relation is said to be in third normal form when there are no transitive dependencies. ProjectID determining ProjectName is a transitive dependency.
CL
You might also like to view...
Joe Kunz agrees to buy a computer from Alf Singer for $3,000, by paying six installments of $500 each. Joe gave Alf $500 as a down payment but then backs out of the deal. Alf's loss of profit will be $1,500
Which of the following statements is TRUE? A) Joe is entitled to get the $500 back. B) Alf is entitled to keep the $500and sue for the balance of the lost profit. C) Alf is entitled to keep the $500, but cannot sue for the balance. D) Under no circumstances can Joe ever get the down payment back. E) Alf is entitled to keep the $500 and sue for all of his lost profit.
In order to establish misrepresentation, the buyer must show the statements were a material part of the decision to buy
Indicate whether the statement is true or false
The increasing numbers of surveillance cameras used for crime detection and prevention by both cities and private businesses leave very few public spaces unmonitored in most cities.
Answer the following statement true (T) or false (F)
Proportionality, additivity, and divisibility are three important properties that LP models possess that distinguish them from general mathematical programming models
a. True b. False Indicate whether the statement is true or false