Question: DONATIONS: pledge _ id NUMBER NOT NULL PRIMARY KEY donor _ id NUMBER - Foreign key to DONOR _ ID column of DONORS table pledge

DONATIONS:
pledge_id NUMBER NOT NULL PRIMARY KEY
donor_id NUMBER - Foreign key to DONOR_ID column of DONORS table
pledge_dt DATE
amount_pledged NUMBER (7,2)
amount_paid NUMBER (7,2)
payment_dt DATE
Which CREATE TABLE statement should you use to create the DONATIONS 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 Databases Questions!

Q:

Assignment 3-12: Retrieving a Specific Pledge Create a PL/SQL block to retrieve and display information for a specific pledge. Display the pledge ID, donor ID, pledge amount, total paid so far, and...

Q:

Assignment 4-12: Using a Cursor Variable Create a block with a single cursor that can perform a different query of pledge payment data based on user input. Input provided to the block includes a...

Q:

Project 3 Using Oracle, access the tables you created in Project 2 and complete the following SQL transactions. Log your statements and results by spooling your file (with echo on). Directions for...

Q:

Using Oracle, access the tables you created in Project 2 and complete the following SQL transactions. 2 points Add a new customer to the Customer table. The customer ID should be one more than the...

Q:

Project 3 Using Oracle, access the tables you created in Project 2 and complete the following SQL transactions. Log your statements and results by spooling your file (with echo on). All column...

Q:

Using Oracle, access the tables you created in Project 2 and complete the following SQL transactions. Log your statements and results by spooling your file (with echo on). All column headings must...

Q:

16 List the customer type, customer type description, and count of customers for each customer type. Use the following column headings: CustType, Description, Count. Sort by count in descending...

Q:

Using Oracle, access the tables you created in Project 2 and complete the following SQL transactions. 4 points List the customer ID, customer first name, customer last name, and customer phone number...

Q:

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS Successful people did not attain their success without first overcoming challenges.------- Catherine Pulsifer FOLLOW...

Q:

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS FOLLOW INSTRUCTIONS: DO NOT SKIP A SINGLE STEP SECTION I: NOTE: Do not specify any constraints with the create statement...

Q:

Determine the amount that must be deposited now at compound interest to provide the desired sum for each of the following: 1. Amount to be invested for 10 years at 6% per annum, compounded...

Q:

The following figure shows a business cycle. Identify each of the following as a phase of the business cycle: (a) Point A (b) Between points A and B (c) Point B (d) Between points B and C (e) Point D

Q:

21. LO.8 Give the Circular 230 position concerning each of the following situations sometimes encountered in the tax profession. a. Taking an aggressive pro-taxpayer position on a tax return. b. Not...

Q:

Discuss several ways ( at least four ways ) to improve the requirement process and thus, a project team can avoid a situation where too many changes to the project requirements occur at the later...

Q:

Your personal relationships: Are you closely connected to your family? Who are your friends?

Q:

1. Research indicates that employee misconduct tends to increase in companies where mergers, acquisitions, and restructurings are under way. Why do you think this happens?

Q:

You are offered a great job, but you have to relocate to a distant city. Your family agrees that the decision is yours to make, but you know they do not want to move. What do you do?