Question: Any sort of help would be greatly appreciated. 1) Start the Simple SQL app and load the two example tables: People and Citylnfo 2) Edit
Any sort of help would be greatly appreciated. 
1) Start the Simple SQL app and load the two example tables: People and Citylnfo 2) Edit the Citylnfo table and add a row for Ainsworth. Its famous thing is corn. (You do not need to type in a row number, since the app wil fill this in when you save it.) 3) Add a new field called State. Its type is String. Fill in the following information: Valent ine and Ainsworth are in Nebraska; Greeley is in Colorado, and San Francisco is in California. 4) Take a screenshot. Save your changes by clicking on the OKbutton. 5) Now we will make an entirely new table. Back at the main Simple SQL window, click on New. An edit window will pop open with an empty table named newtable. Change the name to Statelnfo. 6) Set up three fields: Name of the state Name: Capital Population Total population of the state Bird Name of the capital city The state bird Can you guess the proper types of each of these 7) Type the right data into each field. You could find the data on www.wikipedia.com, but here are the details for your convenience: California Nebraska Colorado Sacramento Lincoln Denver 33,871,000 1,711,000 4,301,000 California Quail Meadowlark Lark Bunting (The app will permit you to type commas into your numbers, which is very humane. Many computer applications and programming languages are more persnickety) 8) Take a snapshot of the table and click OK to save your changes to Statelnfo 9) Now we are going to link three tables a: once, which is definitely not for the faint of heart. We do this in order to answer the following question: What are the names of the state birds foreach of the people in our People table? See if you can answer this "by hand" first without writing SQL. As you struggle to find the people's birthplaces, and the states that those birthplaces are in, and the state birds of the states that those birthplaces are in-whew! Gets complicated! This is why computers are still not able to understand human language there's so much to know and so much logic to use when you chain facts together
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
