Beginning Database Design Solutions

3.74 avg rating
( 38 ratings by Goodreads )
 
9780470385494: Beginning Database Design Solutions

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.

"synopsis" may belong to another edition of this title.

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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

International Edition
International Edition

1.

Stephens
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Paperback Quantity Available: 5
International Edition
Seller:
PRIORITY BOOKS
(Springfield, VA, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. Softcover Book, New Condition, Fast Shipping. Ready in Stock. 1st Edition. [Please Read Carefully Before Buying], This Is An International Edition. Printed In Black and White. , Book Cover And ISBN No May Be Different From US Edition. Restricted Sales Disclaimer Wordings Not For Sales In USA And Canada May Be Printed On The Cover Of The Book. Standard Shipping 7-14 Business Days. Expedited Shiping 4-8 Business Days. ***WE DO NOT ENTERTAIN BULK ORDERS.*** The Books May Be Ship From Overseas For Inventory Purpose. Bookseller Inventory # 436057

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 21.84
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

2.

Rod Stephens
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Softcover First Edition Quantity Available: > 20
International Edition
Seller:
LowPriceBookDeals
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description Softcover. Book Condition: New. 1st edition. Brand NEW, Paperback International Edition. Black & White or color, Cover and ISBN may be different but similar contents as US editions. Standard delivery takes 5-9 business days by USPS with tracking number. Choose expedited shipping for superfast delivery 2-4 business days by DHL/FEDEX. We also ship to PO Box addresses but by Standard delivery. International Edition Textbooks may bear a label -Not for sale in the U.S. or Canada- etc. printed only to discourage U.S. students from obtaining an affordable copy. Legal to use despite any disclaimer on cover as per US court. No access code or CD included unless specified. In some instances, the international textbooks may have different exercises at the end of the chapters. Printed in English. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. 100% Customer satisfaction guaranteed! Please feel free to contact us for any queries. Bookseller Inventory # LPBD31424131

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 21.89
Convert Currency

Add to Basket

Shipping: US$ 3.95
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

3.

Stephens
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Paperback Quantity Available: 1
International Edition
Seller:
Nick Book House
(Fresno, CA, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. New, Softcover International Edition, Printed in Black and White, Only USPS Media mail Shipping ONLY, Different ISBN, Same Content As US edition, Book Cover may be Different, in English Language. Bookseller Inventory # 4600

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 21.87
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

4.

Rod Stephens
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Quantity Available: 2
Seller:
Grandisbooks
(Neptune, NJ, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Bookseller Inventory # 314DWN000J16

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 21.89
Convert Currency

Add to Basket

Shipping: US$ 4.00
Within U.S.A.
Destination, Rates & Speeds

5.

Rod Stephens
Published by John Wiley and Sons
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Quantity Available: > 20
Seller:
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description John Wiley and Sons. Book Condition: New. Brand New. Bookseller Inventory # 0470385499

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 24.93
Convert Currency

Add to Basket

Shipping: US$ 3.50
Within U.S.A.
Destination, Rates & Speeds

6.

Rod Stephens
Published by John Wiley Sons Inc, United States (2008)
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Paperback First Edition Quantity Available: 1
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description John Wiley Sons Inc, United States, 2008. Paperback. Book Condition: New. 1. Auflage. Language: English . Brand New Book. 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. Bookseller Inventory # AAH9780470385494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 31.08
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

7.

Rod Stephens
Published by John Wiley Sons Inc, United States (2008)
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Paperback First Edition Quantity Available: 1
Seller:
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description John Wiley Sons Inc, United States, 2008. Paperback. Book Condition: New. 1. Auflage. Language: English . Brand New Book. 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. Bookseller Inventory # AAH9780470385494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 32.31
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Stephens, Rod
Published by Wrox
ISBN 10: 0470385499 ISBN 13: 9780470385494
New PAPERBACK Quantity Available: > 20
Seller:
Mediaoutlet12345
(Springfield, VA, U.S.A.)
Rating
[?]

Book Description Wrox. PAPERBACK. Book Condition: New. 0470385499 *BRAND NEW* Ships Same Day or Next!. Bookseller Inventory # NATARAJB1FI934504

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 28.96
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

9.

Stephens, Rod
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Quantity Available: 3
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2008. PAP. Book Condition: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # IB-9780470385494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 29.58
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

10.

Rod Stephens
Published by Wrox
ISBN 10: 0470385499 ISBN 13: 9780470385494
New Paperback Quantity Available: 5
Seller:
THE SAINT BOOKSTORE
(Southport, United Kingdom)
Rating
[?]

Book Description Wrox. Paperback. Book Condition: New. New copy - Usually dispatched within 2 working days. Bookseller Inventory # B9780470385494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 27.32
Convert Currency

Add to Basket

Shipping: US$ 9.15
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book