New answers tagged constraint
1
You try to insert Albums.ArtistId value (7) which is absent in Artisis.ArtistId values list now. So insertion fails.
You cannot insert album of <unknown>, FK claims this is impossible, and server prevents this.
Insert artist with ArtistId=7 first, then insert his albums.
1
Reporting Constraint Exceptions
You must create an appropriate exceptions report table to accept
information from the EXCEPTIONS option of the ENABLE clause before
enabling the constraint. You can create an exception table by
executing the UTLEXCPT.SQL script or the UTLEXPT1.SQL script.
The following statement attempts to validate the PRIMARY ...
0
I think that I would do something like the following.
Have a (sort of) joining table (or Associative Entity in the technical jargon) called slot.
If it's a manual system and you don't actually have a physical slot for individual bicycles (i.e. bicycles are stored behind a counter and allocated on an ad-hoc basis - but I'm also assuming that you keep track ...
Top 50 recent answers are included
