SQL Use this table to the following

514 .Chapter 10 Databases 10.1 An Introduction to Databases Introduction The management of databases is one of the most important uses of computers toda to Darabunslines use databases to handle billions of passenger reservations per year. The 5,724 hosn in the United States utilize databases to document the emergency department visits o 136 million patients per year. Banks in the United States employ databases to monitor billion credit cards Although databases vary considerably in size and complexity, mos them adhere to the fundamental principles of design discussed in this chapter. That is are composed of a collection of related tables A table is a rectangular array of data. Table 10.1 provides information about large c Each column of the table is called a field. (The third column gives the 2014 population millions and the fourth column the projected 2030 population in millions.) The names the fields are name, country, pop 2014, and pop 2030. Each row, called a record, containe same type of information as every other row. Also, the pieces of information in each are related because they all apply to a specific city. Table 10.2, Countries, has three field, and ten records TABLE 10.1 Cities country pop2014 pop2030 17.0 19.1 36.1 27.4 23.9 27.8 19.9 23.4 30.8 37.2 Buenos Aires 14.8 25.0 17.0 0.8 20.7 18.6 20.8 23.0 37.8 India Delhi Dhaka Mexico City Bangladesh Mexico India USA Brazil China pan New York Sao Paulc Shanghai Tokyo Note The population figures are for "urban aglomerations that is, contiguous densely popaulead urban areas. TABLE 10.2 pop2014 41.8 166.3 202.7 1355.7 1236.3 253.6 127.1 19.7 196.2 318.9 monetaryUnit Argentina Bangladesh Brazil China India Indonesia taka yen peso Pakistan USA dollar Note: China's currency is also known as the "yuan" or the "yuan renminbi