This topic contains a solution. Click here to go to the answer

Author Question: During the database redesign process, you discover that when you try to change a DEPARTMENT name ... (Read 99 times)

codyclark

  • Hero Member
  • *****
  • Posts: 538
During the database redesign process, you discover that when you try to change a DEPARTMENT name (the department's primary key), the change is disallowed by the DBMS due to your design of the EMPLOYEE table (which has a foreign key referencing
 
  DEPARTMENT) You want the change to be allowed. In order to fix this, you use what SQL syntax?A) ON UPDATE CASCADE
  B) ON DELETE CASCADE
  C) ADD CONSTRAINT
  D) FOREIGN KEY

Question 2

A view may not be assigned to a(n) ________.
 
  A) BEFORE trigger
  B) INSTEAD OF trigger
  C) CONCURRENT trigger
  D) AFTER trigger



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

k2629

  • Sr. Member
  • ****
  • Posts: 357
Answer to Question 1

A

Answer to Question 2

D




codyclark

  • Member
  • Posts: 538
Reply 2 on: Jul 7, 2018
Gracias!


ryansturges

  • Member
  • Posts: 338
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

A serious new warning has been established for pregnant women against taking ACE inhibitors during pregnancy. In the study, the risk of major birth defects in children whose mothers took ACE inhibitors during the first trimester was nearly three times higher than in children whose mothers didn't take ACE inhibitors. Physicians can prescribe alternative medications for pregnant women who have symptoms of high blood pressure.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

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?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

For a complete list of videos, visit our video library