Question: Using the four Fine - Granular Design - Specific ER Diagrams given below, show how / where the relevant deletion rule can be incorporated into
Using the four FineGranular DesignSpecific ER Diagrams given below, show howwhere the relevant deletion rule can be incorporated into the ER diagram for the following four deletion constraints. Consider each deletion constraint independently and be sure to indicate if the deletion rule can be appropriately applied for the deletion constraint.
If a physician is deleted from the database, all prescriptions written by that physician must be deleted.
If a patient is deleted from the database, all prescriptions received by that patient must be deleted.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
