Solutions Manual

SOLUTIONS TO REVIEW QUESTIONS

AND EXERCISES

FOR PART 1 – BACKGROUND (CHAPTERS 1 – 3)

Solutions to Review Questions and Exercises

Chapter 1 Introduction to Databases 3

Chapter 2 Database Environment 6

Chapter 3 Database Architectures and the Web…………………………………………………………………………8

Chapter 1 Introduction to Databases

Review Questions

1.1 List four examples of database systems other than those listed in Section 1.1.

Some examples could be:

• A system that maintains component part details for a car manufacturer;

• An advertising company keeping details of all clients and adverts placed with them;

• A training company keeping course information and participants’ details;

• An organization maintaining all sales order information.

1.2 Discuss each of the following terms:

Data For end users, this constitutes all the different values connected with the various objects/entities that are of concern to them. See also Section 1.3.4.

Database See Section 1.3.1

Database Management System See Section 1.3.2

Database Application Program See Section 1.3.3

Data Independence This is essentially the separation of underlying file structures from the programs that operate on them, also called program-data independence. See also Sections 1.2.2 and 1.3.1.

Security The protection of the database from unauthorized users, which may involve passwords and access restrictions. See also Section 1.6.

Integrity The maintenance of the validity and consistency of the database by use of particular constraints that are applied to the data. See also Section 1.6.

Views These present only a subset of the database that is of particular interest to a user. Views can be customized, for example, field names may change, and they also provide a level of security preventing...