« previous next »

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

awywial

  • Hero Member
  • *****
  • Posts: 577
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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
Reply #2 on: Jul 7, 2018
Correct answers!


diana chang

  • Sr. Member
  • ****
  • Posts: 288
Reply #3 on: Jul 7, 2018
Great! Please up vote :D


« previous next »
 

Did you know?

Chronic necrotizing aspergillosis has a slowly progressive process that, unlike invasive aspergillosis, does not spread to other organ systems or the blood vessels. It most often affects middle-aged and elderly individuals, spreading to surrounding tissue in the lungs. The disease often does not respond to conventionally successful treatments, and requires individualized therapies in order to keep it from becoming life-threatening.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

In the United States, congenital cytomegalovirus causes one child to become disabled almost every hour. CMV is the leading preventable viral cause of development disability in newborns. These disabilities include hearing or vision loss, and cerebral palsy.

Constraint-Induced Movement Therapy Constraint-Induced Movement Therapy
In countries where water can be contaminated, breastfeeding is an important option for the health of ... In countries where water can be contaminated, breastfeeding is an important option for the health of ...
Is it ethical to break the law to defend our personal integrity? Is it ethical to break the law to defend our personal integrity?
Computer Literacy for IC3, Unit 2: Using Productivity Software, Update to Office 2013 & Windows ... Computer Literacy for IC3, Unit 2: Using Productivity Software, Update to Office 2013 & Windows ...
Essentials of Paramedic Care Update Essentials of Paramedic Care Update
reaction and option reaction and option
Video: Major Elements in Biological Molecules: Lipids

For a complete list of videos, visit our video library