Download the world.db database file and open it in the DB Browser by clicking the Open Database button. The database contains three tables. Examine its structure and the data in the tables using the Database Structure and Browse Data tabs. Become familiar with the structure of the tables. I strongly suggest you sketch out an ERD showing the primary and foreign keys, attributes, and relationships for each entity. This will be of great value as you build the queries. Finally, you may want to close the panels to the right, as you will only need the ones on the left to build and run your queries.

Database world.DB Code ### Continents (& Regions) eu, Europe sa, South America na, North America ca, Central America ci, Caribbean af, Africa me, Middle East as, Asia pa, Pacific # includes Australia & New Zealand aq, Antarctica 

### Countries ca, Canada, CAN, Ottawa, 9 984 670 km, 34 278 406 mx, Mxico [Mexico], MEX, Mxico D.F., 1 972 550 km, 112 322 757 us, United States, USA, Washington D.C., 9 629 091 km, 314 167 157 

### Tags - Political Organizations Canada, un|g8|g20|commonwealth United States, un|g8|g20 Mxico, un|g5|g20 

### Tags - Sports Organizations Canada, ioc|fifa  concacaf  nafu United States, ioc|fifa  concacaf  nafu Mxico, ioc|fifa  concacaf  nafu 

### Provinces bc, British Columbia, Victoria, 922 509 km ab, Alberta, Edmonton, 640 082 km mb, Manitoba, Winnipeg, 552 330 km sk, Saskatchewan, Regina, 588 239 km nb, New Brunswick, Fredericton, 71 377 km ns, Nova Scotia, Halifax, 52 939 km pe, Prince Edward Island, Charlottetown, 5 686 km nl, Newfoundland and Labrador, St. John's, 370 511 km on, Ontario, Toronto, 908 608 km qc, Qubec, Quebec City, 1 356 547 km nt, Northwest Territories, Yellowknife, 1 143 793 km yt, Yukon, Whitehorse, 474 713 km nu, Nunavut, Iqaluit, 1 877 788 km 

### Tags - Geo Regions British Columbia, western_canada Alberta, western_canada|prairies Manitoba, western_canada|prairies Saskatchewan, western_canada|prairies New Brunswick, eastern_canada|atlantic_canada|maritimes Nova Scotia, eastern_canada|atlantic_canada|maritimes Prince Edward Island, eastern_canada|atlantic canada|maritimes Newfoundland and Labrador, eastern_canada|atlantic_canada Ontario, eastern_canada|central_canada Qubec, eastern_canada|central_canada Northwest Territories, northern_canada|territories Yukon, northern_canada|territories Nunavut, northern_canada|territories 

### Tags - (Official) Languages British Columbia, en Alberta, en Manitoba, en Saskatchewan, en New Brunswick, en|fr Nova Scotia, en Prince Edward Island, en Newfoundland and Labrador, en Ontario, en Qubec, fr|en Northwest Territories, en|fr Yukon, en Nunavut, iu|en|fr 

### Cities Toronto, ON, 5 583 064 Montral|Montreal, QC, 3 824 221 Vancouver, BC, 2 313 328 Ottawa, ON, 1 236 324 Calgary, AB, 1 214 839 Edmonton, AB, 1 159 869 Qubec, QC, 765 706 Winnipeg, MB, 730 018 Hamilton, ON, 721 053 Kitchener, ON, 477 160 London, ON, 474 786 ... 

### Country Codes - Alpha 2, Alpha 3, Numeric Afghanistan, AF, AFG, 004 land Islands (FI), AX, ALA, 248 Albania, AL, ALB, 008 Algeria, DZ, DZA, 012 American Samoa (US), AS, ASM, 016 Andorra, AD, AND, 020 Angola, AO, AGO, 024 ...

Instructions You're now ready to begin. Answer each question below by creating an SQL query using SOLite a described above. Create a document with your name and assignment number at the top. For eac exercise, state the question and provide a screen capture showing the SQL statement you wrote along with the results it produced. For example, if an exercise asked you to display the name and surface area of all countries in the continent of Antarctica, you would provide a screen shot like the one in the figure below. SELECT Name , SurfaceAred FROM Country WHERE Continent 'Antarctica'; Name SurfaceArea 13120000.0 59.0 1 Antarctica 2 Bouvet Island 3 South Georgia and the South Sandwich Islands 3903.0 4 Heard Island and McDonald Islands 359.0 5 rows returned in lms from: SELECI Name, SurfaceArea FROM Country WHERE Continent -'Antarctica Instructions You're now ready to begin. Answer each question below by creating an SQL query using SOLite a described above. Create a document with your name and assignment number at the top. For eac exercise, state the question and provide a screen capture showing the SQL statement you wrote along with the results it produced. For example, if an exercise asked you to display the name and surface area of all countries in the continent of Antarctica, you would provide a screen shot like the one in the figure below. SELECT Name , SurfaceAred FROM Country WHERE Continent 'Antarctica'; Name SurfaceArea 13120000.0 59.0 1 Antarctica 2 Bouvet Island 3 South Georgia and the South Sandwich Islands 3903.0 4 Heard Island and McDonald Islands 359.0 5 rows returned in lms from: SELECI Name, SurfaceArea FROM Country WHERE Continent -'Antarctica