drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right.

DRAG DROP
Your class project requires that you help a charity set up a website.
The website collects information about volunteers. Each volunteer record must be uniquely
identified. The following information is stored for each volunteer:
Given name Surname Date of birth Phone number Photo You need to create a table to meet the
requirements.
Match the Structured Query Language SQL statements to the SQL query.
Instructions:
To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL
query on the right. Each SQL statement may be used once, more than once, or not at all. Each
correct match is worth one point.

DRAG DROP
Your class project requires that you help a charity set up a website.
The website collects information about volunteers. Each volunteer record must be uniquely
identified. The following information is stored for each volunteer:
Given name Surname Date of birth Phone number Photo You need to create a table to meet the
requirements.
Match the Structured Query Language SQL statements to the SQL query.
Instructions:
To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL
query on the right. Each SQL statement may be used once, more than once, or not at all. Each
correct match is worth one point.

Answer:

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Jain

Jain

Int PK

Date

Image

MTAinHalfAnHour

MTAinHalfAnHour

Int primary key,
Date,
Image

Even though storing an image in a database is a bad idea. It’s better to store the location of the image instead.