【正文】 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。 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。同上一題懵逼。querywhichquery.whichresults.columnsframework:uses What is the SQL SELECT/FROM/WHERE framework?ANSWER:usedSQL.Datainserting,languagewhich你還可以執(zhí)行SQL語句直接從Visual Studio .NET等開發(fā)工具。otherexecuteandpages,applicationprocessing.canusehasaresupport 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:R:base,s work may interfere with other39。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.舉一個有成百上千個用戶和一個龐大而復雜數(shù)據(jù)庫的數(shù)據(jù)庫應用，除表15以外。Paradox. 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.（面向對象數(shù)據(jù)庫管理系統(tǒng)產(chǎn)品的目的是什么？陳述OODBMS產(chǎn)品均未成功的兩個原因）ANSWER: 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 is one row in the table for each item in an order, and this item is identified by its SKU.The OrderNumber Column in ORDER_ITEM relates each row in ORDER_ITEM to the corresponding OrderNumber in the RETAIL_ORDER table. SKU identifies the actual item purchased by its stockkeeping unit number. Further, the SKU column in ORDER_ITEM relates each row in ORDER_ITEM to its corresponding SKU in the SKU_DATA table Explain, in general terms, the relationships among the RETAIL_ORDER, ORDER_ITEM,and SKU_DATA tables.ANSWER: The RETAIL_ORDER table has data about each retail sales order, the ORDER_ITEM table has data about each item in an order, and the SKU_DATA table has data about each stockkeeping unit (SKU) Summarize the background of SQL.ANSWER: SQL was developed by the IBM Corporation in the late 1970s. It was endorsed as a national standard by the American National Standards Institute (ANSI) in 1986 and by the International Organization for Standardization (ISO). What is SQL92? How does it relate to the SQL statements in this chapter?ANSWER: Subsequent versions of SQL were adopted in 1989 and 1992. The 1992 version is sometimes referred to as SQL92, or sometimes as ANSI92 SQL. 缺少第二問答案 What features have been added to SQL in versions subsequent to the SQL92?什么樣的功能已被添加到SQL版本SQL92后續(xù)ANSWER:formanyonlyprocessingSQLsubmitYouprograms.anddataSQLdevelopment What does DML stand for? What are DML statements?ANSWER:is(DML)modifying,definitionDataforthe?aretablesrowsresults.）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 characte