Database Solutions: A Step-by-Step Approach to Building Databases / Edition 2

Database Solutions: A Step-by-Step Approach to Building Databases / Edition 2

by Carolyn E. Begg, Carolyn E. Begg, Thomas M. Connolly
     
 

ISBN-10: 0321173503

ISBN-13: 9780321173508

Pub. Date: 09/15/2003

Publisher: Addison-Wesley

The second edition of this book incorporates two relational database design methodologies to teach readers how databases can be implemented in Microsoft Access and Oracle. Not only does the book provide a comprehensive methodology for relational database design, but the authors also show readers how to use the latest installation of UML. Fifteen sample database
See more details below

Overview

The second edition of this book incorporates two relational database design methodologies to teach readers how databases can be implemented in Microsoft Access and Oracle. Not only does the book provide a comprehensive methodology for relational database design, but the authors also show readers how to use the latest installation of UML. Fifteen sample database designs chosen from seven common business areas are located in an Appendix, and an evaluation copy of Rational Rose software is included on the accompanying CD-ROM. Database designers wanting to learn more about relational database theory as well as those just wanting to expand there general database technology knowledge.

Product Details

ISBN-13:
9780321173508
Publisher:
Addison-Wesley
Publication date:
09/15/2003
Edition description:
REV
Pages:
496
Product dimensions:
7.30(w) x 9.10(h) x 1.10(d)

Table of Contents

I. BACKGROUND.

 1. Introduction.

 2. The Relational Model.

 3. SQL and QBE.

 4. The Database System Development Lifecycle.

 5. Database Administration and Security.

II. DATABASE ANALYSIS AND DESIGN TECHNIQUES.

 6. Fact-Finding.

 7. Entity-Relationship Modeling.

 8. Normalization.

III. LOGICAL DATABASE DESIGN METHODOLOGY.

 9. Logical Database Design-Step One.

10. Logical Database Design-Step Two.

11. Enhanced ER Modeling.

IV. PHYSICAL DATABASE DESIGN METHODOLOGY.

12. Physical Database Design-Step Three.

13. Physical Database Design-Step Four.

14. Physical Database Design-Steps Five and Six.

15. Physical Database Design-Step Seven.

16. Physical Database Design-Step Eight.

V. SECOND WORKED EXAMPLE.

17. PerfectPets-Logical Database Design.

18. PerfectPets-Physical Database Design.

VI. CURRENT AND EMERGING TRENDS.

19. Current and Emerging Trends.

APPENDICES.

A. Alternative Modeling Notations.

B. Summary of the Methodology.

C. Advanced Logical Database Design.

D. File Organizations and Indexes.

E. Common Data Models.

Glossary.

References.

Index.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >