Table VEHICLE is in 1NF Indicate whether the statement is true ...

[go.lag]

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]

Answer to Question 1

TRUE

Answer to Question 2

A