Evaluate the structure of the DONATIONS table.

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?

Group of answer choices

CREATE TABLE donations

$($pledge$\_$id NUMBER PRIMARY KEY,

donor$\_$id NUMBER FOREIGN KEY REFERENCES donors$($donor$\_$id$),$

pledge$\_$date DATE,

amount$\_$pledged NUMBER,

amount$\_$paid NUMBER,

payment$\_$dt DATE$)$;

CREATE TABLE donations

$($pledge$\_$id NUMBER PRIMARY KEY,

donor$\_$id NUMBER CONSTRAINT donor$\_$id$\_$fk REFERENCES donors$($donor$\_$id$),$

pledge$\_$date DATE,

amount$\_$pledged NUMBER$(7,2),$

amount$\_$paid NUMBER$(7,2),$

payment$\_$dt DATE$)$;

CREATE TABLE donations

pledge$\_$id NUMBER PRIMARY KEY,

donor$\_$id NUMBER FOREIGN KEY donor$\_$id$\_$fk REFERENCES donors$($donor$\_$id$),$

pledge$\_$date DATE,

amount$\_$pledged NUMBER$(7,2),$

amount$\_$paid NUMBER$(7,2),$

payment$\_$dt DATE;

CREATE TABLE donations

$($pledge$\_$id NUMBER PRIMARY KEY NOT NULL,

donor$\_$id NUMBER FOREIGN KEY donors$($donor$\_$id$),$

pledge$\_$date DATE,

amount$\_$pledged NUMBER$(7,2),$

amount$\_$paid NUMBER$(7,2),$

payment$\_$dt DATE$)$;