, SOLUTIONS TO REVIEW QUESTIONS
AND EXERCISES
FOR PART 1 – BACKGROUND (CHAPTERS 1 – 3)
,Database Systems: Instructor’s Guide - Part III
Solutions to Review Questions and Exercises
Chapter 1 Introduction to Databases............................................................................................................3
Chapter 2 Database Environment................................................................................................................7
Chapter 3 Database Architectures and the Web.........................................................................................11
2
, Database Systems: Instructor’s Guide - Part III
Chapter 1 Introduction to Databases
Review Questions
1.1 List four government sectors in your country that use database systems.
Some examples could be:
The Health sector, to keep records about health services, staffing, disease and medical
histories;
The Education sector, to keep records about schools, students, teachers, and academic
performance;
Immigration, to keep records about citizens, passports, and other national IDs;
Police to keep records about staff, crimes and criminals.
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 users from seeing certain
data. See also Section 1.3.3.
1.3 Describe the role of database management systems (DBMS) in the database approach. Discuss
why knowledge of DBMS is important for database administrators.
Section 1.3.2 describes the vital role that DBMS plays in the database approach. Surfice to say it,
controls all actions performed against data and the database.
As described in section 1.4.1, DBAs are responsible for physical realization of the database
including the physical database design and implementation of security controls, and other aspects
of database management and administration. It is therefore crucial for the DBA to understand the
key aspects of the specified DBMS they have to work with.
3
AND EXERCISES
FOR PART 1 – BACKGROUND (CHAPTERS 1 – 3)
,Database Systems: Instructor’s Guide - Part III
Solutions to Review Questions and Exercises
Chapter 1 Introduction to Databases............................................................................................................3
Chapter 2 Database Environment................................................................................................................7
Chapter 3 Database Architectures and the Web.........................................................................................11
2
, Database Systems: Instructor’s Guide - Part III
Chapter 1 Introduction to Databases
Review Questions
1.1 List four government sectors in your country that use database systems.
Some examples could be:
The Health sector, to keep records about health services, staffing, disease and medical
histories;
The Education sector, to keep records about schools, students, teachers, and academic
performance;
Immigration, to keep records about citizens, passports, and other national IDs;
Police to keep records about staff, crimes and criminals.
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 users from seeing certain
data. See also Section 1.3.3.
1.3 Describe the role of database management systems (DBMS) in the database approach. Discuss
why knowledge of DBMS is important for database administrators.
Section 1.3.2 describes the vital role that DBMS plays in the database approach. Surfice to say it,
controls all actions performed against data and the database.
As described in section 1.4.1, DBAs are responsible for physical realization of the database
including the physical database design and implementation of security controls, and other aspects
of database management and administration. It is therefore crucial for the DBA to understand the
key aspects of the specified DBMS they have to work with.
3
