Alter the Charity table and specifically the store column so that it will only accept values of 'YES' and 'NO' Name your constraint 

charity_store_ck 

The test for this SQL query will be verify the existance of your constraint

 

Transcribed Image Text:

WORKERS CUSTOMER_ORDER PeopleID: INTEGER [ PFK PeopleID: INTEGER [ PFK ] HireDate: DATE TermDate: DATE SSN: CHAR(12) CustomerSince: DATE CHARITY CharityID: INTEGER [ PK ] ARTIST Name: CHAR(20) Address: CHAR(30) City: CHAR(30) State: CHAR(2) Zip: CHAR(10) Phone: CHAR(12) ContactID: INTEGER [ FK ] PeopleID: INTEGER [ PFK ] PEOPLE TaxIDNum: CHAR(12) ArtistSince: DATE PeopleID: INTEGER [ PK] FirstName: CHAR(15) +LastName: CHAR(15) Address: CHAR(30) City: CHAR(30) State: CHAR(2) Zip: CHAR(10) Phone: CHAR(12) CellPhone: CHAR(12) Email: VARCHAR(50) PeopleType: CHAR(4) ORDER OrderID: INTEGER [ PK ] OrderDate: DATE CustomerID: INTEGER [ FK ]Eb EmployeeID: INTEGER [ FK ] DONATION DonationID: INTEGER [ PK ] DonationDate: DATE ddCharityID: INTEGER [ FK ] EmployeeID: INTEGER [ FK ] ARTIST_ITEM ORDER_ITEM OrderID: INTEGER [ PFK ] ItemID: INTEGER [ PFK ] ItemID: INTEGER [ PFK ] DateAquired: DATE PurchasePrice: DECIMAL(5, 2) ITEM_DONATION DonationID: INTEGER [ PFK ] ItemID: INTEGER [ PFK ] Price: DECIMAL(5, 2) Value: DECIMAL(5, 2) ITEM ItemID: INTEGER [ PK ] ITEM_TYPE ITEM_PICKUP ItemTypeID: INTEGER [ FK ] Size: CHAR(15) MaxPrice: DECIMAL(5, 2) eMinPrice: DECIMAL(5, 2) OwnerID: INTEGER ItemTypeID: INTEGER [ PK ] ItemID: INTEGER [ PFK ] Name: CHAR(25) Description: CHAR(35) Date: DATE WORKERS CUSTOMER_ORDER PeopleID: INTEGER [ PFK PeopleID: INTEGER [ PFK ] HireDate: DATE TermDate: DATE SSN: CHAR(12) CustomerSince: DATE CHARITY CharityID: INTEGER [ PK ] ARTIST Name: CHAR(20) Address: CHAR(30) City: CHAR(30) State: CHAR(2) Zip: CHAR(10) Phone: CHAR(12) ContactID: INTEGER [ FK ] PeopleID: INTEGER [ PFK ] PEOPLE TaxIDNum: CHAR(12) ArtistSince: DATE PeopleID: INTEGER [ PK] FirstName: CHAR(15) +LastName: CHAR(15) Address: CHAR(30) City: CHAR(30) State: CHAR(2) Zip: CHAR(10) Phone: CHAR(12) CellPhone: CHAR(12) Email: VARCHAR(50) PeopleType: CHAR(4) ORDER OrderID: INTEGER [ PK ] OrderDate: DATE CustomerID: INTEGER [ FK ]Eb EmployeeID: INTEGER [ FK ] DONATION DonationID: INTEGER [ PK ] DonationDate: DATE ddCharityID: INTEGER [ FK ] EmployeeID: INTEGER [ FK ] ARTIST_ITEM ORDER_ITEM OrderID: INTEGER [ PFK ] ItemID: INTEGER [ PFK ] ItemID: INTEGER [ PFK ] DateAquired: DATE PurchasePrice: DECIMAL(5, 2) ITEM_DONATION DonationID: INTEGER [ PFK ] ItemID: INTEGER [ PFK ] Price: DECIMAL(5, 2) Value: DECIMAL(5, 2) ITEM ItemID: INTEGER [ PK ] ITEM_TYPE ITEM_PICKUP ItemTypeID: INTEGER [ FK ] Size: CHAR(15) MaxPrice: DECIMAL(5, 2) eMinPrice: DECIMAL(5, 2) OwnerID: INTEGER ItemTypeID: INTEGER [ PK ] ItemID: INTEGER [ PFK ] Name: CHAR(25) Description: CHAR(35) Date: DATE

Answer rating: 100% (QA)

ALTER TABLE Charit... View the full answer