【正文】 s of applications ponents that create and process forms, reports, and queries. What is the name of the DBMS engine within Microsoft Access? Why do we rarely hear about that engine?The current DBMS engine within Microsoft Access is called the Access Database Engine (ADE). ADE is a Microsoft Office specific version of Microsoft’s Joint Engine Technology (JET or Jet) database engine. But you seldom hear about Jet because Microsoft does not sell Jet as a separate product.ADE是Jet引擎的一個(gè)版本，很少聽說是因?yàn)镴et不是一個(gè)獨(dú)立銷售的產(chǎn)品 Why does Microsoft Access hide important database technology?Because it is an effective strategy for beginners working on small databases Why would someone choose to replace the native Microsoft Access DBMS engine with SQL Server?You would do this if you wanted to process a large database or if you needed the advanced functions and features of Microsoft SQL Server. Name the ponents of an enterpriseclass database system. Name and describe the four categories of database applications that would use an enterpriseclass database system. client/server applications：the application program is a client that connects to a database server. Client/server applications often are written in programming languages such as , C++, or Java.emerce applications：run on a Web serverreporting applications：publish the results of database queries on a corporate portal or other Web site.XML Web services applications：use a bination of the XML markup language and other standards to enable programtoprogram munication. How do database applications read and write database data?All of these database applications get and put database data by sending SQL statements to the DBMS. How do database applications read and write database data?(數(shù)據(jù)庫應(yīng)用程序是如何讀寫數(shù)據(jù)庫數(shù)據(jù)的？ PPT: First class P23)Answer：the application program first queries the DBMS for data (again using SQL). The application then formats the query results as a report. （首先在DBMS中使用SQL查詢數(shù)據(jù)，然后將查詢結(jié)果作為報(bào)表顯示） Name the five DBMS products described in this chapter, and pare them in terms of power, features, and difficulty of use.（列出本章中5個(gè)DBMS產(chǎn)品，并比較他們的功效、特性和使用的難易程度 PPT：second class p39）Answer: Microsoft Access, MySQL, SQL Server, DB2, and Oracle Database.(這已經(jīng)是按比較順序來的了) List several consequences of a poorly designed database.（列出幾個(gè)數(shù)據(jù)庫設(shè)計(jì)不良的后果）Answer：（1）They may require application developers to write overly plex and contrived SQL to get –wanted data.（開發(fā)人員需要編寫過于復(fù)雜的SQL來獲取數(shù)據(jù)）（2）they may be difficult to adapt to new and changing requirements.（很難適應(yīng)新的不斷變化的需求）（3）they may fail in some other way.（或其他） Explain two ways that a database can be designed from existing data.（解釋兩種可以用現(xiàn)有數(shù)據(jù)設(shè)計(jì)的數(shù)據(jù)庫 PPT: second class p13）Answer：（1） The first type of database design involves databases that are constructed from existing（2）A second way that databases are designed is for the development of new information systems.（ p17） What is a data warehouse? What is a data mart?（什么是數(shù)據(jù)倉庫？什么是數(shù)據(jù)集市）Answer：data from an operational database, such as a CRM or ERP database, may be copied into a new database that will be used only for studies and analysis. Such databases are used in facilities called data warehouses and data marts. (筆記) Describe the general process of designing a database for a new information system.(描述為一個(gè)新的信息斯通設(shè)計(jì)數(shù)據(jù)庫的一般過程)Answer：（1）create data model from application requirements ( 2)transform data model into database design (PPT: second class p12) Explain two ways that databases can be redesigned.(解釋兩種數(shù)據(jù)庫重設(shè)計(jì)的方式 PPT： third class p19或12)Answer：(1) In the first, a database is adapted to new or changing requirements. This process sometimes is called database migration. In the migration process, tables may be created, modified, or removed。 dBase, HTTP is a stateless protocol。DBMS 答案待商榷 What has been the response of panies that sell proprietary DBMS products to the open source DBMS products? Include two examples in your answer.ANSWER:theSQLMarkuptheremonitstatementsanddatacaninYoudirectlyforembedclient/servercanWebcanreportingprograms.directlyand百度翻譯：它被稱為一個(gè)數(shù)據(jù)子語言，因?yàn)樗挥心切﹦?chuàng)建與數(shù)據(jù)庫數(shù)據(jù)處理和元數(shù)據(jù)需要的報(bào)表。您可以將它們嵌入到網(wǎng)頁中，并且您可以使用它們來報(bào)告和數(shù)據(jù)提取程序。standLanguage,categorymanipulationwhichquerying,deletingforwhichoflanguagearetables,structuresbasicqueriesSELECT/FROM/WHEREthisSQLwhichbequeryThespecifiestotheThespecifiestothe在這個(gè)框架中：?SQL SELECT子句中指定的列將查詢結(jié)果中的列。答案寫的也有點(diǎn)奇怪，不是很懂）ANSWER: Every time you process a form, create a report, or run a query Microsoft Access generates SQL and sends that SQL to Microsoft Access’ internal ADE DBMS engine. To do more than elementary database processing, you need to uncover the SQL hidden by Microsoft Access. Further, once you know SQL, you will find it easier to write a query statement in SQL rather than fight with the graphical forms, buttons. Explain how enterpriseclass（企業(yè)級）DBMS products use SQL.（ppt 第五課應(yīng)該都是。Use only the Inventory table to answer Review Questions through :SELECT 查找列（去除重復(fù)用DISTINCT）FROM 表名WHERE 從行的角度選擇滿足條件的行GROUP BY 分組HAVING 從分組的角度選擇滿足條件的分組ORDER BY 根據(jù)指定的列對結(jié)果集進(jìn)行排序，默認(rèn)升序，降序需要使用DESC關(guān)鍵字 Write an SQL statement to display SKU and SKU_Description.SELECT SKU,SKU_DescriptionFROM INVENTORY。 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。 Write an SQL statement to display the SKU, SKU_Description, and WarehouseID for products that have a QuantityOnHand equal to 0. Sort the results in ascending order by WarehouseID.SELECT SKU,SKU_Description,WarehouseIDFROM INVENTORYWHERE QuantityOnHand=0ORDER BY WarehouseID。 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, andQuantityOnHand for all products having a QuantityOnHand greater than 1