SOLUTIONS MANUAL
Database Systems: Design, Implementation,
& Management
ST
Carlos Coronel and Steven Morris
──────────────────────────────────────────────────
UV
14th Edition
IA
?_
AP
PR
OV
ED
? ?
, TABLE OF CONTENTS
Solutions Manual: Database Systems: Design, Implementation, & Management, 14th
Edition
ST
By Carlos Coronel and Steven Morris
Part 1 Database Concepts
UV
Chapter 1 Database Systems
Chapter 2 Data Models
Part 2 Design Concepts
IA
Chapter 3 The Relational Database Model
Chapter 4 Entity Relationship (ER) Modeling
?_
Chapter 5 Advanced Data Modeling
Chapter 6 Normalization of Database Tables
AP
Part 3 Advanced Design and Implementation
Chapter 7 Introduction to Structured Query Language (SQL)
Chapter 8 Advanced SQL
PR
Chapter 9 Database Design
Part 4 Advanced Database Concepts
OV
Chapter 10 Transaction Management and Concurrency Control
Chapter 11 Database Performance Tuning and Query Optimization
Chapter 12 Distributed Database Management Systems
ED
Chapter 13 Business Intelligence and Data Warehouses
Chapter 14 Big Data and NoSQL
Part 5 Databases and the Internet
??
Chapter 15 Database Connectivity and Web Technologies
Part 6 Database Administration
Chapter 16 Database Administration and Security
1
, Solution and Answer Guide: Coronel and Morris, Database Systems: Design, Implementation and Management,
©2023, 9780357673034; Appendix B: The University Lab: Conceptual Design
Solution and Answer Guide
CORONEL AND MORRIS, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION AND MANAGEMENT,
©2023, 9780357673034; APPENDIX B: THE UNIVERSITY LAB: CONCEPTUAL DESIGN
ST
TABLE OF CONTENTS
Answers to Review Questions...............................................................................................................1
UV
Answers to Problems............................................................................................................................... 6
ANSWERS TO REVIEW QUESTIONS
IA
1. What factors relevant to database design are revealed during the initial study phase?
Answer: The database initial study phase yields the information required to determine an
organization’s needs, as well as the factors that influence data generation, collection, and
?_
processing. Students must understand that this phase is generally concurrent with the
planning phase of the SDLC and that, therefore, several of the initial study activities are
common to both.
The most important discovery of the initial study phase is the set of the company’s objectives.
AP
Once the designer has a clear understanding of the company’s main goals and its mission,
(s)he can use this as the guide to making all subsequent decisions concerning the analysis,
design, and implementation of the database and the information system.
The initial study phase also establishes the company’s organizational structure; the
description of operations, problems and constraints, and alternate solutions; system
PR
objectives; and the proposed system scope and boundaries.
The organizational structure and the description of operations are interdependent because
operations are usually a function of the company’s organizational structure. The
determination of structure and operations allows the designer to analyze the existing system
OV
and to describe a set of problems, constraints, and possible solutions.
Naturally, the designer must find a feasible solution within the existing constraints. In most
cases, the best solution is not necessarily the most feasible one. The constraints also force
the designer to narrow the focus on very specific problems that must be solved.
In short, the combination of all the factors we have just discussed help the designer to put
ED
together a set of realistic, achievable, and measurable system objectives within the system’s
required scope and boundaries.
2. Why is the organizational structure relevant to the database designer?
??
Answer: The delivery of information must be timely, it must reach the right people, and the
delivered information must be accurate. Since the proper use of timely and accurate
information is the key factor in the success of any system, the reports and queries drawn from
the database must reach the key decision makers within the organization. Clearly,
understanding the organization structure helps the designer to define the organization’s lines
of communication and to establish reporting requirements.
, Solution and Answer Guide: Coronel and Morris, Database Systems: Design, Implementation and Management,
©2023, 9780357673034; Appendix B: The University Lab: Conceptual Design
3. What is the difference between the database design scope and its boundaries? Why is the scope
and boundary statement so important to the database designer?
Answer: The system’s boundaries are the limits imposed on the database design by external
constraints such as available budget and time, the current level of technology, and end-user
resistance to change. The scope of a database defines the extent of the database design
ST
coverage and reflects a conscious decision to include some things and exclude others. Note
that the existence of boundaries usually has an effect on the system’s scope.
For legal and practical design reasons, the designer cannot afford to work on an unbounded
system. If the system’s limits have not been adequately defined, the designer may be legally
UV
required to expand the system indefinitely. Moreover, an unbounded system will not contain
the built-in constraints that make its use practical in a real-world environment. For example, a
completely unbounded system will never be completed, nor may it ever be ready for
reasonable use. Even a system with an “optimistic” set of bounds may drag the design out
over many years and may cost too much. Keep in mind that company managers almost
IA
invariably want least-cost solutions to specific problems.
4. What business rule(s) and relationships can be described for the ERD shown in
Figure QB.4?
?_
FIGURE QB.4 The ERD for Question 4
AP
PR
OV
ED
Answer: The business rules and relationships are summarized in Table QB.4.
??
Database Systems: Design, Implementation,
& Management
ST
Carlos Coronel and Steven Morris
──────────────────────────────────────────────────
UV
14th Edition
IA
?_
AP
PR
OV
ED
? ?
, TABLE OF CONTENTS
Solutions Manual: Database Systems: Design, Implementation, & Management, 14th
Edition
ST
By Carlos Coronel and Steven Morris
Part 1 Database Concepts
UV
Chapter 1 Database Systems
Chapter 2 Data Models
Part 2 Design Concepts
IA
Chapter 3 The Relational Database Model
Chapter 4 Entity Relationship (ER) Modeling
?_
Chapter 5 Advanced Data Modeling
Chapter 6 Normalization of Database Tables
AP
Part 3 Advanced Design and Implementation
Chapter 7 Introduction to Structured Query Language (SQL)
Chapter 8 Advanced SQL
PR
Chapter 9 Database Design
Part 4 Advanced Database Concepts
OV
Chapter 10 Transaction Management and Concurrency Control
Chapter 11 Database Performance Tuning and Query Optimization
Chapter 12 Distributed Database Management Systems
ED
Chapter 13 Business Intelligence and Data Warehouses
Chapter 14 Big Data and NoSQL
Part 5 Databases and the Internet
??
Chapter 15 Database Connectivity and Web Technologies
Part 6 Database Administration
Chapter 16 Database Administration and Security
1
, Solution and Answer Guide: Coronel and Morris, Database Systems: Design, Implementation and Management,
©2023, 9780357673034; Appendix B: The University Lab: Conceptual Design
Solution and Answer Guide
CORONEL AND MORRIS, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION AND MANAGEMENT,
©2023, 9780357673034; APPENDIX B: THE UNIVERSITY LAB: CONCEPTUAL DESIGN
ST
TABLE OF CONTENTS
Answers to Review Questions...............................................................................................................1
UV
Answers to Problems............................................................................................................................... 6
ANSWERS TO REVIEW QUESTIONS
IA
1. What factors relevant to database design are revealed during the initial study phase?
Answer: The database initial study phase yields the information required to determine an
organization’s needs, as well as the factors that influence data generation, collection, and
?_
processing. Students must understand that this phase is generally concurrent with the
planning phase of the SDLC and that, therefore, several of the initial study activities are
common to both.
The most important discovery of the initial study phase is the set of the company’s objectives.
AP
Once the designer has a clear understanding of the company’s main goals and its mission,
(s)he can use this as the guide to making all subsequent decisions concerning the analysis,
design, and implementation of the database and the information system.
The initial study phase also establishes the company’s organizational structure; the
description of operations, problems and constraints, and alternate solutions; system
PR
objectives; and the proposed system scope and boundaries.
The organizational structure and the description of operations are interdependent because
operations are usually a function of the company’s organizational structure. The
determination of structure and operations allows the designer to analyze the existing system
OV
and to describe a set of problems, constraints, and possible solutions.
Naturally, the designer must find a feasible solution within the existing constraints. In most
cases, the best solution is not necessarily the most feasible one. The constraints also force
the designer to narrow the focus on very specific problems that must be solved.
In short, the combination of all the factors we have just discussed help the designer to put
ED
together a set of realistic, achievable, and measurable system objectives within the system’s
required scope and boundaries.
2. Why is the organizational structure relevant to the database designer?
??
Answer: The delivery of information must be timely, it must reach the right people, and the
delivered information must be accurate. Since the proper use of timely and accurate
information is the key factor in the success of any system, the reports and queries drawn from
the database must reach the key decision makers within the organization. Clearly,
understanding the organization structure helps the designer to define the organization’s lines
of communication and to establish reporting requirements.
, Solution and Answer Guide: Coronel and Morris, Database Systems: Design, Implementation and Management,
©2023, 9780357673034; Appendix B: The University Lab: Conceptual Design
3. What is the difference between the database design scope and its boundaries? Why is the scope
and boundary statement so important to the database designer?
Answer: The system’s boundaries are the limits imposed on the database design by external
constraints such as available budget and time, the current level of technology, and end-user
resistance to change. The scope of a database defines the extent of the database design
ST
coverage and reflects a conscious decision to include some things and exclude others. Note
that the existence of boundaries usually has an effect on the system’s scope.
For legal and practical design reasons, the designer cannot afford to work on an unbounded
system. If the system’s limits have not been adequately defined, the designer may be legally
UV
required to expand the system indefinitely. Moreover, an unbounded system will not contain
the built-in constraints that make its use practical in a real-world environment. For example, a
completely unbounded system will never be completed, nor may it ever be ready for
reasonable use. Even a system with an “optimistic” set of bounds may drag the design out
over many years and may cost too much. Keep in mind that company managers almost
IA
invariably want least-cost solutions to specific problems.
4. What business rule(s) and relationships can be described for the ERD shown in
Figure QB.4?
?_
FIGURE QB.4 The ERD for Question 4
AP
PR
OV
ED
Answer: The business rules and relationships are summarized in Table QB.4.
??
