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.
Beginning Database Design Solutions
and over 1.5 million other books are available for Amazon Kindle . Learn more
| ||||||||||||||||||
 Trade In this Item for up to £1.40
Trade in Beginning Database Design Solutions (Wrox Programmer to Programmer) for an Amazon.co.uk gift card of up to £1.40, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
|
Book Description
Frequently Bought Together
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, and more.
Product Description
From the Back Cover
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®, Microsoft Access®, SQL Server®, and MySQL®. 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.
Inside This Book
(Learn More)
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
By KS Beale
Format:Paperback|Amazon Verified Purchase
The first thing I liked about this book is the style in which it is written. It is clear and concise, very good examples and splashed with a little humour. It will remain won my bookshelf as a reference until such time it is superceded or updated to encompass the Entity Framework.
By Mr D kairos
Format:Paperback|Amazon Verified Purchase
Excellent book but a bit of overkill on some topics. It was very helpfull for my project and I will recommend to fellow DB architects
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
4.6 out of 5 stars
18 reviews
20 of 22 people found the following review helpful
5.0 out of 5 stars
The database design book for everyone
16 Jan 2009
By Leonard Ansin
- Published on Amazon.com
Format:Paperback
Database Design Solutions, By Rod Stephens is a book that offers "expert practical experience" to assist the reader in creating a flexible and robust database even if this is your first database. A database properly designed from the start will prove rewarding and beneficial to the users. A poorly designed database, will lead to continuing headaches and frustration for the developer and most likely lost customers.
The book is clear, well written and appeals to the readers. It covers a lot of ground in different chapters. It guides you in developing business rules, explains what normalization is and gives an overview of different types of databases such as Access, SQL and My Sql. It will direct you how to start SQL statements and query constructions.
My feeling is of all the chapters in the book, the best are Chapter 4, Understanding User Needs, Chapter 7, Normalization, Chapter 9, Common Design Patterns and Chapter 10, Common Design Pitfalls. These were the most informative that appealed to me.
No matter whether you are a beginner or an experienced Database developer, this book is a must for you. It will give you the basics to start the development correctly and if you are experienced, it gives you the support to be sure your doing existing databases correctly.
This book is a must read for anyone doing database development.
By Leonard Ansin (Waltham, MA USA)
The book is clear, well written and appeals to the readers. It covers a lot of ground in different chapters. It guides you in developing business rules, explains what normalization is and gives an overview of different types of databases such as Access, SQL and My Sql. It will direct you how to start SQL statements and query constructions.
My feeling is of all the chapters in the book, the best are Chapter 4, Understanding User Needs, Chapter 7, Normalization, Chapter 9, Common Design Patterns and Chapter 10, Common Design Pitfalls. These were the most informative that appealed to me.
No matter whether you are a beginner or an experienced Database developer, this book is a must for you. It will give you the basics to start the development correctly and if you are experienced, it gives you the support to be sure your doing existing databases correctly.
This book is a must read for anyone doing database development.
By Leonard Ansin (Waltham, MA USA)
14 of 15 people found the following review helpful
5.0 out of 5 stars
Highly Appreciative
18 Feb 2009
By DM
- Published on Amazon.com
Format:Paperback
I am the director (and sole employee) of a newly formed non-profit. I came to this book with little prior programming experience, and found it to be all I was looking for as far as designing a database to meet our foundation's needs. A real strength of the book is that the author walks you through a wealth of examples, and provides many more to think through on your own--all with answers in the back of the book. So it's almost guaranteed there will be something which matches or parallels what you are trying to do. I read the book straight through, and found the order in which the material was presented to be logical and very well thought out. I also appreciated the dry humor sprinkled throughout this book--I would often find myself perking up and smiling to myself through a subject which a lesser author could turn into tedium.
14 of 16 people found the following review helpful
5.0 out of 5 stars
The Book I Wish I'd Had
5 Jan 2009
By Lawrence Landis
- Published on Amazon.com
Format:Paperback
Several years ago, I was "volunteered" to design a database - without any previous database experience. I succeeded, and learned a great deal from all the mistakes I made. But I'd probably have had a lot more fun and certainly taken less time if I'd had Beginning Database Design Solutions as an aid and reference. Unlike many database books (indeed, far too many software books in general), it concentrates on designing first, instead of writing code before you know what the user really wants/needs. Chapters also cover creating a database in Microsoft Access and in MySQL, so you can see theory put into practice.
If you're new to databases, this is an excellent place to start. The conversational tone and many illustrations make for an enjoyable read to which you'll refer often. A particulary nice addition is a very handy glossary.
Since it includes exercises, it can be used for classroom instruction; however, solutions are included in an appendix, making it suitable for individual study as well.
Highly recommended.
If you're new to databases, this is an excellent place to start. The conversational tone and many illustrations make for an enjoyable read to which you'll refer often. A particulary nice addition is a very handy glossary.
Since it includes exercises, it can be used for classroom instruction; however, solutions are included in an appendix, making it suitable for individual study as well.
Highly recommended.
›
Go to Amazon.com to see all 18 reviews
4.6 out of 5 stars
Were these reviews helpful?
Let us know
Customer Discussions
|
This product's forum
Search Customer Discussions
|
Related forums
|
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Data Storage & Management > Data Warehousing
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Software & Graphics
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
