Database Solutions: A step–by–step guide to building databases
Thomas Connolly, Carolyn Begg
Addison–Wesley Professional
December 1999
Paperback, 448 pages
ISBN: 0201674769
This is a practical ‘hands on‘ guide to database analysis, design and implementation using UML. Students will it a useful supplement to the Author‘s Database Systems as it contains a large number of ample data models, these are ‘cut and paste‘ database solutions to commonly encountered problems which they could find useful when carrying out their assignments.
Features
- Step–by–step instructions on designing and building databases
- Hints and tips for success
- Comprehensive guidance on avoiding pitfalls and traps
- How to create data models using the new design notation, UML (with appendices mapping to Chens notation and the Crows Feet notation)
- Two full length, coded example databases written on Microsoft Access 97 and Oracle 8
- Evaluation copy of Rationals UML visual modelling tool, Rose.
- Shortcuts: 15 sample data models to adapt to your needs, chosen from 7 common business areas, plus SQL scripts for each on the CD–ROM
From the back cover:
Database Solutions:A Step–by–Step Guide to Building Databases by Thomas Connolly & Carolyn Begg
Do you carry the world on your shoulders? Does every request for a new business system from Senior Management land on your desk? Are you responsible for designing and creating the databases that keep your business running? Would you like to make the design and build process smoother, quicker and more reliable?
Recipe for disaster:
- Take one RDMS
- Follow instructions on packet
Recipe for success:
- Take one RDMS n any of the major commercial products will do***Oracle***Informix***SQL Server***Access***Paradox
- Add one thorough reading of Database Solutions if you are an inexperienced database designer, or one recap of the methodology if you are an old hand
- Use the design and implementation frameworks to plan your timetable
- Measure out a common data model that fits your requirements and adapt as necessary
- Weigh up advice and tips from the authors – experienced professionals
Make life easy. Look in this book and CD–ROM for:
- Step–by–step instructions on designing and building databases
- Advice and tips on building a successful database
- Comprehensive guidance on avoiding pitfalls and traps
- How to create data models using the new design notation, UML (with appendices mapping to Chen‘s notation and the Crow‘s Feet notation)
- Shortcuts: 15 sample data models to adapt to your needs, chosen from 7 common business areas, plus SQL scripts for each
- Two full length, coded example databases written on Microsoft Access 97 and Oracle 8
- Evaluation copy of Rational‘s UML visual modelling tool, Rose.
0201674769B04062001
About the Author:
Thomas Connolly was a designer of RAPPORT, the world‘s first commercial portable DBMS, and of the LIFESPAN configuration management tool –– a winner of the British Design Award.
Carolyn Begg specializes in the application of database systems in biological research. They are both authors of the best–selling book Database Systems, also published by Addison–Wesley.
0201674769AB04062001