![](https://csdnimg.cn/release/download_crawler_static/86290339/bg1.jpg)
C H A P T E R
1
Introdution
Solutions for the Pratie Exerises of Chapter 1
Pratie Exerises
1.1
Answer:
Two disadvantages assoiated with database systems are listed below.
a. Setup of the dat abase system requires more knowledge, money, skills, and
time.
b. The omplexit y of the database may result in poor performane.
1.2
Answer:
a. Exeuting an ation in the
DDL
results in t he reation of an objet in the
database; in ontrast, a programming language type delaration is simply
an abstration used in the prog ram.
b. Database
DDL
s allow onsisteny onstraints to be speied, whih pro-
gramming language type systems generally do not allow. These inlude
domain onstraints and referential integr ity onstraints.
. Database
DDL
s suppor t author ization, giving dierent aess rights to
dierent users. Programming language type systems do not provide suh
protetion (at best, they protet attributes in a lass from being aessed
by methods in another lass).
d. Programming language type systems are usually muh riher than the
SQL
type system. Most dat abases suppor t only basi t ypes suh as dierent
types of numbers and strings, alt hough some databases do suppor t some
omplex types suh as ar rays and objets.
1
评论0