Question: If the referential integrity from programme to progName is enforced, what would be the effects of the following enforcement actions to the Students table when

If the referential integrity from programme to progName is enforced, what would be the effects of the following enforcement actions to the Students table when a programme of a specific progName is withdrawn or renamed in the Programmes table on the right?

NO ACTION

SET NULL or SET DEFAULT

CASCADE

If the referential integrity from programme to progName is enforced, what

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The following relational database contains two tables Applicants and Programmes where attribute Course Applied is a foreign key that refers to attribute progName: ID# Name Age Country Course Applied...

Let us assume that referential integrity constraint on progName is enforced. ( a ) What would be the effects of the enforcement actions NO ACTION and CASCADE when a programme is withdrawn?

Please attemp the question I have attached and I have guideline for the answers.For question 3,difference between tax evasion and avoiddance can be found in seminar 2 slides.Tax avoidance mean the...

please read the case and answer the critical thinking questions at the end PA) A Legal and Ethical Gray Area 41 Case 12 The Foreign Corrupt Practices Act (FCPA): A Legal and Ethical Gray Area AUTHOR...

please answer the questions PA) A Legal and Ethical Gray Area 441 Case 12 The Foreign Corrupt Practices Act (FCPA): A Legal and Ethical Gray Area AUTHOR BIOGRAPHIES Asbjorn Osland, PhD, is a...

CHAPTER 12 Privacy \"If everybody minded their own business,\" the Dutchman said in a hoarse growl, \"the world would go round a deal faster than it does.\" Lewis Carroll, Alice's Adventures in...

After reading the following listed articles on SOX reporting for this week, provide a critique of SOX. In your opinion, do the benefits of SOX outweigh its Cost? Legislated Ethics: From Enron to...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

The coupon rate on a debt issue is 6%. If the yield to maturity on the debt is 9%, what is the after-tax? Cost of debt in the weighted average cost of capital if the firm's tax rate is 34%?

2. (7 points) A florist has a large greenhouse containing flowers: 20% of the flowers are red. If 7 flowers are randomly chosen (assume independence), determine the probability that exactly 5 are red.

1 1 0 0 % chance of receiving $ 1 , 1 0 0 2 5 0 % chance of receiving $ 1 , 0 0 0 5 0 % chance of receiving $ 1 , 2 0 0 3 5 0 % chance of receiving $ 2 0 0 5 0 % chance of receiving $ 2 , 0 0 0 If...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Prepare a targeted rsum in chronological format to apply for one of the positions you found on the Internet in Application Exercise 7.Partner with a classmate to proofread each others rsum. Submit...

In this Application Exercise, you will be doing the groundwork for an oral presentation to your classmates. First, identify which of the presentation topics listed below you will use. Second, analyze...

Teamwork. Technology. Global. Each member in a group of three should locate an article related to some aspect of global business or business communication. Randomly assign the style (manuscript,...