Question: e. Add the data provided in the attached Excel files (i.e., SPONSOR, ZOOKEEPER, and DEPENDENT) using either INSERT statements or the LOAD DATA statement. (HINT:

 e. Add the data provided in the attached Excel files (i.e.,
SPONSOR, ZOOKEEPER, and DEPENDENT) using either INSERT statements or the LOAD DATA
statement. (HINT: Refer to the MySQL Tutorial for information on the LOAD
DATA statement. All data will need to be saved from Microsoft Excel

e. Add the data provided in the attached Excel files (i.e., SPONSOR, ZOOKEEPER, and DEPENDENT) using either INSERT statements or the LOAD DATA statement. (HINT: Refer to the MySQL Tutorial for information on the LOAD DATA statement. All data will need to be saved from Microsoft Excel to a CSV file. For creating INSERT statements, in Microsoft Excel, you can create a formula that builds the INSERT statement and copy it to each row.) SPONSORNUISOCSECNUMSPONSORNAME ADDRESS \begin{tabular}{|l|l|l|l|} \hline 133861 & 83776427 Smythe & Washington, DC & 2025551248 \\ \hline 142174 & 42916465 Carter & Memphis, TN & 9015553290 \\ \hline 225729 & 93015012 Johnson & Los Angeles, CA & 2135552142 \\ \hline 234149 & 62945822 Kaplan & Memphis, TN & 9015553819 \\ \hline 254381 & 59244163 Lopez & Los Angeles, CA & 2135552934 \\ \hline 259028 & 13287482 Gonzalez & Chicago, IL & 3125552288 \\ \hline 310656 & 49271183 Simmons & Miami, FL & 3055552982 \\ \hline 394587 & 34575207 Singh & Washington, DC & 2025552292 \\ \hline 425911 & 52478221 Dodd & New York, NY & 2125552819 \\ \hline 428247 & 48375913 Jennings & Dallas, TX & 2145554912 \\ \hline 481912 & 48294713 DuBois & Chicago, IL & 3125552342 \\ \hline 524891 & 72716328 Carter & Miami, FL & 3055559124 \\ \hline 628902 & 31498577 Smith & Troy, NY & 5185552299 \\ \hline 739716 & 32572856 Lopez & Columbus, OH & 6145552821 \\ \hline 759285 & 49218549 Jackson & Memphis, TN & 9015552211 \\ \hline \end{tabular} PONSOR DEPENNA RELATION BIRTHDATE e. Add the data provided in the attached Excel files (i.e., SPONSOR, ZOOKEEPER, and DEPENDENT) using either INSERT statements or the LOAD DATA statement. (HINT: Refer to the MySQL Tutorial for information on the LOAD DATA statement. All data will need to be saved from Microsoft Excel to a CSV file. For creating INSERT statements, in Microsoft Excel, you can create a formula that builds the INSERT statement and copy it to each row.) SPONSORNUISOCSECNUMSPONSORNAME ADDRESS \begin{tabular}{|l|l|l|l|} \hline 133861 & 83776427 Smythe & Washington, DC & 2025551248 \\ \hline 142174 & 42916465 Carter & Memphis, TN & 9015553290 \\ \hline 225729 & 93015012 Johnson & Los Angeles, CA & 2135552142 \\ \hline 234149 & 62945822 Kaplan & Memphis, TN & 9015553819 \\ \hline 254381 & 59244163 Lopez & Los Angeles, CA & 2135552934 \\ \hline 259028 & 13287482 Gonzalez & Chicago, IL & 3125552288 \\ \hline 310656 & 49271183 Simmons & Miami, FL & 3055552982 \\ \hline 394587 & 34575207 Singh & Washington, DC & 2025552292 \\ \hline 425911 & 52478221 Dodd & New York, NY & 2125552819 \\ \hline 428247 & 48375913 Jennings & Dallas, TX & 2145554912 \\ \hline 481912 & 48294713 DuBois & Chicago, IL & 3125552342 \\ \hline 524891 & 72716328 Carter & Miami, FL & 3055559124 \\ \hline 628902 & 31498577 Smith & Troy, NY & 5185552299 \\ \hline 739716 & 32572856 Lopez & Columbus, OH & 6145552821 \\ \hline 759285 & 49218549 Jackson & Memphis, TN & 9015552211 \\ \hline \end{tabular} PONSOR DEPENNA RELATION BIRTHDATE

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!