Question: Design a system to track students after graduation using an Alumni table. Implement the following: 1 . Create a new table named Alumni with the
Design a system to track students after graduation using an Alumni table. Implement the following:
Create a new table named "Alumni" with the following attributes:
o name: Name of the graduate
o studentnumber: Unique student number of the graduate
o ageatgraduation: Age of the student at the time of graduation
o graduationdate: Date the student graduated
Set up a trigger on the Students table that will automatically:
o Insert a record into the Alumni table whenever a student is deleted from the Students table.
Create the Graduate procedure to delete students at the graduate level and trigger their transfer to the Alumni table.
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
