I’m designing a database to use in our project, a program to manage a music database.
In the table programmanummer(Programnumber) it includes as primary foreign key GebruikerID(UserID), which is used in the table Programma(Program). I don’t think this is necessary, but the program won’t allow me to delete the key from the programmanummer table. Is there something i’m missing here? Or is it just a quirk in TOAD?