【正文】 rnal design. Name three early personal puter DBMS products.ANSWER:Answer: Selection lesson system選課系統(tǒng) What is the purpose of the largest databases at emerce panies such as ?像亞馬遜這樣的電商公司有著最大的數(shù)據(jù)庫的目的是什么？Answer: The largest database are those that track customer browser behavior. (用來記錄用戶的瀏覽行為) How do the emerce panies use the databases discussed in Review Question ?電商公司如何使用數(shù)據(jù)庫？Answer: Emerce panies use Web activity databases to determine which items on a Web page are popular and successful and which are not. How do digital dashboard and data mining applications differ from transaction processing applications?數(shù)字儀表板和數(shù)據(jù)挖掘應(yīng)用程序在事務(wù)處理應(yīng)用上有何不同？Answer: Digital dashboard and other reporting systems assess past and current performance. Data mining applications predict future performance. Explain why a small database is not necessarily simpler than a large one.解釋為什么一個小的數(shù)據(jù)庫不一定比大的數(shù)據(jù)庫簡單？Answer: Supposed we have 2 pany which are different in sales but have similar database. Though the difference in sale, both have the same kinds of data, about the same number of tables of data, about the same level of plexity in data relationships. Only the amount of data varies from one to the other. Thus, although a database for a small business may be small, it is not necessarily simple. (一句話，麻雀雖小五臟俱全) Explain the ponents in Figure A database system is defined to consist of five ponents:users, the database application, Structured Query Language (SQL), the database management system (DBMS), and the database.a. Users employ a database application to keep track of things. They use forms to read, enter, and query data, and they produce reports to convey information.b. A database application is a set of one or more puter programs that serves as an intermediary between the user and the DBMS.c. Structured Query Language (SQL), an internationally recognized standard language that is understood by all mercial DBMS products, in database processing and the fact that database applications typically send SQL statements to the DBMS for processing.d. The database management system (DBMS) is a puter program used to create, process, and administer the database.e. The database is a collection of related tables and other structures. What are the functions of application programs?應(yīng)用程序的功能是什么？Answer: ? Create and process forms? Process user queries? Create and process reports? Execute application logic? Control application What is Structured Query Language (SQL), and why is it important?Structured Query Language (SQL) is an internationally recognized standard language. Because it nearly can be understood by all mercial DBMS products, in database processing, database applications typically send SQL statements to the DBMS for processing. (在數(shù)據(jù)庫方法中，數(shù)據(jù)庫應(yīng)用向DBMS發(fā)送SQL語句) What does DBMS stand for?Database management system What are the functions of the DBMS?? Create database、Create tables? 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 (備份與恢復(fù)) 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ù)庫組件。Answer: Data are recorded facts and numbers.We can define information as:Knowledge derived from data.Data presented in a meaningful context.Data processed by summing, ordering, averaging, grouping, paring or other similar operations. Give an example of information that could be determined using the two tables you provided in your answer to Review Question .Anna Smith lives in 4454 which the rent is 1300. Give examples of a singleuser database application and a multiuser database application other than the ones shown in Figure ，單用戶 和 多用戶的數(shù)據(jù)庫應(yīng)用，除表15之外。singleuser: Cloud Servicemultiuser: File Management System What problem can occur when a database is processed by more than one user? 當(dāng)數(shù)據(jù)庫被不止一個用戶處理會導(dǎo)致什么問題？Answer: When more than one user employs a database application, these is always the chance that one user39。? Indexes? Stored procedures? Triggers? Security data? Backup/recovery data Is Microsoft Access a DBMS? Why or why not?No, Microsoft Access is not just a DBMS. Because it is a personal database system: a DBMS plus an application generator. Although Microsoft Access contains a DBMS engine that creates, processes, and administers the database, it also contains form, report, and query ponents that are the Microsoft Access application generator.(應(yīng)用程序生成器)，太偏太細(xì)，感覺不會考 Describe the ponents shown in Figure 115.Components of a Microsoft Access Database SystemMicrosoft Access contains a DBMS engine that creates, processes, and administers the database, it also contains form, report, and query ponents that are the Microsoft Access application generator. What is the function of the application generator in Microsoft Access?The application generator consist