Contents
Preface
1The Database Environment
2Database Development Process
3The Entity-Relationship Model
4The Enhanced E-R Model and Business Rules
5Object-Oriented Modeling
6Logical Database Design and the Relational Model
7Physical Database Design
8Client/Server and Middleware
9SQL
10Database Access from Client Applications
11Distributed Databases
12Object-Oriented Database Development
13Data and Database Administration
14Data Warehouse
15Test Bank
Preface
This Instructor's Manual is designed to make teaching from Modern Database Management as convenient and rewarding as possible. For each chapter in the textbook, this manual provides the following:
Chapter Objectives A brief statement that sets forth the major objectives of the chapter and relates the chapter to the overall design of the text. This includes a list of instructor objectives to help prioritize chapter topics. Student learning objectives are included at the beginning of each chapter in the textbook. We also note major changes in the text from the corresponding chapter in the fourth edition.
Classroom Ideas Discussion questions, classroom exercises, notes on the use of transparencies, and references to recent articles and other current literature form the basis for these teach suggestions. Many of the Classroom Ideas have originated from our students and other instructors, and we welcome your suggestions, which may be posted to our web site, located under the keyword, McFadden, at
Answers to Review Questions The review questions in each chapter of the text range from simple definitions to in-depth discussion questions. These questions (and the answers provided here) may be used as examination questions and/or as a foundation for classroom discussion. You may want to strongly encourage your students to use these questions and the key terms in each chapter to study for examinations.
Answers to Problems and Exercises Each chapter of the text contains problems and exercises, ranging from simple matching exercises to problems requiring a graphical or quantitative solution or DBMS code. These problems may be used for homework assignments, in-class exercises, and/or examination questions.
Suggestions for Field Exercises The field exercises at the back of each chapter suggest activities that students may undertake in their community. To the extent that time and resources permit, we hope these exercises will help students to better understand the concepts in the book in a more practical manner. The nature of the exercises does not result in definitive answers, but where possible, we have included suggestions that have been helpful for us in working with our students.
Project Case The Mountain View Community Hospital case is included at the end of each chapter. Suggested solutions to the project questions and project exercises have been included. In general, these solutions cover the essentials of the case material, but instructors who want to emphasize the case material will find that their students produce more elaborate solutions, probably in proportion to the time they spend working on the case material.
In addition, the textbook can be purchased with or without accompanying Oracle software. Personal Oracle 7.3.4, Designer/2000 and Developer/2000 are included in the Oracle Edition of the textbook. The Instructor's CD-ROM contains this Instructor's Manual in Word7 format on the CD-ROM, along with a Microsoft PowerPoint presentation for each chapter. A computerized test bank is also included. The web site will be developed over time, but will initially include the Microsoft Access 97 sample database for Pine Valley Furniture, instructions for installing the Oracle software included with the Oracle Edition, notice board, and so forth.
For information about the fifth edition of Modern Database Management and its supplements and web site, or to request the software described above, please contact your Addison Wesley Longman representative or call (800) 552-5499.
The authors gratefully acknowledge the support of our students (past and present) who in so many ways have contributed to this Instructor's Manual and have continually suggested improvements to the test questions and other materials. Particular thanks go to several people who have contributed substantially to the Instructor's Manual, including Fred McFadden, and Atish Sinha and Doug Hodson of the University of Dayton. Of course, we are responsible for any errors that remain.
Mary B. Prescott
Zornitza Genova