Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design For Mere Mortals

Authors: Michael J Hernandez

4th Edition

978-0136788041

More Books

Students also viewed these Databases questions

Question

=+3. What is content curation and its role within social media?

Answered: 1 week ago