Top Posters
Since Sunday
22
22
19
18
18
17
17
16
16
16
16
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 18 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
  112 People Browsing
Related Images
 428
 145
 171