【正文】 isquerythethe Write an SQL statement to display all of the columns without using the SQL asterisk(*) wildcard character.SELECT WarehouseID, WarehouseCity, WarehouseState, Manager, SquareFeetFROM WAREHOUSE.SELECT ,SKU_Description,QuantityOnHand,QuantityOnHandFROM INVENTORY。% Climb %39。Halfdome39。）ANSWER: Enterpriseclass DBMSs such as Microsoft SQL Server 2008 R2, Oracle Database 11g, Oracle MySQL , and IBM DB2 require that you know SQL. With these products, all data manipulation is expressed using SQL.The Cape Codd Outdoor Sports sale extraction database has been modified to includetwo additional tables, the Inventory table and the Warehouse table. The tableschemas for these tables, together with the Retail Order, Order Item, and SKU_Data tables, are as follows:RETAIL_ORDER (OrderNumber, StoreNumber, StoreZip, OrderMonth, OrderYear,OrderTotal)ORDER_ITEM (OrderNumber, SKU, Quantity, Price, ExtendedPrice)SKU_DATA (SKU, SKU_Description, Department, Buyer)WAREHOUSE (WarehouseID, WarehouseCity, WarehouseState, Manager, Squarefeet)INVENTORY (WarehouseID, SKU, SKU_Description, QuantityOnHand,QuantityOnOrder)The five tables in the revised Cape Codd database schema are shown in Figure224. The column characteristics for the Warehouse table are shown in Figure 225,and the column characteristics for the Inventory table are shown in Figure 226.The data for the Warehouse table are shown in Figure 227, and the data for theInventory table are shown in Figure 228.If at all possible, you should run your SQL solutions to the following questionsagainst an actual database. a Microsoft access database named isavailable on our Web site () that contains all the tables and data for the Cape Codd Outdoor Sports sales data extract database. alsoavailable on our Web site are SQL scripts for creating and populating the tables for theCape Codd database in Microsoft SQL Server, Oracle Database, and MySQL. There is an intentional flaw in the design of the INVENTORY table used in these exercises. This flaw was purposely included in the INVENTORY tables so you can answer some of the following questions using only that table. Compare the SKU and INVENTORY tables, and determine what design flaw is included in , why did we include it?比較SKU和INVENTORY表，INVENTORY中有個設(shè)計缺陷，說明為什么會產(chǎn)生這個缺陷不懂。rowstablesarethefordefinition(DML) What does DML stand for? What are DML statements?ANSWER:SQLandYouSQLonlyforParadox. What happened to the products in your answer to Review Question ?ANSWER: dBase was the most successful of the early products, but another product, R:base, was the first to implement true relational algebra and other operations on the PC. Later, another relational DBMS product named Paradox was developed for personal puters. Eventually, Paradox was acquired by Borland. Microsoft Access killed R:base and Paradox, and then Microsoft bought a dBase “workalike” product called FoxPro and used it to eliminate dBase What was the purpose of OODBMS products? State two reasons that OODBMS products were not successful.（面向?qū)ο髷?shù)據(jù)庫管理系統(tǒng)產(chǎn)品的目的是什么？陳述OODBMS產(chǎn)品均未成功的兩個原因）ANSWER:s work may interfere with other39。 One interesting oute of the emergence of open source DBMS products is that panies that typically sell proprietary (closed source) DBMS products now offer free versions of their products. For example, Microsoft now offers SQL Server 2008 R2 Express (. /express/Database), and Oracle Corporation makes its Oracle Database 10g Express Edition available for free. What is XML? What ment did Bill Gates make regarding XML?（什么是XML？比爾蓋茨對此做了什么評論？）ANSWER:arecanapplicationandotherwhichinserting,SQL. What is the SQL SELECT/FROM/WHERE framework?ANSWER:framework:results.query.query Write an SQL statement to display the SKU and SKU_Description for products having QuantityOnHand equal to 0.SELECT SKU,SKU_DescriptionFROM INVENTORYWHERE QuantityOnHand=0。 in the third position from the left in SKU_Description.SELECT DISTINCT SKU, SKU_DescriptionFROM INVENTORY WHERE SKU_description LIKE 39。.SELECT DISTINCT SKU, SKU_DescriptionFROM INVENTORY WHERE SKU_description LIKE 39。同上一題懵逼。whichwhichcolumnsusesusedDatalanguage你還可以執(zhí)行SQL語句直接從Visual Studio .NET等開發(fā)工具。executepages,processing.usehassupportR:base,s. Give an example of a database application that has hundreds of users and a very large and plicated database. Use an example other than one in Figure 15.舉一個有成百上千個用戶和一個龐大而復(fù)雜數(shù)據(jù)庫的數(shù)據(jù)庫應(yīng)用，除表15以外。 XML means Extensible Markup Language. Bill Gates said that “XML is the linguafranca of the Internet Age.” What is the NoSQL movement? Name two applications that rely on NoSQL databases.ANSWER: It’s the work is really on databases are often based on XML. Two applications that rely on NoSQLdatabases: Facebook and Twitter. 第二章 What is a business intelligence (BI) system?ANSWER: Application refers to the collection of mercial information, the integration, analysis and the technical reports. What is an adhoc query?ANSWER: adhoc SQL queries is how SQL is used to “ask questions” about the data in the database. What does SQL stand for, and what is SQL?ANSWER: SQL stand for Structured Quqery Language. SQL is not a plete programming language, like Java or C. Instead, it is called a data sublanguage, because it has only those statements needed for creating and processing database data and metadata. What does SKU stand for? What is an SKU?ANSWER: SKU stand for stockkeeping unit. SKU is a unique identifier for each particular item that Cape Codd sells或SKU is an integer value that identifies a particular product sold by Cape Codd. Summarize how data were altered and filtered in creating the Cape Codd data extraction.ANSWER: the ORDER_ITEM table stores an extract of the items purchased in each order. There