This topic contains a solution. Click here to go to the answer

Author Question: Boyce-Codd Normal Form (BCNF) states which of the following? A) A non-key field may not determine ... (Read 117 times)

armygirl

  • Hero Member
  • *****
  • Posts: 556
Boyce-Codd Normal Form (BCNF) states which of the following?
 
  A) A non-key field may not determine another non-key field.
  B) A part of the primary key may not determine a non-key field.
  C) A part of a non-key field may not determine the primary key field.
  D) The primary key may not determine a non-key field.

Question 2

Having a part of CustomerID primary key come from customer's email address, violates which
  of the following normal forms?
 
  A) 2NF B) 1NF C) 3NF D) BCNF



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

ndhahbi

  • Sr. Member
  • ****
  • Posts: 390
Answer to Question 1

C

Answer to Question 2

C





 

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

Chronic necrotizing aspergillosis has a slowly progressive process that, unlike invasive aspergillosis, does not spread to other organ systems or the blood vessels. It most often affects middle-aged and elderly individuals, spreading to surrounding tissue in the lungs. The disease often does not respond to conventionally successful treatments, and requires individualized therapies in order to keep it from becoming life-threatening.

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

For a complete list of videos, visit our video library