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:
1. Create a new table named "Alumni" with the following attributes:
o name: Name of the graduate
o student_number: Unique student number of the graduate
o age_at_graduation: Age of the student at the time of graduation
o graduation_date: Date the student graduated
2. 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.
3. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!