【正文】 es? Create supporting structures ? Read database data? Modify (修改)(insert, update, or delete) database data ? Maintain database structures? Enforce rules? Control concurrency(并發(fā)控制)? Provide security? Perform backup and recovery (備份與恢復) Name three vendors of DBMS products.MySQL，Microsoft SQL Server，IBM Define the term database.(數(shù)據(jù)庫一詞的定義)A database is a selfdescribing collection of integrated tables. Why is a database considered to be selfdescribing?A database is selfdescribing because it contains a description of itself. Thus, databases contain not only tables of user data, but also tables of data that describe that user data. What is metadata(元數(shù)據(jù))? How does this term pertain(屬于) to a database?databases contain not only tables of user data, but also tables of data that describe that user data. Such descriptive data is called metadata because it is data about data.(元數(shù)據(jù)是描述數(shù)據(jù)的數(shù)據(jù)) What advantage is there in storing metadata in tables?You can examine(調(diào)查) metadata to determine if particular tables, columns, indexes, or other structures exist in a database.可以通過調(diào)查元數(shù)據(jù)得知某些特定的結(jié)構(gòu)是否存在于數(shù)據(jù)庫中 List the ponents of a database other than user tables and metadata. 除了用戶表和元數(shù)據(jù)以外的其他數(shù)據(jù)庫組件。 These products were designed to make it easy to store the data encapsulated in OOP objectsThere were two reasons for their lack of acceptance. First, using an OODBMS required that the relational data be converted from relational format to objectoriented format. By the time OODBMS emerged, billions upon billions of bytes of data were stored in relational format in organizational databases. No pany was willing to undergo the expensive travail of converting those databases to be able to use the new OODBMS. Second, objectoriented databases had no substantial advantage over relational databases for most mercial database processing. As you will see in the next chapter, SQL is not object oriented. But it works, and thousands of developers have created programs that use it. Without a demonstrable advantage over relational databases, no organization was willing to take on the task of converting their data to OODBMS format. What characteristic of HTTP was a problem for database processing applications?ANSWER:AllExtensibleotherthosedatabasestatementsthemcanYouyouextractionstatementstools.DMLastatements,andlanguage,definitioncreatingTheSQLTheto?are?areSQL查詢的基本形式采用SQL選擇/從/框架。 Write an SQL statement to display SKU_Description and SKU.SELECT SKU_Description,SKUFROM INVENTORY。 Write an SQL statement to display the SKU, SKU_Description, and WarehouseID for products that have a QuantityOnHand greater than 0. Sort the results in descendingorder by WarehouseID and in ascending order by SKU.SELECT SKU, SKU_Description,WarehouseID FROM INVENTORY WHERE QuantityOnHand 0 ORDER BY WarehouseID DESC, SKU ASC。 Write an SQL statement to show a unique SKU and SKU_Description for all productshaving a description that includes the word 39。 Write an SQL statement that uses all of the SQL builtin functions on theQuantityOnHand column. Include meaningful column names in the result.builtin functions: SUM() AVG() MIN() MAX() COUNT()SELECT SUM(QuantityOnHand) AS QuantitySUM, FROM INVENTORY。 Write an SQL statement to show a unique SKU and SKU_Description for all productshaving a 39。 Write an SQL statement to show a unique SKU and SKU_Description for all productshaving an SKU description starting with 39。 Write an SQL statement to display all of the columns using the SQL asterisk (*) wildcard character.SELECT *FROM WAREHOUSE.SELECT *FROM INVENTORY。（ ） Explain how Microsoft Access uses SQL.（ppt：第四課 p4之后 不造咋概括。inclauseinclausethespecifiesInSQLotherwhichcategorystandforDataManipulation您可以嵌入SQL語句為客戶端/服務器應用程序。caninintointoDBMSways.YoucreatingBecauseandofMySQL and so forth.(2) The second type of database redesign involves the integration of two or more databases. This type of redesign is mon when adapting or removing legacy systems. It is also mon for enterprise application integration, when two or more previously separate information systems are adapted to work with each other. What does the term database migration mean?(數(shù)據(jù)庫遷移是什么意思)Answer：The process of a database is adapted to new or changing requirements. Summarize the various ways that you might work with database technology.（總結(jié)你可能使用數(shù)據(jù)庫技術(shù)的不同方式）Answer：In our career, we may work with database technology as either a user or as a database administrator. （1）As a user, you may be a knowledge worker who prepares reports, mines data, and does other types of data analysis or you may be a programmer who writes applications that process the database. （作為用戶時）（2）Alternatively, you might be a database administrator who designs, constructs, and manages the database itself. Users are primarily concerned with constructing SQL statements to get and put the data they want. Database administrators are primarily concerned with the management of the database.（作為數(shù)據(jù)庫管理員時） What job functions does a knowledge worker perform?（知識工作者（意會……）工作職能是什么）Answer：preparing reports, mining data, and doing other types of data analysis. What job functions does a database administrator perform?（數(shù)據(jù)庫管理員的工作職能是什么）Answer：designing, constructing, and managing the database itself. Explain the meaning of the domains（域） in Figure 123.（解釋圖中的域的意思）（這題找不到= =）Answer：Knowledge workersProgrammers Database administrators What need drove the development of the first database technology?Answer：The need for data integration drove the development of the first database technology. What are Data Language/I and CODASYL DBTG?Answer：Data Language/I (DL/I) used hierarchies or trees (see Appendix G) to represent relationships.This submittee developed a standard data model that came to bear