Author Question: If a DBMS enforces an UPDATE SET-TO-NULL option on the referential integrity constraint ... (Read 79 times)

awywial

  • Hero Member
  • *****
  • Posts: 577
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

  • Sr. Member
  • ****
  • Posts: 288
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.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question

awywial

  • Hero Member
  • *****
  • Posts: 577

diana chang

  • Sr. Member
  • ****
  • Posts: 288

 

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

For a complete list of videos, visit our video library