Title: During the database redesign process, you discover that when you try to change a DEPARTMENT name ... Post by: yuknam on Feb 13, 2019 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 Title: During the database redesign process, you discover that when you try to change a DEPARTMENT name ... Post by: jeromet1 on Feb 13, 2019 Content hidden
Title: During the database redesign process, you discover that when you try to change a DEPARTMENT name ... Post by: yuknam on Feb 13, 2019 Exactly what I needed for my project, TYSM
|