If a DBMS enforces an UPDATE SET-TO-NULL option on the ...

[awywial]

If a DBMS enforces an UPDATE SET-TO-NULL 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

Question 2

Why is training so important for ERP implementations? What are some of the ways it can be delivered?
 
  What will be an ideal response?

[diana chang]

Answer to Question 1

C

Answer to Question 2

Because implementing a new ERP system involves so many different changes to jobs and processes users must have extensive training in the system using real data and examples. This training should extend throughout the project and beyond the go live as new functions are added and new employees are hired. Ironically, training is one of the first things to be cut when a project goes over budget. Besides delivering training with an instructor in a classroom face-to-face, it can be done via DVDs, videos, and on-line or using web-based technologies.

[awywial]

Correct answers!

[diana chang]

Great! Please up vote