Create a PL/SQL block, using anchored data type, to retrieve and display information for a specific pledge. Display the pledge ID, donor ID, pledge amount, total paid so far, and the difference between the pledged amount and the total paid amount. Use 100 as the pledge ID in the search criteria.

When converting the erd to a table design, how should you handle the assignedto relationship? (be sure to include a discussion of primary keys, foreign keys, and tables in your answer.)11. true/false projectid will be a foreign key in the employees table to reflect the “manages” relationship.12. after converting the erd to a table design, what fields will be present in the contracts