Business Database Systems.pdf

(11659 KB) Pobierz
Thomas
Connolly
Carolyn
Begg
Richard
Holowczak
BUSINESS
DATABASE
SYSTEMS
BU S I NE S S DATABA SE
S YS TE M S
Visit the
Business Database Systems
Companion Website at
www.pearsoned.co.uk/connolly
to find valuable
student
learning
material including:
n
n
n
n
Lecture slides
An implementation of the
StayHome Online Rentals
database system
in Microsoft Access®
An SQL script for each common data model described in Appendix I
to create the corresponding set of base tables for the database
system
An SQL script to create an implementation of the
Perfect Pets
database system
We work with leading authors to develop the
strongest educational materials in computing,
bringing cutting-edge thinking and best
learning practice to a global market
Under a range of well-known imprints, including
Addison-Wesley, we craft high quality print and
electronic publications which help readers to
understand and apply their content,
whether studying or at work
To find out more about the complete range of our
publishing, please visit us on the World Wide Web at:
www.pearsoned.co.uk
BUSINESS DATABASE
SYSTEMS
Thomas Connolly
School of Computing
University of the West of Scotland
Carolyn Begg
School of Computing
University of the West of Scotland
Richard Holowczak
Department of Statistics and Computer Information Systems
Zicklin School of Business, Baruch College
City University of New York
Pearson Education Limited
Edinburgh Gate
Harlow
Essex CM20 2JE
England
and Associated Companies throughout the world
Visit us on the World Wide Web at:
www.pearsoned.co.uk
First published 2008
© Pearson Education Limited 2008
The rights of Carolyn Begg and Richard Holowczak to be identified as authors of this work
have been asserted by them in accordance with the Copyright, Designs and Patents Act 1988.
All rights reserved. No part of this publication may be reproduced, stored in
a retrieval system, or transmitted in any form or by any means, electronic,
mechanical, photocopying, recording or otherwise, without either the prior
written permission of the publisher or a licence permitting restricted copying
in the United Kingdom issued by the Copyright Licensing Agency Ltd,
Saffron House, 6-10 Kirby Street, London EC1N 8TS.
The programs in this book have been included for their instructional value.
They have been tested with care but are not guaranteed for any particular
purpose. The publisher does not offer any warranties or representations nor
does it accept any liabilities with respect to the programs.
All trademarks used herein are the property of their respective owners.
The use of any trademark in this text does not vest in the author or publisher
any trademark ownership rights in such trademarks, nor does the use of such
trademarks imply any affiliation with or endorsement of this book by such owners.
Software screenshots are reproduced with permission of Microsoft corporation.
ISBN 978-1-4058-7437-3
British Library Cataloguing-in-Publication Data
A catalogue record for this book is available from the British Library
Library of Congress Cataloging-in-Publication Data
Connolly, Thomas.
Business database systems / Thomas Connolly, Carolyn Begg, Richard
Holowczak.
p. cm.
Includes bibliographical references and index.
ISBN 978-1-4058-7437-3 (pbk.)
1. Business—Databases. 2. Database management. 3. Database design.
4. Management information systems. I. Begg, Carolyn E.
II. Holowczak, Richard. III. Title.
HF5548.2.C623 2008
005.74 —dc22
2008013992
10
12
9 8 7 6 5 4
11 10 09 08
3 2
1
Typeset in 10/12 pt Times by 35
Printed and bound by Rotolito Lombarda, Italy
The publisher’s policy is to use paper manufactured from sustainable forests.
Zgłoś jeśli naruszono regulamin