Answered: using sql develpper or sql live oralce…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

using sql develpper or sql live oralce

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.

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions