lease implement the following using Oracle live/SQL Developer: 1- Create the DONORS table with the following columns: donor_id ( PRIMARY KEY), donor_name (Not Null), donor_age. Then Create DONATIONS table with the following columns: pledge_id (PRIMARY KEY), pledge_date, amount_pledged, amount_paid, Is_paid, donor_id that REFERENCES to DONORS table (donor_id). 2- Populate every relation with three rows. 3- Now, your supervisor has asked you to modify the donor_age column in the DONORS table. He wants the column to be configured to accept a value that must be >=20. Which statement should you issue to accomplish this task? 4- Create a Trigger to update Is_paid column to 1 when the amount_paid equal to amount_pledged.
PLz help with the following
Please implement the following using Oracle live/SQL Developer:
1- Create the DONORS table with the following columns: donor_id ( PRIMARY KEY), donor_name (Not Null), donor_age. Then Create DONATIONS table with the following columns: pledge_id (PRIMARY KEY), pledge_date, amount_pledged, amount_paid, Is_paid, donor_id that REFERENCES to DONORS table (donor_id).
2- Populate every relation with three rows.
3- Now, your supervisor has asked you to modify the donor_age column in the DONORS table. He wants the column to be configured to accept a value that must be >=20. Which statement should you issue to accomplish this task?
4- Create a Trigger to update Is_paid column to 1 when the amount_paid equal to amount_pledged.
Step by step
Solved in 2 steps