?
??
IA
UV
ST
,TABLE OF CONTENTS
Solutions Manual: Database Design, Query, Formulation, and
Administration Using Oracle and PostgreSQL, 8th Edition
Author: Michael Mannino
Chapter 1. Introduction to Database Management
Chapter 2. Introduction to Database Development
Chapter 3. The Relational Data Model in the SQL Standard
Chapter 4. Query Formulation with SQL
ST
Chapter 5. Understanding Entity Relationship Diagrams
Chapter 6. Developing Data Models for Business Databases
Chapter 7. Normalization Concepts and Processes
UV
Chapter 8. Physical Database Design
Chapter 9. Advanced Matching Problems
Chapter 10. Views, Null Values, and Hierarchical Queries
Chapter 11. Stored Procedures and Triggers
IA
Chapter 12. Data Warehouse Concepts and Management
Chapter 13. Conceptual Design of Data Warehouses
Chapter 14. Data Integration Concepts and Practices
??
Chapter 15. Query Formulation for Data Warehouses
Chapter 16. Data and Database Administration
Chapter 17. Transaction Management
Chapter 18. Client-Server Processing, Parallel Database Processing, and Distributed Databases
?
Chapter 19. DBMS Extensions for Object and NoSQL Databases
,Solutions Manual for Database Design, Query, Formulation, and Administration Using Oracle and Postgre SQL 8th Edition By Michael Mannino (Sage)
Chapter 1
QUESTIONS
1. Describe a database that you have used on a job or as a consumer. List the
entities and relationships that the database contains. If you are not sure,
imagine the entities and relationships that are contained in the database.
Ans: Students' responses will vary. However, in the example of the
University Database, the entities are students, faculty, courses, offerings, and
enrollments. The relationships are faculty teaches offerings, students enroll in
offerings, offerings made of courses and faculty supervises faculties.
2. For the database in question 1, list different user groups that can use the
database.
ST
Ans: Students' responses will vary. However, some examples of user groups
for the University database are students, faculty, and university staff.
3. For one of the groups in question 2, describe an application (form or report)
UV
that the group uses.
Ans: Students' responses will vary. However, some examples of applications
for the University database are that the user group of student can use the
registration form, transcript (the report of grade). The user group of
university’s staff can use the assignment form. The user group of faculty can
use the report of faculty workload.
IA
4. Explain the persistent property for databases.
Ans: Persistent means that data resides on stable storage such as a magnetic
disk. For example, organizations need to retain data about customers,
??
suppliers, and inventory on stable storage because these data are repetitively
used. A variable in a computer program is not persistent because it resides in
main memory and disappears after the program terminates. Persistency does
not mean that data lasts forever. When data are no longer relevant (such as a
supplier going out of business), they are removed or archived.
?
5. Explain the inter-related property for databases.
Ans: Inter-related means that data stored as separate units can be connected to
provide a whole picture. For example, a customer database relates customer
data (name, address, …) to order data (order number, order date, …) to
facilitate order processing. Databases contain both entities and relationships
among entities. An entity is a cluster of data usually about a single topic that
can be accessed together. An entity may denote a person, place, thing, or
event.
, Solutions Manual for Database Design, Query, Formulation, and Administration Using Oracle and Postgre SQL 8th Edition By Michael Mannino (Sage)
6. Explain the shared property for databases.
Ans: Shared means that a database can have multiple uses and users. A
database provides a common memory for multiple functions in an
organization. For example, a personnel database can support payroll
calculations, performance evaluations, government reporting requirements,
and so on. Many users can use a database at the same time. For example,
many customers can simultaneously make airline reservations. Unless two
users are trying to change the same part of the database at the same time, they
can proceed without waiting.
7. What is a DBMS?
Ans: A database management system (DBMS) is a collection of software that
supports the creation, use, and maintenance of databases. Initially, DBMSs
ST
provided efficient storage and retrieval of data. Due to marketplace demands
and product innovation, DBMSs have evolved to provide a broad range of
features for data acquisition, storage, dissemination, maintenance, retrieval,
and formatting. The evolution of these features has made DBMSs rather
complex.
UV
8. What is SQL?
Ans: The Structured Query Language (SQL) is an industry standard language
supported by most DBMSs. SQL contains statements for data definition, data
manipulation, and data control.
IA
9. Describe the difference between a procedural and a non-procedural
language. What statements belong in a procedural language but not in a
nonprocedural language?
??
Ans: A nonprocedural language allows users with limited computing skills to
submit queries instead of coding complex procedures. Nonprocedural
languages specify what parts of a database to retrieve, not the detail of how
retrieval occurs as compared to procedural language.
?
Statements that belong in a procedural language but not in a nonprocedural
language are looping statements (for, while, and so on).
10. Why is non-procedural access an important feature of DBMS?
Ans: Non-procedural access can reduce the number of lines of code by a
factor of 100 as compared to procedural access. Because a large part of
business software involves data access, non-procedural access can provide a
dramatic improvement in software productivity.
11. What is a procedural language interface?
??
IA
UV
ST
,TABLE OF CONTENTS
Solutions Manual: Database Design, Query, Formulation, and
Administration Using Oracle and PostgreSQL, 8th Edition
Author: Michael Mannino
Chapter 1. Introduction to Database Management
Chapter 2. Introduction to Database Development
Chapter 3. The Relational Data Model in the SQL Standard
Chapter 4. Query Formulation with SQL
ST
Chapter 5. Understanding Entity Relationship Diagrams
Chapter 6. Developing Data Models for Business Databases
Chapter 7. Normalization Concepts and Processes
UV
Chapter 8. Physical Database Design
Chapter 9. Advanced Matching Problems
Chapter 10. Views, Null Values, and Hierarchical Queries
Chapter 11. Stored Procedures and Triggers
IA
Chapter 12. Data Warehouse Concepts and Management
Chapter 13. Conceptual Design of Data Warehouses
Chapter 14. Data Integration Concepts and Practices
??
Chapter 15. Query Formulation for Data Warehouses
Chapter 16. Data and Database Administration
Chapter 17. Transaction Management
Chapter 18. Client-Server Processing, Parallel Database Processing, and Distributed Databases
?
Chapter 19. DBMS Extensions for Object and NoSQL Databases
,Solutions Manual for Database Design, Query, Formulation, and Administration Using Oracle and Postgre SQL 8th Edition By Michael Mannino (Sage)
Chapter 1
QUESTIONS
1. Describe a database that you have used on a job or as a consumer. List the
entities and relationships that the database contains. If you are not sure,
imagine the entities and relationships that are contained in the database.
Ans: Students' responses will vary. However, in the example of the
University Database, the entities are students, faculty, courses, offerings, and
enrollments. The relationships are faculty teaches offerings, students enroll in
offerings, offerings made of courses and faculty supervises faculties.
2. For the database in question 1, list different user groups that can use the
database.
ST
Ans: Students' responses will vary. However, some examples of user groups
for the University database are students, faculty, and university staff.
3. For one of the groups in question 2, describe an application (form or report)
UV
that the group uses.
Ans: Students' responses will vary. However, some examples of applications
for the University database are that the user group of student can use the
registration form, transcript (the report of grade). The user group of
university’s staff can use the assignment form. The user group of faculty can
use the report of faculty workload.
IA
4. Explain the persistent property for databases.
Ans: Persistent means that data resides on stable storage such as a magnetic
disk. For example, organizations need to retain data about customers,
??
suppliers, and inventory on stable storage because these data are repetitively
used. A variable in a computer program is not persistent because it resides in
main memory and disappears after the program terminates. Persistency does
not mean that data lasts forever. When data are no longer relevant (such as a
supplier going out of business), they are removed or archived.
?
5. Explain the inter-related property for databases.
Ans: Inter-related means that data stored as separate units can be connected to
provide a whole picture. For example, a customer database relates customer
data (name, address, …) to order data (order number, order date, …) to
facilitate order processing. Databases contain both entities and relationships
among entities. An entity is a cluster of data usually about a single topic that
can be accessed together. An entity may denote a person, place, thing, or
event.
, Solutions Manual for Database Design, Query, Formulation, and Administration Using Oracle and Postgre SQL 8th Edition By Michael Mannino (Sage)
6. Explain the shared property for databases.
Ans: Shared means that a database can have multiple uses and users. A
database provides a common memory for multiple functions in an
organization. For example, a personnel database can support payroll
calculations, performance evaluations, government reporting requirements,
and so on. Many users can use a database at the same time. For example,
many customers can simultaneously make airline reservations. Unless two
users are trying to change the same part of the database at the same time, they
can proceed without waiting.
7. What is a DBMS?
Ans: A database management system (DBMS) is a collection of software that
supports the creation, use, and maintenance of databases. Initially, DBMSs
ST
provided efficient storage and retrieval of data. Due to marketplace demands
and product innovation, DBMSs have evolved to provide a broad range of
features for data acquisition, storage, dissemination, maintenance, retrieval,
and formatting. The evolution of these features has made DBMSs rather
complex.
UV
8. What is SQL?
Ans: The Structured Query Language (SQL) is an industry standard language
supported by most DBMSs. SQL contains statements for data definition, data
manipulation, and data control.
IA
9. Describe the difference between a procedural and a non-procedural
language. What statements belong in a procedural language but not in a
nonprocedural language?
??
Ans: A nonprocedural language allows users with limited computing skills to
submit queries instead of coding complex procedures. Nonprocedural
languages specify what parts of a database to retrieve, not the detail of how
retrieval occurs as compared to procedural language.
?
Statements that belong in a procedural language but not in a nonprocedural
language are looping statements (for, while, and so on).
10. Why is non-procedural access an important feature of DBMS?
Ans: Non-procedural access can reduce the number of lines of code by a
factor of 100 as compared to procedural access. Because a large part of
business software involves data access, non-procedural access can provide a
dramatic improvement in software productivity.
11. What is a procedural language interface?
