武汉理工大学-数据库复习题(完整版含答案).doc_武汉理工大学理工智课数据库系统原理

武汉理工大学

需积分: 49 198 浏览量更新于2023-03-03 评论 5 收藏 463KB DOC 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

武汉理工大学数据库复习题（完整版含答案）

1. Questions

1.1 What is the purpose of a database?

ANSWER：The purpose of a database is to help people track of things.

1.2 What is the most commonly used type of database?

ANSWER: the most commonly used type of database is the relational database.

1.7 Define the terms data and information. Explain how the two terms differ.

ANSWER: Data are recorded facts and numbers.

we can now define information as:

 Knowledge derived from data.

 Data presented in a meaningful context.

 Data processed by summing, ordering, averaging, grouping, comparing or

other similar operations.

1.10 What problem can occur when a database is processed by more than one

user?

ANSWER: When more than one user employs a database application, these is

always the chance that one user's work may interfere with other's.

1.12 What is the purpose of the largest databases at e-commerce companies such

as Amazon.com?

ANSWER: The largest databases are those that track customer browser behavior.

（用来记录用户的浏览行为的。）

1.13 How do the e-commerce companies use these databases? .

ANSWER: E-commerce companies use Web activity databases to determine

which items on a Web page are popular and successful and which are not.

1.14 How do digital dashboard and data mining applications differ from

transaction processing applications?

ANSWER: Digital dashboards and other reporting systems assess past and

current performance. Data mining applications predict future performance.

1.15 Explain why a small database is not necessarily simpler than a large one.

What are the functions of application programs?

ANSWER: Supposed we have 2 company 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, and the same level of complexity 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.

1.43 Summarize the various ways that you might work with database technology.

ANSWER: In our career, we may work with database technology as either a user

or as a database administrator.

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.

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.

1.44 What job functions does a knowledge worker perform?

ANSWER: preparing reports, mining data, and doing other types of data analysis.

1.45 What job functions does a database administrator perform?

ANSWER: designing, constructing, and managing the database itself.

1.47 What need drove the development of the first database technology?

ANSWER: The need for data integration drove the development of the first

database technology.

1.48 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 subcommittee developed a standard data model that came to bear its name—

the CODASYL DBTG model. It was an unnecessarily complicated model. This data

relationship used data structures called networks.

1.49 Who was E. F. Codd?

ANSWER: E.F.Codd was a little-known IBM engineer published a paper in the

Communications of the ACM3 in which he applied the concepts of a branch of

mathematics called relational algebra to the problem of “shared data banks,” as

databases were then known. The results of this work are now the relational model for

databases, and all relational database DBMS products are built on this model.

1.50 What were the early objections to the relational model?

1.51 Name two early relational DBMS products.

ANSWER: Oracle Database, DB2.

剩余23页未读，继续阅读

天宝666

粉丝: 0
资源: 1

会员权益专享

武汉理工大学-数据库复习题(完整版含答案).doc

评论0

会员权益专享

最新资源

武汉理工大学-数据库复习题(完整版含答案).doc

评论0

数据库系统原理期末复习试题

Getclass.py爬取武汉理工大学课表

离散数学 集合的并交差笛卡尔积

太原理工大学《机械设计》期末考试复习题(含答案).pdf

大学生《数字电路与逻辑设计》期末6套复习题(含答案).pdf

数据挖掘导论 完整版 pang-ningtan 复习习题参考答案解答讲解解析

计算机网络(谢希仁)期末复习题及答案.pdf

全国大学生物理竞赛历年考试试题含答案.pdf

数据库系统概论期中复习题

北邮-2021-软件工程-期末复习.rar

天津理工大学操作系统期中考试复习题.pd

2022年信息技术基础知识考试题库500题(含答案).pdf

大一的java考试试题_华南理工大学大一JAVA复习题

桂林理工大学 计算机网络

华南理工大学《操作系统》期末复习资料(超全).pdf

数据库 王珊 试题及答案解析 pdf

数据库系统概论期末复习笔记

地理信息系统数据库（张新长）复习提纲

oracle面试复习

plc区别于微型计算机的最大特点,有答案的plc复习题库0.doc

会员权益专享

最新资源

离散数学集合的并交差笛卡尔积

数据挖掘导论完整版 pang-ningtan 复习习题参考答案解答讲解解析

桂林理工大学计算机网络

数据库王珊试题及答案解析 pdf