Question: Question 2 (8 points): Please refer to the ERD below (from lab 3 you still remember) and use SQL to create the database DonationDB using

Question 2 (8 points): Please refer to the ERD

Question 2 (8 points): Please refer to the ERD below (from lab 3 you still remember) and use SQL to create the database "DonationDB using MySQL Workbench. DONOR CAUSE gives is received for PK Donori FirstName LastName StreetAddress City State Zip DONATION PK, FK1 Donorld KPK, FK2 Causel PK Date Time Donated AmountDonated PK Causel Name Description provides provides PHONE PK, EK1 Donorin PK Phone Number EMAIL PK, FK1 Donorld PK Email Address Special considerations: Determining data types for each attribute (blank column above). The goal when choosing data types is to choose one that won't use too much space while being large enough to store the values it requires. DONATION Table: DateTimeDonated has a default value to get current date and time when each order is placed. You can do this by adding a SQL data constraint: DEFAULT CURRENT_TIMESTAMP. DONOR Table: The organization currently only accepts donors who live in CA, UT, or AZ. You can realize this by adding a SQL data constraint: CHECK (State in ('CA', 'UT', 'AZ')). . Question 2 (8 points): Please refer to the ERD below (from lab 3 you still remember) and use SQL to create the database "DonationDB using MySQL Workbench. DONOR CAUSE gives is received for PK Donori FirstName LastName StreetAddress City State Zip DONATION PK, FK1 Donorld KPK, FK2 Causel PK Date Time Donated AmountDonated PK Causel Name Description provides provides PHONE PK, EK1 Donorin PK Phone Number EMAIL PK, FK1 Donorld PK Email Address Special considerations: Determining data types for each attribute (blank column above). The goal when choosing data types is to choose one that won't use too much space while being large enough to store the values it requires. DONATION Table: DateTimeDonated has a default value to get current date and time when each order is placed. You can do this by adding a SQL data constraint: DEFAULT CURRENT_TIMESTAMP. DONOR Table: The organization currently only accepts donors who live in CA, UT, or AZ. You can realize this by adding a SQL data constraint: CHECK (State in ('CA', 'UT', 'AZ'))

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 General Management Questions!