【正文】 e 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: theParadox. 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: data constraints may be changed。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以外。. . . .第一章： What is the purpose of a database?數(shù)據(jù)庫的目的The purpose of a database is to help people track(跟蹤監(jiān)測) of things. What is the most monly used type of database?最常見的數(shù)據(jù)庫類型The most monly used type of database is the relational database. Give an example of two related tables other than the example used in this book. Use the STUDENT and GRADE tables in Figure 13 as an example pattern(模式) for your tables. Name the tables and columns using the conventions in this ，參考13Answer:Query1：學(xué)生信息StudentNumberLastNameFirstNameEmailAddress1CookieSam12342LaraMarcia12453HarrisLou24534GreeneGrace25635SmithAnna4345Query2：宿舍信息StudentNumberRoomNumberRoomInformationRent11512310002336331100344466120042245411005544541300 For the tables you created in Review Question , what are the primary keys of each table? Do you think that any of these primary keys could be surrogate(代理) keys?每張表的主碼？這些主碼可以是代理碼嗎？Query1: StudentNumberQuery2: StudentNumber, RoomNumberYes, both. Explain how the two tables you provided in Review Question are related. Which table contains the foreign key, and what is the foreign key?The primary key of Q1 were added to the Q2 with a primary key of StudentNumber to uniquely identify each row.In Q2 StudentNumber and RoomNumber each now serves as a foreign key. Show your two tables from Review Question without the columns that represent the relationships. Explain how the value of your two tables is diminished(減少) without the ，解釋沒有關(guān)系的表的value如何減少？ Define the terms data and information. Explain how the two terms ,解釋它倆的不同。s work may interfere with other39。 relationships may be altered。R:base, a server receives a request from a user, processes the request, and then forgets about the user and the request. Many database interactions are multistage. A customer views products, adds one or more to a shopping cart, views more products, adds more to the shopping cart, and eventually checks out. A stateless protocol cannot be used for such applications. What is an open source DBMS product? Which of the five DBMS products that you named in answering Review Question is historically an open source DBMS product?（什么是一個開源的數(shù)據(jù)庫管理系統(tǒng)產(chǎn)品？）ANSWER: 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:newsupportLanguagearelanguagehasneededandusemanycantoprocessing.SQLapplicationembedpages,useandYouexecutefromother你可以在許多不同的方式使用SQL語句。你還可以執(zhí)行SQL語句直接從Visual Studio .NET等開發(fā)工具。forwhichoflanguageareinserting,data. What does DDL stand for? What are DDL statements?ANSWER:DataisSQL.(DDL)usedrelationships, What is the SQL SELECT/FROM/WHERE framework?ANSWER:formusesframework.framework:SELECTcolumnslistedresults.SQLwhichbequery.SQLwhichbequery?FROM子句中指定的SQL表用于查詢。同上一題懵逼。 Write an SQL statement to display unique WarehouseIDs.SELECT WarehouseIDsFROM WAREHOUSE。 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。 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, andQuantityOnHand for all products having a QuantityOnHand greater than 1 and lessthan 10. Do not use the BETWEEN keyword.SELECT SKU, SKU_Description,WarehouseID QuantityOnHandFROM INVENTORY WHERE QuantityOnHand 1 AND QuantityOnHand 10ORDER BY WarehouseID DESC, SKU ASC。.SELECT DISTINCT SKU, SKU_DescriptionFROM INVENTORY WHERE SKU_description LIKE 39。.SELECT DISTINCT SKU, SKU_DescriptionFROM INVENTORYWHERE SKU_description LIKE 39。 in the third position from the left in SKU_Description.SELECT DISTINCT SKU, SKU_DescriptionFROM INVENTORY WHERE SKU_description LIKE 39