Question

Question 25 Mark this question In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. https://postgres.sophia.org/ In trying to delete from the playlist table, what is the cause of this error? "Query failed because of: error: update or delete on table \"playlist\" violates foreign key constraint \"playlist_track_playlist_id_fkey\" on table \"playlist_track\" The playlist_id doesn't exist in the playlist_track table. The track has to be deleted first before the playlist is deleted. The playlist_id doesn't exist in the playlist table. The playlist_track table has a reference to the playlist_id that is being deleted.

          Question 25
Mark this question
In each milestone, you may want or need to use the database and query tool to answer
some of the questions. We suggest you open the tool in another browser tab while you
are working on this assessment.
https://postgres.sophia.org/
In trying to delete from the playlist table, what is the cause of this error?
"Query failed because of: error: update or delete on table \"playlist\" violates foreign key
constraint \"playlist_track_playlist_id_fkey\" on table \"playlist_track\"
The playlist_id doesn't exist in the playlist_track table.
The track has to be deleted first before the playlist is deleted.
The playlist_id doesn't exist in the playlist table.
The playlist_track table has a reference to the playlist_id that is being deleted.

Question 25
Mark this question
In each milestone, you may want or need to use the database and query tool to answer
some of the questions. We suggest you open the tool in another browser tab while you
are working on this assessment.
https://postgres.sophia.org/
In trying to delete from the playlist table, what is the cause of this error?
"Query failed because of: error: update or delete on table p̈laylistv̈iolates foreign key
constraint p̈laylisttrackplaylistidfkeyön table p̈laylisttrackT̈he playlistid doesn't exist in the playlisttrack table.
The track has to be deleted first before the playlist is deleted.
The playlistid doesn't exist in the playlist table.
The playlisttrack table has a reference to the playlistid that is being deleted.

Added by Lisa E.

Question

Please give Ace some feedback