Considering my school's registration database that enforces the integrity constraint of enrolling in a certain class, to complete the listed prerequisite, the way to get around it without having to have a prerequisite would be to alter the databases primary keys. The primary key and foreign key provide logical and restrictive relationships between the databases files. With certain keys, it restricts the relationships that can be created.
I feel like this would not be an instance to override an integrity constraint. There are certain classes that are needed in order to gain the knowledge to be able to advance to the next. The downsides of being able to override the integrity constraint would be that you are not only affecting yourself and your ability to get into a class, but you are also affecting how other student's classes that they need to take. It is also affecting how the school's relationships in the database are being set up.
No comments:
Post a Comment