Beginning Database Design Solutions
24%
off

Beginning Database Design Solutions

3.75 (41 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 3 business days
When will my order arrive?

Description

This book is intended for IT professionals and students who want to learn how to design, analyze, and understand databases. The material will benefit those who want a better high-level understanding of databases such as proposal managers, architects, project managers, and even customers. The material will also benefit those who will actually design, build, and work with databases such as database designers, database administrators, and programmers. In many projects, these roles overlap so the same person may be responsible for working on the proposal, managing part of the project, and designing and creating the database.
This book is aimed at IT professionals and students of all experience levels. It does not assume that you have any previous experience with databases or programs that use them. It doesn t even assume that you have experience with computers. All you really need is a willingness and desire to learn.


This book explains database design. It tells how to plan a database s structure so the database will be robust, resistant to errors, and flexible enough to accommodate a reasonable amount of future change. It explains how to discover database requirements, build data models to study data needs, and refine those models to improve the database s effectiveness.


The book solidifies these concepts by working through a detailed example that designs a realistic database. Later chapters explain how to actually build databases using two common database products: Access 2007 and MySQL.


The book finishes by describing some of the topics you need to understand to keep a database running effectively such as database maintenance and security.


This book explains database design. It tells how to determine what should go in a database and how the database should be structured to give the best results.


To remain database neutral, the book does not assume you are using a particular database so you don t need any particular software or hardware. To work through the Exercises, all you really need is a pencil and some paper. You are welcome to type solutions into your computer if you like but you may actually find working with pencil and paper easier than using a graphical design tool to draw pictures, at least until you are comfortable with database design and are ready to pick a computerized design tool.
show more

Product details

  • Paperback | 552 pages
  • 187.96 x 233.68 x 33.02mm | 839.14g
  • WROX PRESS
  • Indianapolis, IN, United States
  • English
  • 1. Auflage
  • 0470385499
  • 9780470385494
  • 454,958

Back cover copy

Beginning Database Design Solutions



Databases play a critical role in the business operations of most organizations; they're the central repository for critical information on products, customers, suppliers, sales, and a host of other essential information. It's no wonder that the majority of all business computing involves database applications.



With so much at stake, you'd expect most IT professionals would have a firm understanding of good database design. But in fact most learn through a painful process of trial and error, with predictably poor results.



This book provides readers with proven methods and tools for designing efficient, reliable, and secure databases. Author Rod Stephens explains how a database should be organized to ensure data integrity without sacrificing performance. He shares procedures for designing robust, flexible, and secure databases that provide a solid foundation for all of your database applications. The methods and techniques in this book can be applied to any database environment, including Oracle(R), Microsoft Access(R), SQL Server(R), and MySQL(R). You'll learn the basics of good database design and ultimately discover how to design a real-world database.?



What you will learn from this book



How to identify database requirements that meet users' needs



Ways to build data models using a variety of modeling techniques, including entity-relational models, user-interface models, and semantic object models



Tips for understanding the different types of databases, including relational databases, flat files, spreadsheets, XML and object databases



How to refine and tune the design to improve database performance



Techniques for understanding the relationship between good application design and database design



Methods for designing flexible and robust databases that can adapt to business change and growth



Ways to design for ease of maintenance and support



How to avoid common database design mistakes



Who this book is for



This book is for anyone interested in learning to design, build, analyze, and understand databases. No previous experience with databases or programs is required.



Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.
show more

Table of contents

I. Introduction to Databases and Database Design.
1. Golas of Effective Database Design.


2. Database Types.


3. Relational Database Fundamentals.


II. Database and Design Process Techniques.


4. Understanding User Needs.


5. Translating User Needs Into Data Models.


6. Extracting Business Rules.


7. Normalizing Data.


8. Designing Databases to Support Software Applications.


9. Common Design Patterns.


10. Common Design Pitfalls.


III. A Detailed Case Study.


11. User Needs and Requirements.


12. Building a Data Model.


13. Building a Relastional Model.


14. Extracting Business Rules.


15. Normalization and Refinement.


16. Microsoft Access.


17. MySQL.


IV. Advanced Topics.


18. Introdution to SQL.


19. Building Databases with SQL Scripts.


20. Databse Elements.


21. Database Security.


Appendix A. Exercise Solutions.


Appendix B. Sample Database Designs.


Appendix C. Glossary.


Index.
show more

About Rod Stephens

Rod Stephens is a professional software developer who has built a wide variety of software and database applications in his 20-year career. He is the author of 18 books and more than 250 articles, and is a regular contributor to DevX.com (www.devx.com). Rod's clear, compelling writing makes it easy for less experienced readers to master new material. His current position as an adjunct instructor for ITT Technical institute has given him additional insight into the kinds of discussion, examples, and exercises that students find most helpful.
show more

Rating details

41 ratings
3.75 out of 5 stars
5 24% (10)
4 39% (16)
3 24% (10)
2 12% (5)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X