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 58 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?

A serious new warning has been established for pregnant women against taking ACE inhibitors during pregnancy. In the study, the risk of major birth defects in children whose mothers took ACE inhibitors during the first trimester was nearly three times higher than in children whose mothers didn't take ACE inhibitors. Physicians can prescribe alternative medications for pregnant women who have symptoms of high blood pressure.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

A strange skin disease referred to as Morgellons has occurred in the southern United States and in California. Symptoms include slowly healing sores, joint pain, persistent fatigue, and a sensation of things crawling through the skin. Another symptom is strange-looking, threadlike extrusions coming out of the skin.

For a complete list of videos, visit our video library