?
A?
VI
TU
_S
ED
OV
PR
AP
,AP
TABLE OF CONTENTS
Solutions Manual: Database Systems: Design, Implementation, & Management, 14th
PR Edition
By Carlos Coronel and Steven Morris
Part 1
OVDatabase Concepts
Chapter 1 Database Systems
Chapter 2 Data Models ED
Part 2 Design Concepts
Chapter 3 The Relational Database Model
Chapter 4 Entity Relationship (ER) Modeling
Chapter 5 Advanced Data Modeling
_S
Chapter 6 Normalization of Database Tables TU
Part 3 Advanced Design and Implementation
Chapter 7 Introduction to Structured Query Language (SQL)
Chapter 8 Advanced SQL
Chapter 9 Database Design
VI
Part 4 Advanced Database Concepts
Chapter 10 Transaction Management and Concurrency Control
A?
Chapter 11 Database Performance Tuning and Query Optimization ?
Chapter 12 Distributed Database Management Systems
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
AP
CORONEL AND MORRIS, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION AND MANAGEMENT,
©2023, 9780357673034; APPENDIX B: THE UNIVERSITY LAB: CONCEPTUAL DESIGN
TABLE OF CONTENTS
PR
Answers to Review Questions...............................................................................................................1
Answers to Problems............................................................................................................................... 6
ANSWERS
OV
TO REVIEW QUESTIONS
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
E
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
D_
common to both.
The most important discovery of the initial study phase is the set of the company’s objectives.
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.
ST
The initial study phase also establishes the company’s organizational structure; the
description of operations, problems and constraints, and alternate solutions; system
objectives; and the proposed system scope and boundaries. UV
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
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
IA
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
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
AP 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
coverage and reflects a conscious decision to include some things and exclude others. Note
PR 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
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
OV
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
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?
E
FIGURE QB.4 The ERD for Question 4
D_
ST
UV
IA
Answer: The business rules and relationships are summarized in Table QB.4.
??
A?
VI
TU
_S
ED
OV
PR
AP
,AP
TABLE OF CONTENTS
Solutions Manual: Database Systems: Design, Implementation, & Management, 14th
PR Edition
By Carlos Coronel and Steven Morris
Part 1
OVDatabase Concepts
Chapter 1 Database Systems
Chapter 2 Data Models ED
Part 2 Design Concepts
Chapter 3 The Relational Database Model
Chapter 4 Entity Relationship (ER) Modeling
Chapter 5 Advanced Data Modeling
_S
Chapter 6 Normalization of Database Tables TU
Part 3 Advanced Design and Implementation
Chapter 7 Introduction to Structured Query Language (SQL)
Chapter 8 Advanced SQL
Chapter 9 Database Design
VI
Part 4 Advanced Database Concepts
Chapter 10 Transaction Management and Concurrency Control
A?
Chapter 11 Database Performance Tuning and Query Optimization ?
Chapter 12 Distributed Database Management Systems
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
AP
CORONEL AND MORRIS, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION AND MANAGEMENT,
©2023, 9780357673034; APPENDIX B: THE UNIVERSITY LAB: CONCEPTUAL DESIGN
TABLE OF CONTENTS
PR
Answers to Review Questions...............................................................................................................1
Answers to Problems............................................................................................................................... 6
ANSWERS
OV
TO REVIEW QUESTIONS
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
E
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
D_
common to both.
The most important discovery of the initial study phase is the set of the company’s objectives.
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.
ST
The initial study phase also establishes the company’s organizational structure; the
description of operations, problems and constraints, and alternate solutions; system
objectives; and the proposed system scope and boundaries. UV
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
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
IA
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
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
AP 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
coverage and reflects a conscious decision to include some things and exclude others. Note
PR 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
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
OV
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
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?
E
FIGURE QB.4 The ERD for Question 4
D_
ST
UV
IA
Answer: The business rules and relationships are summarized in Table QB.4.
??
