Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
yuknam yuknam
wrote...
Go to Answer
Posts: 503
Rep: 9 0
5 years 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

Database Processing: Fundamentals, Design, and Implementation


Edition: 15th
Authors:
Read 54 times
2 Replies
Replies
Answer verified by a subject expert
jeromet1jeromet1
wrote...
#1
Posts: 386
Rep: 67 0
5 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

yuknam Author
wrote...
#2
5 years ago
Exactly what I needed for my project, TYSM
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1372 People Browsing
 127 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 4883
  
 743
  
 194
Your Opinion
Who's your favorite biologist?
Votes: 586
Previous poll results: Which 'study break' activity do you find most distracting?