Database Systems, Introduction to
Databases and Data Warehouses,
2nd Edition by Nenad Jukic
Complete Chapter Solutions Manual
are included (Ch 1 to 11)
** Immediate Download
** Swift Response
** All Chapters included
,Table of Contents are given below
Chapter 1: Introduction
Chapter 2: Database Requirements and ER Modeling
Chapter 3: Relational Database Modeling
Chapter 4: Update Operations, Update Anomalies, and Normalization
Chapter 5: SQL
Chapter 6: Database Implementation and Use
Chapter 7: Data Warehousing Concepts
Chapter 8: Data Warehouse Modeling
Chapter 9: Data Warehouse Implementation and Use
Chapter 10: Big Data and Data Lakes
Chapter 11: Overview of DBMS Functionalities and Database
Administration
,Solutions Manual organized in reverse order, with the last chapter displayed first, to ensure that all
chapters are included in this document. (Complete Chapters included Ch11-1)
CHAPTER 11 – Overview of DBMS Functionalities and Database Administration
KEY CONCEPTS
In this chapter we give a concise overview of DBMS components and some of the most essential
database administration tasks. (Comprehensive coverage related to the functioning of database
software and hardware, database physical storage details, administration of database systems,
and other technical issues is beyond the scope of this book.)
The following topics related to DBMS functionalities and database administration are covered:
- DBMS Components
o Data Definition Component
o Data Manipulation Component
o Database Administration Component
o Application Generation Component
- Database Administration Overview
o Monitoring and Maintaining the Database System
o Securing the Database against Unauthorized Access
o Providing Database Backup and Recovery
o Ensuring Database Integrity
o Optimizing Database Performance
o Developing and Implementing Database Policies and Standards
- Data Dictionary
- View Materialization
- Query Optimization
IM Chapter 11 - Page 1
, Database Systems, Edition 2.0 (Jukic et. al.) Instructors Manual – Chapter 11
Chapter 11 - ANSWERS (Review Questions)
Q11.1 What are the four components of typical DBMS software?
Data Definition Component
Data Manipulation Component
Database Administration Component
Application Generation Component
Q11.2 What is the purpose of the DBMS data definition component?
The data definition component is used by database designers to create the infrastructure
components of the database, such as database tables and referential integrity constraints
connecting the created tables.
Q11.3 What is the purpose of the DBMS data manipulation component?
The data manipulation component allows the end users to insert, read, update, and delete
information in a database.
Q11.4 What is the purpose of the DBMS data administration component?
The database administration component is used to perform the technical, administrative, and
maintenance tasks of database systems, such as ensuring security, optimizing performance, and
providing backup and recovery.
Q11.5 What is the purpose of the DBMS application development component?
An application development component provides functionalities to the developers of front-end
applications. In some DBMS packages, this component is a part of the DBMS; in other packages,
it is available as an add-on.
Q11.6 What activities are encompassed by database administration?
Monitoring and Maintaining the Database System
Securing the Database against Unauthorized Access
Providing Database Backup and Recovery
Ensuring Database Integrity
Optimizing Database Performance
Developing and Implementing Database Policies and Standards
Q11.7 Give several examples of database system maintenance activities.
Monitoring the use and functioning of the database systems
Managing and upgrading the database software and hardware resources
Conducting upgrades to the structure of the database
IM Chapter 11 - Page 2
Databases and Data Warehouses,
2nd Edition by Nenad Jukic
Complete Chapter Solutions Manual
are included (Ch 1 to 11)
** Immediate Download
** Swift Response
** All Chapters included
,Table of Contents are given below
Chapter 1: Introduction
Chapter 2: Database Requirements and ER Modeling
Chapter 3: Relational Database Modeling
Chapter 4: Update Operations, Update Anomalies, and Normalization
Chapter 5: SQL
Chapter 6: Database Implementation and Use
Chapter 7: Data Warehousing Concepts
Chapter 8: Data Warehouse Modeling
Chapter 9: Data Warehouse Implementation and Use
Chapter 10: Big Data and Data Lakes
Chapter 11: Overview of DBMS Functionalities and Database
Administration
,Solutions Manual organized in reverse order, with the last chapter displayed first, to ensure that all
chapters are included in this document. (Complete Chapters included Ch11-1)
CHAPTER 11 – Overview of DBMS Functionalities and Database Administration
KEY CONCEPTS
In this chapter we give a concise overview of DBMS components and some of the most essential
database administration tasks. (Comprehensive coverage related to the functioning of database
software and hardware, database physical storage details, administration of database systems,
and other technical issues is beyond the scope of this book.)
The following topics related to DBMS functionalities and database administration are covered:
- DBMS Components
o Data Definition Component
o Data Manipulation Component
o Database Administration Component
o Application Generation Component
- Database Administration Overview
o Monitoring and Maintaining the Database System
o Securing the Database against Unauthorized Access
o Providing Database Backup and Recovery
o Ensuring Database Integrity
o Optimizing Database Performance
o Developing and Implementing Database Policies and Standards
- Data Dictionary
- View Materialization
- Query Optimization
IM Chapter 11 - Page 1
, Database Systems, Edition 2.0 (Jukic et. al.) Instructors Manual – Chapter 11
Chapter 11 - ANSWERS (Review Questions)
Q11.1 What are the four components of typical DBMS software?
Data Definition Component
Data Manipulation Component
Database Administration Component
Application Generation Component
Q11.2 What is the purpose of the DBMS data definition component?
The data definition component is used by database designers to create the infrastructure
components of the database, such as database tables and referential integrity constraints
connecting the created tables.
Q11.3 What is the purpose of the DBMS data manipulation component?
The data manipulation component allows the end users to insert, read, update, and delete
information in a database.
Q11.4 What is the purpose of the DBMS data administration component?
The database administration component is used to perform the technical, administrative, and
maintenance tasks of database systems, such as ensuring security, optimizing performance, and
providing backup and recovery.
Q11.5 What is the purpose of the DBMS application development component?
An application development component provides functionalities to the developers of front-end
applications. In some DBMS packages, this component is a part of the DBMS; in other packages,
it is available as an add-on.
Q11.6 What activities are encompassed by database administration?
Monitoring and Maintaining the Database System
Securing the Database against Unauthorized Access
Providing Database Backup and Recovery
Ensuring Database Integrity
Optimizing Database Performance
Developing and Implementing Database Policies and Standards
Q11.7 Give several examples of database system maintenance activities.
Monitoring the use and functioning of the database systems
Managing and upgrading the database software and hardware resources
Conducting upgrades to the structure of the database
IM Chapter 11 - Page 2
