Author Question: If a DBMS enforces an UPDATE SET-TO-NULL option on the referential integrity constraint ... (Read 90 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 Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

Long-term mental and physical effects from substance abuse include: paranoia, psychosis, immune deficiencies, and organ damage.

For a complete list of videos, visit our video library