Top Posters
Since Sunday
j
22
22
i
19
a
18
z
18
m
17
D
17
16
j
16
K
16
s
16
a
16
New Topic  
wrote...
Posts: 212
Rep: 9 0
6 months ago
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. To fix this, you use what SQL syntax?

• ON UPDATE CASCADE

• ON DELETE CASCADE

• ADD CONSTRAINT

• FOREIGN KEY
Textbook 

Database Processing: Fundamentals, Design, and Implementation

Edition: 15th
Authors:
Read 19 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 240
6 months ago
Sign in or Sign up in seconds to unlock everything.
ON UPDATE CASCADE
1
Related Topics
wrote...
6 months ago
Exactly what I needed for my project, TYSM
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  118 People Browsing
Your Opinion
Which of the following is the best resource to supplement your studies:
Votes: 53

Related Images
 498
 140
 41