You work for a small auto trading company. You need to remove a car from the company database.
Information about the car is stored in the following tables.
All of the car's parts are custom made, so they each have a row in every table. Cascading deletes are not enabled but referential integrity is.
From which table must you first make your deletion?
When removing a car's information from a database with referential integrity but without cascading deletes enabled, you need to remove entries starting from the tables with the least dependencies to avoid violating referential integrity constraints. In this case, you should start with the 'ModelEngine' table, as it directly connects the 'Model' and 'Engine' tables but doesn't depend on the 'Make' table. Deleting the 'ModelEngine' record first allows you to safely remove the corresponding entries in the 'Model' and 'Engine' tables subsequently, without causing any referential integrity issues.
i think answer is D - ModelEngine as it is not referred anywhere
That is my thought also. Since cascade deletion is not available, then we must start with ModelEngine.
Since cascade deletion is not available, then we must start with ModelEngine. Answer D should be true.
Through Model Engine table we can access all the other tables