Chapter 4 Problem and Exercise #14 (p. 196) and #24 (p. 197).
2.Chapter 5 Problems and Exercises #8 (p. 234) and#21 (p. 235).
Note:Please use the following shorthand for tables and attributes in your assignment:
TABLENAME ( Primarykey, Attributename, Attributename, … )
This page intentionally left blank Eleventh Edition MODERN DATABASE MANAGEMENT Jeffrey A. Hoffer University of Dayton V. Ramesh Indiana University Heikki Topi Bentley University Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montréal Toronto Delhi Mexico City São Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editor in Chief: Stephanie Wall Executive Editor: Bob Horan Editorial Project Manager: Kelly Loftus Editorial Assistant: Ashlee Bradbury Director of Marketing: Maggie Moylan Executive Marketing Manager: Anne Fahlgren Senior Managing Editor: Judy Leale Production Project Manager: Jane Bonnell Senior Operations Supervisor: Arnold Vila Operations Specialist: Maura Zaldivar-Garcia Creative Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Fotolia/business carte © Studio M #38140965 Media Project Manager, Editorial: Allison Longley Media Project Manager, Production: Lisa Rinaldi Composition/Full-Service Project Management: PreMediaGlobal Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: 10/12 PalatinoLTStd Roman Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on the appropriate page within text. Microsoft and/or its respective suppliers make no representations about the suitability of the information contained in the documents and related graphics published as part of the services for any purpose.