Author Question: If a DBMS enforces an UPDATE SET-TO-NULL option on the referential integrity constraint ... (Read 77 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 highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

The average person is easily confused by the terms pharmaceutics and pharmacology, thinking they are one and the same. Whereas pharmaceutics is the science of preparing and dispensing drugs (otherwise known as the science of pharmacy), pharmacology is the study of medications.

For a complete list of videos, visit our video library