Author Question: Table VEHICLE is in 1NF Indicate whether the statement is true or ... (Read 44 times)

go.lag

  • Hero Member
  • *****
  • Posts: 667
Table VEHICLE is in 1NF
 
  Indicate whether the statement is true or false

Question 2

If a DBMS enforces an UPDATE RESTRICT option on the referential integrity constraint betweenCLIENT and AGENT in the HAPPY INSURANCE database, what will be the outcome after auser tries to change the AgentID value in the last record to A5?
 
  A) Value A4 appears once in column AgentID in AGENT, and value A4 appears once in column ClientAgent in table CLIENT
  B) Value A5 appears once in column AgentID in AGENT, and value A5 appears once in column ClientAgent in table CLIENT
  C) Value A5 appears once in column AgentID in AGENT, and value A5 does not appear in column ClientAgent in table CLIENT
  D) Value A5 does not appear in column AgentID in AGENT, and value A5 appears once in column ClientAgent in table CLIENT



tashiedavis420

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

TRUE

Answer to Question 2

A



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

Did you know?

Tobacco depletes the body of vitamins A, C, and E, which can result in any of the following: dry hair, dry skin, dry eyes, poor growth, night blindness, abscesses, insomnia, fatigue, reproductive system problems, sinusitis, pneumonia, frequent respiratory problems, skin disorders, weight loss, rickets, osteomalacia, nervousness, muscle spasms, leg cramps, extremity numbness, bone malformations, decayed teeth, difficulty in walking, irritability, restlessness, profuse sweating, increased uric acid (gout), joint damage, damaged red blood cells, destruction of nerves, infertility, miscarriage, and many types of cancer.

Did you know?

Aspirin is the most widely used drug in the world. It has even been recognized as such by the Guinness Book of World Records.

Did you know?

People with high total cholesterol have about two times the risk for heart disease as people with ideal levels.

For a complete list of videos, visit our video library